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')