Syntax of Advanced Condition

[flowuser]

Everything looks really great (connection to gmail or other email would be nice though).

One question I have - how to do advanced mode for conditions? I couldn't find the syntax for it anywhere.

In particular, I wanted to have an "OR" ability.   I know I can create multiple flows, but if I have 10 or 20 conditions (say, just looking for a keyword) that seems like it might get a bit unweildy.

Also, having to delete my action and recreate it each time I update thecondition is something that'd be nice to avoid.

Thanks for making an awesome tool!!

[Coen · Accepted solution]

Hey there,

when adding a condition you, near the bottom it states "Edit in advanced mode". You can use the same expression syntax that Logic Apps uses. Expression reference is here: https://msdn.microsoft.com/en-us/library/azure/mt643789.aspx

I have no experience with those advanced statements though. But this might help you get going.

Thanks

as edit: See Logical functions part for the expression I believe you are looking for.

[flowuser]

thx

this works:  @or(contains(triggerBody()['TweetText'], 'test123'), contains(triggerBody()['TweetText'], 'test345'), contains(triggerBody()['TweetText'], 'test678'))

[stars75238]

Not sure what the issue is with that statement.

Actually, I am trying to check the value of a checkbox, it seems that Flow cannot handle the OR statements and does not run.

[chandrashekhar]

For Checkbox you have to Use like below:

equals(triggerBody()?['XXXColumn NameXXX'], True)

Eg Of advanced Condition Working:

@and(not(equals(triggerBody()?['Created'], triggerBody()?['Modified'])),equals(triggerBody()?['Push_x0020_Notification'], True),equals(triggerBody()?['Travel_x0020_extension'], True))

Generic Version of above condition :

@and(not(equals(triggerBody()?['XXXColumn Name1XXX'], triggerBody()?['XXXColumn Name2XXX'])),equals(triggerBody()?['XXXColumn Name3XXX'], True),equals(triggerBody()?['XXXColumn Name4XXX'], True))

NOTE:  Keep this condition in one line without spaces. 

Regards,

Chandrashekhar