Use variables and the % notation

Variables are used within flows to store data for further processing. Every variable name must be enclosed by percentage signs (%). The percentage sign is used as a special character to denote variables. Any expression between percentage signs should be evaluated.

Occasionally, the percentage sign should be used as a simple character, instead of denoting a calculation. In those cases, it should be escaped using another percentage character (%%).

​Power Automate enables you to create complex expressions containing hardcoded values, variable names, arithmetic and logical operations, comparisons and parentheses.

Hardcoded values

To include a hardcoded text value inside a variable, use quotes. Every value between the quote characters will be treated as a text value and not as a variable name.

Variable names

Variables can be used by adding their name to the expression without any further notation.

Basic arithmetic

To make mathematical operations, use all the essential, arithmetic operators, such as addition (+), subtraction (-), multiplication (*), and division (/).

Arithmetic operations are predominantly used with numerical values and variables. However, you can also use the addition operator to concatenate strings. Adding numbers and text strings in the same expression will convert the numbers into text, and concatenate them with the other text strings.

Expression Result Result variable type
%5 * 3% 15 Number
%4 / Var% 4 divided by the value of the Variable named “Var” Number
%'this is ' + 'text'% this is text Text
%'This is the number ' + 5% This is the number 5 Text

Comparisons

Besides arithmetic operators, make comparisons using the following operators

Operator Description
=, <> Equal/not equal
<, <= Less than/less than or equal
>, >= Greater than/greater than or equal

Keep in mind that comparisons, when evaluated, produce either True or False as a value. Naturally, comparisons can only be done between values of the same type.

Logical operators

Logical operators can also be used to check multiple conditions simultaneously, allowing you to implement more complex logic in a single expression. The supported operators are: AND, OR, and NOT.

Expression Result
%Index = 1 OR Index = 2% True if the value of the Index variable is 1 OR 2, otherwise False.
%Index = 4 AND Text = "Four"% True if the value of the Index variable is 4 AND the value of the Text variable is Four, otherwise False.
%NOT(4 <> 4)% Reverses the logical value in the parentheses. In this examples, it returns True.

Additionally, you can use the following logical expressions to check the value of a string or variable.

Expression Arguments Description
%StartsWith(arg1,arg2,arg3)% arg1: Text to search into
arg2: Text to search for
arg3: Ignore case (True / False)
True if the provided string starts with the specified value, otherwise False.
%NotStartsWith(arg1,arg2,arg3)% arg1: Text to search into
arg2: Text to search for
arg3: Ignore case (True / False)
True if the provided string doesn't start with the specified value, otherwise False.
%EndsWith(arg1,arg2,arg3)% arg1: Text to search into
arg2: Text to search for
arg3: Ignore case (True / False)
True if the provided string ends with the specified value, otherwise False.
%NotEndsWith(arg1,arg2,arg3)% arg1: Text to search into
arg2: Text to search for
arg3: Ignore case (True / False)
True if the provided string doesn't end with the specified value, otherwise False.
%Contains(arg1,arg2,arg3)% arg1: Text to search into
arg2: Text to search for
arg3: Ignore case (True / False)
True if the provided string contains the specified value, otherwise False.
%NotContains(arg1,arg2,arg3)% arg1: Text to search into
arg2: Text to search for
arg3: Ignore case (True / False)
True if the provided string doesn't contain the specified value, otherwise False.
%IsEmpty(arg1)% arg1: Text to check True if the provided string doesn't contain any characters, otherwise False.
%IsNotEmpty(arg1)% arg1: Text to check True if the provided string contain one or more characters, otherwise False.

Parentheses

To change the operators' priority, use parentheses. Parentheses are handled the same way as in algebra and programming languages.