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.


Reference

Jump to the section:


Date Functions

utcNow

The “utcNow” Function is equivalent to the “Now” function in SharePoint and PowerApps, but it always returns the current date in UTC.

 

dayOfWeek

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.

 

addDays

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.

 

addMinutes

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.

 

addToTime Function

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.

 

Number Functions

min Function

The min Function finds in an array of numbers the lowest number. Quite handy and straightforward.

 

String Functions

toUpper Function

The toUpper Function sets all items in a string to uppercase.

 

toLower Function

The toLower Function sets all items in a string to lowercase.

 

split Function

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.

Featured Image by Vadim Sherbakov on Unsplash

Manuel Gomes

I'm a Project Manager with experience in large projects and companies. I've worked in the past for companies like Bayer, Sybase (now SAP) and I'm currently working for Pestana Hotel Group.

View all posts by Manuel Gomes →

Leave a Reply

%d bloggers like this: