Expressions In Power Automate

Expressions are the set of functions that can be used to perform specific actions within a flow

Expressions can be used in any flow action
Expressions can be used in any flow condition
Expressions can be used in flow trigger condition. useful to conditionally trigger flows and thereby save flow runs

Examples :-

Manipulate strings
Working with dates
Converting data types
Perform logical functions
Perform Mathematical Calculations
Perform complex conditional statements etc.

Sample expression :-

replace(text, oldText, newText )

sample data :-

replace(‘Expressions are difficult’, ‘difficult’, ‘fun’)

replace=function

Expressions are difficult=parameter 1

difficult=parameter 2

fun=parameter 3

Out put :- Expressions are fun

Expression Editor :-

Create an instant flow by choosing the trigger option “Manually trigger a flow”

Add a “compose” Data operation to the flow where we can test and see the result of our expressions.

Classic Editor :-

By default the Expression Editor will be in Classic mode.

1.Concat(‘Power’,’ ‘,’Automate’) : This expression will be used to concatenate or combine any number of Strings

Save the flow and Test it Manually.

The Result will be shown below where the strings “power” and “Automate” are combined as a single string.

Just use the eclipse of the compose and select the ‘Add a note’ to display the expression in compose for a clear understanding.

The expression can be seen as note here.

Modern Editor :-

To convert to a Modern editor Go To ‘View all power Automate settings’ and enable “Experimental features”

Now the view of the Expression editor will be displayed in Modern Mode.

Replace:- will be used to replace a string with another string.

The output will be displayed as “the new string” where the string “old” is replaced with string “new”

Substring :-

It will display the substring of a string for that we need to indicate the the range of the string

Here i indicated the range between 0 to 5 in a string.

The output will be shown below

Nested Expression in Concatenate Expression :-

Here i have Nested some expressions like Guid(),toLower() and toUpper() in concatenation Expression.

The outputs for that Expressions is as shown below.

Split() :- This will split the Strings individually

The following output will show the individual strings

Indexof() :-

it will display the index of the string.

The index of “t” is 2

LastIndexof() :-

It will display the index of particular letter from the last

The index of “a” in the above string is 11

Startswith() :-

It just checks our string’s starting letter/letters. it just pass a true or false output

The “po” is the starting letters of our string so it returns true

trim() :-

It will trim the part

Here the trim action has trimmed the white spaces in the string.

Logical and Mathematical Functions :-

First initialize a variable as string type

Then add a compose action

Contains() :-

It just checks the value is included in the string or not

Here the word “Reza” is included in the string so it returns true

Equals() :-

It just checks the word is equal to the string or not

Here the variable is equal to the string so it returns true

and() :-

it checks the two strings or Expressions and return true when both are true

Here the both Expressions are true so it returns true

Use of these Expressions in a condition :-

First add condition action to the flow

When the “and” function is equal to true the flow will trigger in yes condition otherwise it will direct to the no condition

In “yes” condition i have added some Expressions they are

Minimum function

Maximum function

random function

range function

After the flow runs the condition gets triggered and now the yes condition will execute.

The minimum digit of the array is 1

The maximum digit of array is 9

The random digit between 0 to 500 is 465

The range of digits between 0 to 10 will be displayed

Date Functions :-

Concatenation function will concatenate the two values or strings

Utc() :- it will display the coordinated universal time

Format date time :-

The time format can be set manually

Convertfromutc() :-

It will convert The utc time into central standard time.

Add days() :-

it will add the extra days to present date and will return the output

Subtract can be done using same function but we just need to indicate ” -” symbol before the digit. then it will subtract the the date and pass the result.