cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Syntax of Advanced Condition

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!!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate III
Advocate III

Re: Syntax of Advanced Condition

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.

View solution in original post

4 REPLIES 4
Highlighted
Advocate III
Advocate III

Re: Syntax of Advanced Condition

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.

View solution in original post

Highlighted
New Member

Re: Syntax of Advanced Condition

thx

 

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

Highlighted
New Member

Re: Syntax of Advanced Condition

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.

 

Highlighted
Advocate V
Advocate V

Re: Syntax of Advanced Condition

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (7,067)