Setting your status in Teams. Are you available, busy or maybe do not disturb? Did you know that it’s possible to set your status automatically using Power Automate? The method I am about to share is undocumented and is for you to explore and test...
Continue reading...Attendee registration using Microsoft Forms
Publicize your next event(s) and allow users to sign up via Microsoft Forms. Power Automate can be used to send attendees their invite to the event and allow you to gauge event uptake. Whilst Forms will not allow you to manage a limit on numbers,...
Continue reading...Custom Action – Post Email Attachment to Teams
Post a regular file to Teams using a custom connector and the Graph API. Let me show you how to build the Flow.
Continue reading...How To? Build It! Custom Connector
Creating a Graph API customer connector can be daunting. If I can do it, so can you! Extend the capabilities of Power Automate and Power Apps.
Continue reading...Awesome! Create Charts via Office Scripts
Did you know that you can automatically create dynamic charts (Pie / Column / Bar) using data in Excel by using Office Scripts and Power Automate? These charts can be created and returned as images to Power Automate and then used in any document of...
Continue reading...How To Parse any CSV to JSON Array
Learn how to dynamically parse any CSV file to a JSON Array. This Power Automate Flow will handle all shaped and sized CSVs. Copes with both Windows and Unix encoded files too. Useful concepts.
Continue reading...Amazing – saving an attachment to a custom folder or site
Save regular email attachments to SharePoint locations (folders or sites) based on the Subject or File Name using Power Automate Cloud Flows.
Continue reading...Retrieve Array of SharePoint List Choices via Cloud Flow
Have you ever had the need to retrieve an array of Choices for a SharePoint column? There is a little known REST call to the SharePoint API which will allow you to retrieve such information and format in an array to use later in your...
Continue reading...If, Else If, Else in Power Automate Simplified
You know the logic, if a logical expression is met, perform an action or expression, else if it matches another expression follow that outcome, otherwise do the fall back option. How do you create this in Power Automate? Well, you could use the switch action...
Continue reading...Easily address escaped characters in Forms Response
Escaped characters in your forms response or json data sources can be easily formatted with a simple expression. \”answer\” will become “answer”.
Continue reading...