Mar 28, 2020The Compose actionMicrosoft Power Automate (aka Microsoft Flow) provides lots of action steps out of the box. My favourite one is Compose. What does it do?...
Feb 8, 2020How to check whether a folder exists in SharePoint (using Power Automate)I have a SharePoint document library called aj, and inside of it, three folders (Test1, Test2 & Test3). I am going to build a flow to...
Nov 2, 2019How to call an API using the Power Automate HTTP actionIn this blog post I will access NASA's Astronomy Picture of the Day (APOD) API using Power Automate. The plan is to retrieve the picture...
Oct 12, 2019How to retrieve files from a SharePoint library and send an email attachment (with Power Automate)Every flow needs a trigger to start with so here I am using a manual trigger. Next, I am using the action List Folder which returns files...
Sep 25, 2019Filtering Excel Rows with Power AutomateBelow is my Excel sheet ProdDetails. Retrieving all of the rows To manipulate this data in Power Automate, first we will retrieve all of...
Sep 13, 2019Retrieving a row from an Excel table using Power AutomateThe Power Automate action Get a row retrieves a single row from an Excel table. Here I am using a valid key value (P2) which exists in my...
Sep 8, 2019Email OneDrive files using Power AutomateFirst step is the trigger. Here I am using a manual trigger. The next step is to declare an array variable called FileContents. This is...
Sep 6, 2019How to determine if a string is numeric (in Power Automate)There are a few ways that you could do this. Here I will show you two of my 'go-tos'. Determining if a string is numeric - method #1 The...
Jun 8, 2019How to restore a previous version of a Sharepoint document using Power AutomateA SharePoint Document Library provides a secure place to store files where you and your co-workers can find them easily; work on them...