Trigger Condition - Help writing condition with OR

Like (0) Share

Report

Posted on 20 Jul 2020 12:31:28 by Portland

167

I have a SharePoint list with a choice field. There are several choices for the user to select from.

If I set this as my trigger condition

@contains(triggerBody()?['Action']?['Value'],'In Progress') Runs correctly.

@contains(triggerBody()?['Action']?['Value'],'Pending') Runs correctly.

However, I am trying to have the workflow run if the ACTION field contains either; "In Progress" or "Pending" Not sure how to write it. No matter what I've tried Power Automate says I have an error.

Ex: @or(contains(triggerbody()?[‘Action’],['Value'],'In Progress'),contains(triggerbody()?[‘Action’],['Value'],'Pending'))

I have the same question (0)

All responses (4)

Answers (1)

Portland 167 on 20 Jul 2020 at 14:03:46

Like (0)

Report

Re: Trigger Condition - Help writing condition with OR

That was it! Working perfectly. Thank you

Was this reply helpful? Yes No
Verified answer

Pstork1 67,961 Most Valuable Professional on 20 Jul 2020 at 13:38:06

Like (1)

Report
Re: Trigger Condition - Help writing condition with OR

Got bit by the cut and paste bug. Try this on e instead the last one had right and left specific single quotes around Action.

@or(equals(triggerBody()?['Action']?['Value'],'Pending'), equals(triggerBody()?['Action']?['Value'],'In Progress'))

Was this reply helpful? Yes No
Portland 167 on 20 Jul 2020 at 12:52:09

Like (0)

Report

Re: Trigger Condition - Help writing condition with OR

Returns this error message:
The power flow's logic app flow template was invalid. The template language expression 'or(equals(triggerbody()?[‘Action’],['Value'],'In Progress'),equals(triggerbody()?[‘Action’],['Value'],'Pending'))' is not valid: the string character '‘' at position '25' is not expected.

Was this reply helpful? Yes No
Pstork1 67,961 Most Valuable Professional on 20 Jul 2020 at 12:40:27

Like (0)

Report
Re: Trigger Condition - Help writing condition with OR

Try this trigger condition

@or(equals(triggerbody()?[‘Action’],['Value'],'In Progress'),equals(triggerbody()?[‘Action’],['Value'],'Pending'))

Was this reply helpful? Yes No