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 functions available until now separated into sections for better organization.
Jump to the section:
The utcNow Function is equivalent to Now function in SharePoint and PowerApps, but it always returns the current date in UTC. SharePoint and PowerApps consider the timezone and return the converted time.
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 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.
Power Automate provides functions to add time-based on each of the units. For example, you can use the addSeconds Function to add only seconds, but the addToTime Function can provide a lot more flexibility since you define the unit that you want to add.
The min Function finds in an array of numbers the lowest number. Quite simple and handy.
The toUpper Function sets all items in a string to uppercase.
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. Finally, please get in touch. You 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 Flow Function function reference joins the Friday Function lineup alongside PowerApps and SharePoint. I’ll explore weekly some functions and provide recommendations on how to use them more efficiently, so be sure to come back. For now, this is the Full lineup, but this will give you some material to get you on your way and create impressive applications and automation.
More functions will come every Friday so don’t get discouraged for seeing only a few.