### An ever-growing 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.

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
- Data Conversion
- Data Selection
- Date
- Flow
- Logical Operator
- Math
- String Manipulation
- URI Conversion

## 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

#### LAST function

Arrays are part of the building blocks of Power Automate , and we can get arrays from many actions, like the SharePoint “Get Items” action, …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

#### XPATH function

The “xpath function” is not the first function that comes to mind in Power Automate, and it’s not the most obvious; I’ll give you that, …Full Reference

## Data Selection

#### IF function

Nothing compares to the Power Automate “if “function when it comes to fundamental functions. 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 you want. It’s pretty helpful since different countries represent dates differently. Another …Full Reference

#### STARTOFDAY function

Dealing with dates and times is hard, especially considering time zones, formats, and regional settings. So having functions that do this for us is a …Full Reference

#### STARTOFHOUR function

Dealing with dates and times is hard, especially considering time zones, formats, and regional settings. So having functions that do this for us is a …Full Reference

#### STARTOFMONTH function

Dealing with dates and times is hard, especially considering time zones, formats, and regional settings. So having functions that do this for us is a …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

#### OUTPUTS function

The “output” function is used to get the values from actions. Similar to how “variables” function but for all actions instead of only variables. Let’s …Full Reference

#### TRIGGERBODY function

Triggers play an essential role in Power Automate since we could not even start the Flows without them. Triggers can have information that could be …Full Reference

#### VARIABLES function

Variables are a great way to keep data between actions and manipulate it so we can use it further down the line. But what about …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

#### FORMATNUMBER function

I wrote recently about converting strings into numbers, but in that article, I used the “Format Number” action for simplicity’s sake. But its counterpart is the …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

#### NTHINDEXOF function

We’ve covered in the path the indexOf function, but today I wanted to cover the less known brother function, the “nthIndexOf” function. It does the …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

#### URIHOST function

Parsing URLs is super hard, but Power Automate has many functions that deal with this so nicely that it is a waste of time for …Full Reference

#### URIPATH function

So you have a URL and want to get parts of it. One way would be to use the split function or indexOf function and …Full Reference

#### URIPATHANDQUERY function

So you have a URL and want to get parts of it. One way would be to use the split function or indexOf function and …Full Reference

#### URIQUERY function

So you have a URL and want to get parts of it. One way would be to use the split function or indexOf function and …Full Reference

#### URISCHEME function

So you have a URL and want to get parts of it. One way would be to use the split function or indexOf function and …Full Reference