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.


Reference

Jump to the section:


Date Functions

utcNow

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.

 

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.

 


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.

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: