Power Automate: concat Function
by Building strings is one of the most common actions in any tool or framework, and Power Automate is not the exception. The Concat function helps …
Category: Reference
Reference articles will contain information about specific functions and concepts for Microsoft Power Automate, Power Apps, and SharePoint for functions, Actions, and Triggers. It will teach you how to use them and show you pitfalls, limitations, and best practices on how to use them efficiently.
Microsoft / OneDrive for Business / Power Automate / Power Automate Action Reference / Power Platform / Reference
Power Automate: OneDrive for Business – Get file metadata using path Action
It’s quite common to parse files in Power Automate, especially in bulk. But to parse files, we don’t need to get the file into Power …
Microsoft / Power Automate / Power Automate Action Reference / Power Platform / Reference / SharePoint
Power Automate: Send an HTTP request to SharePoint Action
Power Automate has an amazing set of actions for SharePoint, but none is more versatile than the “Send an HTTP request to SharePoint” action. With …
Power Automate: HTML to Text Action
There are times when HTML is not helpful, being for parsing the text or saving it. Removing HTML tags is a pain; that’s why the …
Power Automate: array Function
The array function will convert any value into an array. By any value, I mean one value only! The point of this function is not …
SharePoint: Hour Function
The “hour function” is part of a suite of functions that deal with dates. It returns the part of the time; for example, 12:30 will …
Microsoft / Power Automate / Power Automate Action Reference / Power Platform / Reference / SharePoint
Power Automate: SharePoint Get Items Action
SharePoint is an amazing place to store information, and lists are the most useful way to organize the information. With the release of Microsoft Lists, …
OData: startswith Function
Besides operators, OData also enables us to have functions on our data. These are super useful to filter the data on the source to pull …
Power Automate: div Function
I have to admit that the div function and all the other analogous functions (sub, add, and mul) is quite strange. This function will divide …
Power Automate: Switch Action
There are times where we have multiple possible values, and we want to have different workflows for each. Think in the case of a category. …