A Visual Explanation of Flow Logical Expressions

Power Automate Flow Examples Website Title

If you’re like me and you learn visually from images and videos this will hopefully help you on your Power Automate journey. I’ve created visual representations of the basic ‘Logical Expressions’ that Power Automate uses with its Conditions and provided code examples for triggering both ‘Yes’ and ‘No’ events. This is aimed at an introduction level for those looking to utilise expressions with minor/no experience with using these before. There will be more blog posts and videos going into more detail and how these can change your approach to your Flows in the future.

The And Expression

Code Example for a ‘Yes’ Outcome

and(greater(999,1),equals(0,0))

Code Example for a ‘No’ Outcome

and(greater(1,10),equals(0,0))

The Or Expression

Code Example for a ‘Yes’ Outcome

or(greater(1,10),equals(0,0))

Code Example for a ‘No’ Outcome

or(greater(1,10),equals(0,9))

The Less Expression

Code Example for a ‘Yes’ Outcome

less(1,150)

Code Example for a ‘No’ Outcome

less(10,10)

The Less Or Equals Expression

Code Example for a ‘Yes’ Outcome

lessOrEquals(10,10)

Code Example for a ‘No’ Outcome

lessOrEquals(999,10)

The Greater Expression

Code Example for a ‘Yes’ Outcome

greater(999,10)

Code Example for a ‘No’ Outcome

greater(1,10)

The Greater Or Equals Expression

Code Example for a ‘Yes’ Outcome

greaterOrEquals(10,10)

Code Example for a ‘No’ Outcome

greaterOrEquals(5,10)

The Empty Expression

Code Example for a ‘Yes’ Outcome

empty('')

Code Example for a ‘No’ Outcome

empty('NotEmpty')

The Not Expression

Code Example for a ‘Yes’ Outcome

not(contains('200 Success','Fail'))

Code Example for a ‘No’ Outcome

not(contains('200 Success','Success'))

The If Expression

Code Example for a ‘Yes’ Outcome

if(equals(1, 1), 'yes', 'no')

Code Example for a ‘No’ Outcome

if(equals(2, 3), 'yes', 'no')