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