Welcome to my (not exhaustive) Power Automation 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 Automation 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.
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.
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.