Power Automate Function Reference

An evergrowing Power Automate Function Reference

My way of explaining each function with as much detail as I can. You’ll find suggestions, best practices, things to avoid, and limitations.
Experience
I’ll include all my experiences (good and bad) working with the functions.
For eveyone
I want people to use it and share it. So I won’t put any restriction on it on this reference.
By everyone
Please contribute! The better I can make it, the better it will be for everyone.
Lots of places
I learn from lots of places, so some things may be found elsewhere.

Schedule

Articles will come out every Thursday, always at 1 pm Lisbon Time. Since I have three platforms to explore, you can expect Power Automate (weekly regardless), SharePoint, and PowerApps articles every three weeks.

If you’re looking for other references you can find:

Time permitting, I’ll increase the frequency, but I think this is the right balance so that I can keep on delivering valuable information in a defined schedule.

The Reference

Here are the sections where you can find articles. There are more in Microsoft’s reference, but I only include the ones I wrote about in the past.

Collection

CONTAINS function

In Power Automate, we need to parse a lot of strings and collections and, sometimes, it’s essential to understand if we have something that exists …
Full Reference

EMPTY function

Checking if something is empty can save a lot of actions and potential breaking Flows. That’s why we have the “empty” function that will check …
Full Reference

FIRST function

Arrays are part of the building blocks of Power Automate. We can get arrays from many actions like the SharePoint “Get Items” action, for example. …
Full Reference

JOIN function

The join function is handy although I, don’t see many people using it. It converts an array in a string with a delimiter. At first, …
Full Reference

LENGTH function

The length function is handy to get the size of a string or the number of objects of a collection. So you can use it …
Full Reference

Data Conversion

ARRAY function

The array function will convert any value into an array. By any value, I mean one value only! The point of this function is not …
Full Reference

BOOL function

Converting things is essential, and Power Automate has a few functions to help us in doing that. Today we’ll focus on the bool function that …
Full Reference

CREATEARRAY function

I see many questions around this function; one of those is, “why should I use a createArray function?” It may seem strange, but this function …
Full Reference

FLOAT function

Converting things is essential, and Power Automate has a few functions to help us in doing that. Today we’ll focus on the float function that …
Full Reference

INT function

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 …
Full Reference

JSON function

JSON is a standard used in multiple areas like integrations between systems (like Power Automate connections, for example), so it’s pretty widespread even if we …
Full Reference

STRING function

Converting things is essential, and Power Automate has a few functions to help us in doing that. Today we’ll focus on the string function that …
Full Reference

Data Selection

IF function

When it comes to fundamental functions, nothing compares to the Power Automate “if “function. It exists in all platforms, programming languages, and tools. You name …
Full Reference

Date

ADDDAYS function

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 …
Full Reference

ADDHOURS function

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 …
Full Reference

ADDMINUTES function

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 …
Full Reference

ADDSECONDS function

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 …
Full Reference

ADDTOTIME function

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 …
Full Reference

DAYOFWEEK function

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 …
Full Reference

FORMATDATETIME function

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. …
Full Reference

TICKS function

The “ticks” function is beneficial when it comes to parsing dates. Since dates are so messy to convert due to timezones, leap years, daylight saving, …
Full Reference

UTCNOW function

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 …
Full Reference

Flow

ITEM function

The item function is oftentimes misunderstood since it’s not common to be used, but it’s beneficial. For example, when you’re inside a repeating action, like …
Full Reference

Logical Operator

AND function

Sometimes one function is not enough, so combining multiple is necessary. To help us with that, we have the “and” function. It combines various functions …
Full Reference

EQUALS function

Comparisons as extremely useful in any programming language or platform and Power Automate is not the exception. The “equals” function helps us to have two …
Full Reference

GREATER function

Comparisons as extremely useful in any programming language or platform, and Power Automate is not the exception. For example, the “greater” function helps us to …
Full Reference

GREATEROREQUALS function

Comparisons are an essential part of any platform, and Power Automate has fantastic functions to help us with that. For example, the “greaterOrEquals” function serves …
Full Reference

LESSOREQUALS function

Comparisons are an essential part of any platform, and Power Automate has excellent functions to help us with that. The lessOrEquals function is incredibly handy …
Full Reference

NOT function

Many think that the not function is useless. Usually, the “not” function is used in comparisons, so if you’re comparing if something is not something …
Full Reference

OR function

Sometimes one function is not enough, so combining multiple is necessary. To help us with that, we have the “or” function. It combines multiple functions …
Full Reference

Math

ADD function

I have to admit that this function and all the other analogous functions (sub, mul, and div) are quite strange. This function will add two …
Full Reference

DIV function

I have to admit that the div function and all the other analogous functions (sub, add, and mul) is quite strange. This function will divide …
Full Reference

MIN function

The min Function finds in an array of numbers the lowest number. Quite simple and handy. Usage It follows a simple pattern. An array of numbers …
Full Reference

MUL function

I have to admit that the mul function and all the other analogous functions (sub, add, and div) is quite strange. This function will multiply …
Full Reference

SUB function

I have to admit that the “sub function” and all the other analogous functions (add, mul and div) are quite strange. This function will subtract …
Full Reference

String Manipulation

CONCAT function

Building strings is one of the most common actions in any tool or framework, and Power Automate is not the exception. The concat function helps …
Full Reference

ENDSWITH function

Power Automate’s endsWith function is part of a set of functions that deal with strings. In this case we’re checking if a string ends with …
Full Reference

GUID function

The first question that comes to mind is a “GUID”. I wrote about it a while ago for Power Apps, but today I want to …
Full Reference

INDEXOF function

The “indexOf” function is essential for data parsing. You’ll rarely parse some text and don’t use this function. It returns the first occurrence of a …
Full Reference

LASTINDEXOF function

The “lastIndexOf” function is the corollary to the “indexOf” function, where it returns the last occurrence. It always returns a number, and it will return: …
Full Reference

REPLACE function

The “replace” function is one that shows up frequently in every programming language. The usage is simple but extremely powerful. Usage It follows a simple …
Full Reference

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. …
Full Reference

STARTSWITH function

Power Automate’s startsWith function is part of a set of functions that deal with strings. In this case, we’re checking if a string starts with …
Full Reference

SUBSTRING function

The substring function is widely popular and widely used. We have the need all the time to parse the string to get sections of it. …
Full Reference

TOLOWER function

The toLower Function sets all items in a string to lowercase. There is the toUpper function also, and these functions are super useful, mainly if …
Full Reference

TOUPPER function

The toUpper Function sets all items in a string to uppercase. There is the toLower function also, and these functions are super useful, mainly if …
Full Reference

TRIM function

When it comes to parsing strings, there’s a lot of difficult things to take into consideration. For example, spaces in the beginning and the end …
Full Reference

URI Conversion

Photo by Pawel Czerwinski on Unsplash