Welcome to my (not exhaustive) Power Automate Function Reference. Flow is a fantastic tool that provides multiple possibilities for automation and integration with PowerApps, SharePoint, and a vast number of other connectors. It has an impressive array of functions that help us perform some tasks efficiently. For my Power Automate Function Reference, I want to focus on providing additional information based on my experience. With this, I’ll save you time by compiling things I find in forums, blogs, my projects, and Microsoft’s documentation in a simple reference. Below you can find the available functions, separated by sections for better organization.
Jump to the section:
The “utcNow” Function is equivalent to the “Now” function in SharePoint and PowerApps, but it always returns the current date in UTC.
The dayOfWeek Function will return an integer number that represents the day of the week for a date, where 0 is Sunday, 1 is Monday ending in 6, a Saturday.
The addDays Function works just like the addSeconds Function and other similar functions. It adds the number of days to a specific date, based on a particular format.
The addHours Function works just like the addSeconds Function and other similar functions. It adds the number of hours to a specific date, based on a particular format.
The addMinutes Function works just like the addSeconds Function and other similar functions. It adds the number of minutes to a specific date, based on a particular format.
I’ve used the addSeconds Function in previous posts but never spent time to explain it adequately. This function adds the number of seconds to a specific date, based on a particular format.
Power Automate provides functions to add time-based on each of the units, so you can use the addSeconds Function to add only seconds, for instance.
The formatDateTime Function allows you to turn a specific date in any format that you want. It’s quite useful since different countries represent dates differently. Another excellent usage for this is to fetch a string that has a specific format and convert it in another that you can store in your database or SharePoint list.
The min Function finds in an array of numbers the lowest number. Quite handy and straightforward.
The int Function does something super simple. Convert a string into an integer value. That’s it. But, as always, we need to be careful while using conversion functions, so let’s explore it a little bit more because there are some potential hidden issues that you may find.
The toUpper Function sets all items in a string to uppercase.
The toLower Function sets all items in a string to lowercase.
The split Function breaks down your string into an array of strings using the delimiter that you defined. Think of the delimiter as a border.
I won’t be able to provide information for all Flow functions (that would be overkill and time consuming). I’ll focus on the most common ones, but if you need more details, I recommend taking a look at Microsoft’s function reference that contains the full reference material. You can also find excellent information in use expressions with conditions.
Please get in touch. You can send me an email, interact on Twitter, or add a comment. Based on the demand, I can try to focus more on specific functions. The Power Automate Function function reference joins the Friday Function lineup alongside Power Apps and SharePoint. I’ll explore some functions weekly and provide recommendations on how to use them more efficiently.
I’ll publish more functions every Friday, so please come back every week for more recommendations.