I recently encountered a scenario at work where responses to a Microsoft Form should be sent to different people via email based on a value selected as part of one of the questions. Basically, if a person selects Option 1, send an email to a group of people, if he selects Option 2 send it… READ MORE
Controls are a blessing and a curse at the same time. They are right there in the app and provide us with tools to perform actions quickly, but if you’re not careful, the screen is full of controls. The trick is to hide what you don’t need the user to see. Lets get into Power… READ MORE
Here we will see how to Create, Configure and Consume the Custom Connector to query a M365 group members as a paged result using the M365 Graph api. Register an Application with a Delegated Group.Read.All permission First, Register an application for the PowerPlatform Custom connector with the Delegated permission to read the groups. Create a… READ MORE
In this blog, we will see how to post the message to Microsoft Teams using Incoming Webhook. What is the Incoming Webhook? Basically, it is a URL provided by Teams for any service to use to post content with the goal of sharing that content in your team’s channel. When you configure it, you get… READ MORE
In this article, I will describe how to create an Excel file dynamically with Power Automate and fill it with data from the Common Data Service. Creating those dynamically can be a bit tricky. Therefore, I will provide step by step description of how to do that. Scenario Let’s assume AB Company is using Dynamics… READ MORE
I want my students to submit weekly reflections, but it also needs to be easy for me to collect those. My solution is a Microsoft Form for each week, an Excel Workbook in OneDrive, and Power Automate (formerly Microsoft Flow) to glue the two together. First, I created a Microsoft Form for each week of class. I used the survey-style… READ MORE
Power Automate is used to automatize actions, it therefore needs to connect to services. Most of them can be accessed using the default connectors without providing any secret or password, but sometimes, you need to operate the authentication yourself. The most common example would be calling Microsoft GraphAPI using the HTTP connector. In this case… READ MORE
In SharePoint Online, whenever you create a library and turn on “Require check-out” before editing documents option or not, users are able to open files for collaboration in browsers or in their local Office clients. When they do that, the file is getting locked from access that could lead to its metadata changes. If you… READ MORE
In this blog post I will show how to use Power Automate to create an attribute-based ID in Microsoft Lists. Attribute-based translates to business readable with formatting. This pattern is based on work I did at my previous employer where the List was being used for data imports into a legacy application that required a:… READ MORE
If until now one of the flows that I have helped to configure the most are those that are launched manually from a SharePoint element , Microsoft has surprised me again and without a doubt the new trigger for Teams will give a lot to talk about and will be the protagonist in many business solutions . Just a month… READ MORE
