Master Power Fx expressions in Power Automate with this comprehensive cheat sheet. Whether you’re a beginner or a pro, these functions will help you build smarter, more efficient flows in no time.
📘 Basics
| Purpose |
Expression |
Description |
| Concatenate strings |
concat('Hello ', variables('name')) |
Joins strings |
| Length of string/array |
length(variables('myArray')) |
Gets number of items |
| Set variable |
setVariable('myVar', 'value') |
Assigns a value |
| Get current time |
utcNow() |
Returns current UTC time |
🔤 String Functions
| Function |
Example |
Purpose |
| toUpper() |
toUpper('power') |
Uppercase string |
| toLower() |
toLower('POWER') |
Lowercase string |
| trim() |
trim(' hello ') |
Remove spaces |
| substring() |
substring('abcdef', 2, 3) |
Extracts ‘cde’ |
| replace() |
replace('Hi Bob', 'Bob', 'Alice') |
Replace substring |
| split() |
split('a,b,c', ',') |
Splits into array |
| indexOf() |
indexOf('PowerAutomate', 'Auto') |
Find index |
| lastIndexOf() |
lastIndexOf('ababc', 'b') |
Last index |
Leave a comment