Develop your own chatbot in Power Apps

Recently a new feature to added to Power Apps to add your Power Virtual Agent chatbot in Power Apps. In this post the step by step guide. Enable the Chatbot component feature In the settings of your app all you have to do is enable the Chatbot component feature and you are up and running. Then of course don’t forget to save your app and restart the Power Apps studio and reopen you app. Adding the Chatbot to your app Now you can...

Read More

SharePoint Enterprise Content Types and the Graph API

Following my posts about the Content Type Gallery and my series about the Graph API, today a post about Enterprise Content Types in SharePoint and how to access them through the Graph API. Creating an Enterprise Content Type From the SharePoint admin center I have created an Enterprise Content Type as shown below: Then within my Content Type I’ve created an Enterprise Content Type Site Column as shown below. Both my content type...

Read More
Culture is king ? Do you agree? – YouTube
Jun01

Culture is king ? Do you agree? – YouTube

Culture is king ? Do you agree? Today Thomas Robbins explores why culture needs to be addressed by leaders in the modern workplace ? Matilda Harding’s opinion up next… #leadership #workplaceculture #sofasessions Today Thomas Robbins explores why culture needs to be addressed by leaders in the modern workplace ? Matilda Harding’s opinion up next… #leadership #workplaceculture #sofasessions...

Read More
Ever wondered what happens to your ticket once it’s raised with the helpdesk?? – YouTube
Jun01

Ever wondered what happens to your ticket once it’s raised with the helpdesk?? – YouTube

Ever wondered what happens to your ticket once it’s raised with the helpdesk?? We are proud of our ticket management system, led by a team of #ITIL practitioners with a wide range of expertise ⚡ Today, Nathan our Cloud Engineer takes us along the lifecycle of a ticket to give you a bit of an insight of BTS ? #helpdesksupport #ithelpdesk #itilcertified We are proud of our ticket management system, led by a team of #ITIL practitioners...

Read More

Intelligent meeting recap in Teams Premium – Quick overview

It’s there – AI notes for your Teams meeting! Microsoft released it a few weeks ago as a Preview feature and it’s available (but not globally). Intelligent meeting recap automatically generates a summary of your meeting with suggested notes. Is it good or is it bad? What’s still missing? Let’s go and test this brand-new […] Continue Reading Marcin Siewnicki’s Article on their blog Intelligent meeting recap in Teams Premium...

Read More

Stop missing reminders in Outlook

Do you ever miss the start of a meeting because those reminders don’t pop up when you want them to pop up? Do you want to stop missing reminders? Reminders in Outlook 15 minutes before a meeting starts reminders will appear (unless you have disabled this) while you work on other things. This can really help you avoid missing meetings. Recently however I noticed that when I ignore reminders and don’t dismiss them that the...

Read More
Looking back at Experts Live NL
May30

Looking back at Experts Live NL

On Thursday 25 May 2023, it was time for the 11th edition of Experts Live NL. Again, in Congrescentrum 1931 in 's-Hertogenbosch. For me, this adventure started much earlier. Like the previous editions, I was again in the Program Panel this year. Under the leadership of Kenneth van Surksum and Erik Loef, they provide input and shape to the program of Experts Live NL. Then, on April 3, 2023, I… Continue Reading Jeroen...

Read More
Top 3 requests a helpdesk team should NEVER ask you – YouTube
May22

Top 3 requests a helpdesk team should NEVER ask you – YouTube

Top 3 requests a helpdesk team should NEVER ask you Our 2nd-Line Cloud Engineer Nathan, sits down with Jennifer to go through some of the BASIC requests a helpdesk team should never ask! ? His top 3… ? We will never ask you to click a link via email ? We would never ask for your password ? MFA codes – we will never send a request for this information Want to know more about how your business can adopt a Zero-Trust approach? Find...

Read More

Don’t Update or Insert records in Dataverse but Upsert when using Power Automate

A typical pattern for data import processes is that you first check if an item exists before either inserting or updating the found item. Upsert (Update or Insert) the item in one operation is however better. Update or Insert So the base process could look something like this. We first get the flow to check if the item already exists and then when it doesn’t exist we can add the item. However there is a bit of time between those...

Read More

How to Migrate Teams Wikis to OneNote

The latest Teams update enabled Wiki migration to Microsoft OneNote. This feature is the next step in Wiki retiring process which should be finalized in the upcoming months. Right now, you can move all your existing Wiki content to OneNote using a built-in migration wizard. Wiki in Teams The Wiki tab was the main note […] Continue Reading Marcin Siewnicki’s Article on their blog How to Migrate Teams Wikis to OneNote The...

Read More
Welsh Azure User Group May 2023 Meet Up!
May18

Welsh Azure User Group May 2023 Meet Up!

It was the day of our Welsh Azure User Group #WAUG May 2023 meet up and we had yet another two brilliant speakers join us with Ben Pearce from Elevated You helped us with our technical story telling in a superb presentation to help us all with hints and tips for helping us with our … Continue reading Welsh Azure User Group May 2023 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure User Group May...

Read More

Size your Power Apps with Height and Width in SharePoint webparts

Sizing you apps in Power Apps isn’t any more complicated than setting the height and the width of the app. But tday I came across a situation where I needed a banner shaped app. Banner image So I created a Power App and added an image control that shows my banner. If I was to add this to a sharePoint page then I would end up with a lot of unused space on my page. So how do we resize the app so that we don’t have the white...

Read More

Filter null values in Dataverse using Power Automate

Filtering records on empty values can be a real pain as there are many mistakes to make. Null First of all I would like to have a look at the null function. Many times, I’ve seen people ask the question why their null values haven’t been working. Below 3 examples. Only one will really work. In Power Automate you can have an expression null. You can type the text null (this is just 4 characters, n,u,l,l) And then you can...

Read More

Top 8 features from Microsoft 365 Conference

During the Microsoft 365 Conference 2023 in Las Vegas, Microsoft announced many new features for SharePoint, OneDrive, Lists, and other M365 products. SharePoint stole the show with the huge list of upcoming features and changes. Here are my 8 favorite features announces during the conference. 1.    Copilot in SharePoint AI is coming to SharePoint (it […] Continue Reading Marcin Siewnicki’s Article on their...

Read More
Sofa Sessions at Stripe OLT – YouTube
May04

Sofa Sessions at Stripe OLT – YouTube

Sofa Sessions at Stripe OLT “As a young leader, what is the best part of that responsibility?”? Matilda Harding one of our Team Leaders at Stripe OLT, shares her thoughts on such an important role ? More incoming on Sofa Sessions… #leadership #motivation #sofasessions “As a young leader, what is the best part of that responsibility?”? Matilda Harding one of our Team Leaders at Stripe OLT, shares her thoughts on...

Read More
Sofa Sessions At Stripe OLT – YouTube
May04

Sofa Sessions At Stripe OLT – YouTube

Sofa Sessions At Stripe OLT Tom Robbins, Director at Stripe OLT shares some thoughts on workplace culture ⚡ Want to hear more from the team? Stay tuned for more Sofa Sessions – next up, Matilda Harding… #leadership #workplaceculture #sofasessions Tom Robbins, Director at Stripe OLT shares some thoughts on workplace culture ⚡ Want to hear more from the team? Stay tuned for more Sofa Sessions – next up, Matilda Harding…...

Read More

SharePoint Lists integration with Microsoft Teams Approvals

The latest update for SharePoint Lists enabled integration between Lists and Approvals in Teams. It’s available in a dedicated list template and you can use it to trigger Teams approvals directly from a list item.  You can enable it for a selected list and let your users work directly from the Teams Approval application. Let’s […] Continue Reading Marcin Siewnicki’s Article on their blog SharePoint Lists integration with...

Read More

Lock and wipe devices using Microsoft Graph in Power Automate

On a recent project I needed to be able to lock and wipe devices. I used Microsoft Graph, Power Automate and HTTP requests to get this done. In this post the details. Big Warning This post should have a big “Don’t try this at home (or work)” warning as you wouldn’t want to wipe a device that someone is actually using for the wrong reasons. In my case we are managing 1000s of laptops for an organization who...

Read More

2 Liquid tips – Generate GUIDs and base urls in Power Pages

In this post I’m looking at Power Pages and how to get the base url of my site and generate Guids in Liquid. Power Pages development Ok, first of all, Power Pages development can be challenging for many. It really helps if you are good at the following technologies: HTML CSS JavaScript Dataverse Liquid Now assuming that you have a basic understand of the above, I’ve got 2 quick tips to hopefully make your Power Pages...

Read More
Welsh Azure User Group April 2023 Meet Up!
Apr24

Welsh Azure User Group April 2023 Meet Up!

It was the day of our Welsh Azure User Group #WAUG April 2023 meet up and we had yet another two brilliant speakers join us with Nicholas Chang discussing an Introduction to Azure Container Apps and Daniel McLoughlin taking us through Private Networking on Azure. Again another two brilliant sessions that you will want to … Continue reading Welsh Azure User Group April 2023 Meet Up! Continue Reading jonnychipz’s...

Read More

Avatars in Teams – How To

Avatars are finally in Teams! Will avatars significantly reduce the number of people without cameras or is it just a gadget? Time will tell. Microsoft has released a preview version and now we can test it out in practice and see if it makes sense. In this post, I will show you how to enable […] Continue Reading Marcin Siewnicki’s Article on their blog Avatars in Teams – How To Avatars are finally in Teams! Will...

Read More

I don’t believe this is true (or false) in Power Automate child flows

Sometimes Power Automate can be difficult to understand. Today I’m looking at the how child flows handle the boolean values true and false. True or false Just to start this post I would like to make clear that true is not a text “True” and false is not “False” Child flow output in Power Automate I’ve created a simple flow that I will call from another flow. My child flow has two output parameters...

Read More

How to enable and work with Microsoft Loop

Last week Microsoft released a preview version of Loop. It’s a dedicated tool for collaboration. You can use it for notes, task management, or meeting summaries. You can add colleagues and work together using workspaces or even embed them into Teams. Today I will show you how you can enable Loop Preview and how to […] Continue Reading Marcin Siewnicki’s Article on their blog How to enable and work with Microsoft Loop Last...

Read More

Create a stack trace in Power Automate flows

Many pro developers will be familiar with the concept of stack traces. Can we take this idea into the low code world? Stack Trace Within Power Automate I like to use child flows and after the introduction of the Try Catch Finally pattern over 5 years ago and the idea of passing Parent flow URLs to child flows, I’ve been thinking about creating a stack trace. In the pro code world a stack trace can show you which...

Read More

Enhanced webinars with Teams Premium – Overview

Let’s talk about the next set of features in Teams Premium – webinars. The latest features reshaped it significantly and right now it’s really a competitive webinar solution. Among the new features are enhanced presenter functions, a new attendees management process, and the addition of a “green room.” These new features aim to provide a […] Continue Reading Marcin Siewnicki’s Article on their blog...

Read More
Enable Windows Update for Business Reports
Mar23

Enable Windows Update for Business Reports

👋 Hi all, Just a quick post this time. On the 31th of March 2023, Microsoft will stop with the Update Compliance reports and are not longer available as from this date. Joe Lurie (Sr. Product Manager @ Microsoft in Endpoint CxE CAT team) tweeted earlier this week about this. See his tweet below. 📢Update Compliance reports will no longer be available after March 31, 2023📆.Please enroll… Continue Reading...

Read More

Get your Microsoft Teams One on One chats with Power Automate using the Graph API

You can get some details of One on One chats in Microsoft Teams using the Microsoft Teams connector in Power Automate, but getting the actual details is slightly harder. Chats and the Teams Connector Using the List chats action you can choose to get chats of the different types available. This way you can get the chats that are within Groups, Meetings or the One on One chats. When we run this flow however, we will only see very little...

Read More
Welsh Azure User Group March 2023 Meet Up!
Mar20

Welsh Azure User Group March 2023 Meet Up!

It was the day of our Welsh Azure User Group #WAUG March 2023 meet up and we had yet another two brilliant speakers join us with Wolfgang Ofner showing us how to Level Up our Kubernetes Scaling with KEDA, then Seif Bassam joined us to talk about building Azure outside of Azure with Azure Arc. … Continue reading Welsh Azure User Group March 2023 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure...

Read More

How to use apps in Teams channel meetings

You can use apps in meetings for some time now. It’s a great way to quickly share content more interactively or to add additional features to a meeting. Add a poll or share a task from a task management tool. The feature was limited only to scheduled meetings but now you can use it in […] Continue Reading Marcin Siewnicki’s Article on their blog How to use apps in Teams channel meetings You can use apps in meetings for...

Read More

Fetch Xml vs Filter Queries in Power Automate

When you query rows in Dataverse using Power Automate you have a few options. Fetch Xml and Filter queries are the two obvious options to go for. But when should you use which? List Rows action When we compare the Get Items ( from SharePoint) with List rows for Dataverse, there are a few differences The Dataverse List rows and the SharePoint Get Items both have filter options, but only the Dataverse action has a Fetch Xml Query...

Read More

Query Excel tables using Power Automate

This week I was asked three times about how to query Excel files using Power Automate. Time for a SharePains post on this subject. Is Excel a Database? I can’t stop myself from starting with a warning. Excel is not a database and it shouldn’t be used as such. Many people however seem to use Excel as a source of data, therefor I’m going to give in and write a post on how to query your data in Excel. If your Excel...

Read More

Managing high volumes of flow runs within Power Automate using Power Apps

When you have high volumes like 100s of flows in your environment how do you manage these flows. All these flows are kicking off whenever they need to run. It can be a challenge to find out which flows are actively running. Finding your Running flows When you use the standard Power Automate UI, you can see all your flows, but if you want to see if a flow is running or if a flow has failed then you will probably have to visit each...

Read More

Search powered by GPT – quick overview of the new Bing

The new Bing is available as a limited Preview and I got a chance to play with it. It has been released in a few weeks and got a lot of attention. A totally new search experience with AI chat is something that could change the future of how we search. I found it very […] Continue Reading Marcin Siewnicki’s Article on their blog Search powered by GPT – quick overview of the new Bing The new Bing is available as a...

Read More
Device clean-up in Azure AD & Intune
Mar07

Device clean-up in Azure AD & Intune

It is been a while since I have written a blog post and it was still in the drafts, so it is time to finish it. Some time ago, I was asked if there was a method to automatically clean-up Azure Active Directory from idle devices that had not have been online for several days. I know that in Intune you have an option to automatically remove idle devices from Intune after a few days. But for… Continue Reading Jeroen...

Read More
How to use Microsoft Graph for SharePoint within Power Automate
Feb25

How to use Microsoft Graph for SharePoint within Power Automate

In this post a variety of options on how to use Microsoft Graph for SharePoint within Power Automate. My Microsoft Graph Series, so far I will start with a quick overview of the Microsoft Graph posts that I published recently. MS Graph API Authentication in Introduction Manage Users with the Graph API Manage calendars and events The Subscription model within Graph API using Power Automate Read Excel files faster using the Graph API...

Read More
Data in collections not appearing in Power Apps
Feb25

Data in collections not appearing in Power Apps

Have you ever found that data in collections not appearing in Power Apps? Are you displaying data in collections from a data source while you haven’t used this data source directly in your UI controls? Explicit column selection If you have found that your galleries aren’t loading data then you might have fallen for the issues related to the Explicit column selection feature. So what does this feature do? When you load your...

Read More
Using the Content Type Gallery in SharePoint Online with existing sites
Feb25

Using the Content Type Gallery in SharePoint Online with existing sites

Recently the Content Type Hub in SharePoint Online turned into the Content Type Gallery and this is more that just a rename of a feature. Creating Content Types You might have noticed that when you try to update content types or add new content types that the look and feel of the pages have changed a bit. The warning at the top ponts towards an article explains some of the changes. All good so far. If you are tying to enable the...

Read More

Applying site designs failing to apply the site design to SharePoint

Today I tried to apply a site design to a SharePoint site using Power Automate, however this would just not work without any failure being reported. ApplySiteDesign This is going to be a quick post. But hopefully this will help someone else spend too much time on this issue. Normally the ApplySiteDesign endpoint will apply a site design to a SharePoint site however I found that when you have larger site scripts assigned to your site...

Read More

Graph API responding with Unexpected response from the service in Power Automate

Today a real SharePains post. I create a flow that makes a call to the Microsoft Graph API and I’m getting “Unexpected response from the service”. This is as good as something went wrong. Unexpected response from the service The Unexpected response from the service error message doesn’t give us very much. You get these errors when something is wrong within the request. This error seems to catch all the errors...

Read More

Calculate progress of tasks in SharePoint using Power Automate

Today, I was asked about how to calculate progress on a task list in SharePoint using Power Auotmate The requirements Imagine that each task goes through 5 phases and we now want to get a percentage complete column filled. My first thought of course was to use calculated columns, but in this case there were actually nearly 30 phases to go through. Calculated columns might be an options but getting an expression written for that would...

Read More
Primavera P6 Consultant & Primavera P6 Trainer – YouTube
Feb23

Primavera P6 Consultant & Primavera P6 Trainer – YouTube

Primavera P6 Consultant & Primavera P6 Trainer Most Trusted Oracle Primavera Project Planning Management & Consultant & Trainer having 23Yr of Construction Experience in India. Wiznic World provides extensive training in the latest version of Primavera in PPM and EPPM as well. We are specialized in Oracle Primavera Project Management software with expertise in the provision of certified Oracle Primavera Training and...

Read More
Handling variables in SharePoint custom forms built with Power Apps
Feb19

Handling variables in SharePoint custom forms built with Power Apps

It’s possible to create custom forms for SharePoint lists/libraries using Power Apps, directly from the list command bar by using the option Integrate/Power Apps/Customize the form: This allows you to create a custom form using all features that a Canvas app offers. While you can keep all the out-of-the-box SharePoint list view native features, such as sorting, filtering, grouping & using JSON formatting, you will be able to...

Read More
[Action required] Your RSS.app Trial has Expired.
Feb17

[Action required] Your RSS.app Trial has Expired.

Your trial has expired. Please update your subscription plan at rss.app. – (t4hNp1KnWDsXzb59) Source link

Read More
Welsh Azure User Group February 2023 Meet Up!
Feb16

Welsh Azure User Group February 2023 Meet Up!

It was the day of our Welsh Azure User Group #WAUG February 2023 meet up and we had yet another two brilliant speakers join us with Kristina Devochko joining us to talk to us about Deploying microservices to AKS with Azure DevOps and Multistage pipelines, then Tim Warner joined us to talk Azure Trends for … Continue reading Welsh Azure User Group February 2023 Meet Up! Continue Reading jonnychipz’s Article on their...

Read More

How to configure sensitivity labels for Teams meetings

Security features are one of the pillars of Teams Premium. Today I will show you how to use sensitivity labels in Teams. You can create multiple labels, assign them to different scenarios and manage what is enabled and what’s not in a meeting. Together with Custom meeting templates it gives you control over meeting features […] Continue Reading Marcin Siewnicki’s Article on their blog How to configure sensitivity labels...

Read More

Customize the SharePoint command bar icons and titles with JSON formatting

Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...

Read More

Customize the SharePoint command bar icons and titles with JSON formatting

Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...

Read More

Customize the SharePoint command bar icons and titles with JSON formatting

Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...

Read More

Customize the SharePoint command bar icons and titles with JSON formatting

Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...

Read More

Customize the SharePoint command bar icons and titles with JSON formatting

Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...

Read More