If you are receiving daily/weekly excel workbooks containing data that isn’t saved as a table, how are you going to query it in PowerAutomate? One method is to use Office Scripts. With a relatively simple piece of TypeScript, you can insert a Table into your...
Continue reading...PowerAutomate
Round Robin in Power Automate
If you are looking to implement a round-robin allocation of list items, Microsoft form submissions, tasks, or emails via Power Automate, I have a couple of very easy solutions that you can implement using either a Microsoft List or Security/Distribution Group for the user array/list....
Continue reading...Mention a Channel or Team – Power Automate
Via Microsoft Teams, you can mention a Team or Channel and the members will be alerted to a new message being posted. Currently, via the default Power Automate actions, you are not able to mention either, unless you are familiar with Graph. It’s not as...
Continue reading...Add members to a distribution list – Power Automate
Are you looking to add members or list members of an exchange email distribution list via Power Automate? As part of an onboarding process, maybe you have a Power App or Microsoft Form that allows a manager to request that their new member of staff...
Continue reading...Unique IDs and pad a string
Are you looking to create a unique ID in Power Automate for your Microsoft List items or files created in a SharePoint Document Library, an invoice number, file name, or sequential ID? Let me show you how to sequentially increment your unique ID based on...
Continue reading...Microsoft List – Add Comment
If you are looking to automatically add comments to Microsoft List Items (or “SharePoint” List items) via Power Automate, you’ve come to the right place. In this article, I will show you how you can use the SharePoint Rest API to both post a comment...
Continue reading...Teams Status Update via Power Automate
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...