Unanswered

Trigger condition from SharePoint choice column

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am trying to trigger a flow from a SharePoint list using the "When an item is created or modified" trigger. I am then using the Trigger Conditions option in the settings to restrict when the flow runs.

I have a 'Choice' column called "Submitted" in the list that allows either "Yes" or "No". I would like the flow to continue only when the value of the "Submitted" column equals "Yes".

I have tried a variety of options (and read many blogs!) but am not clear how to get the get the expression to work.

Any help much appreciated

(These are some of the ones I've tried

@equals(triggerOutputs()?['Submitted']?['value'],'Yes')
@equals(triggerOutputs()?['Submitted/Value'],'Yes')
@equals(triggerOutputs()?['Submitted']?['Value'],'Yes')
@contains(triggerOutputs()?['body/Submitted'],'Yes')
@equals(triggerOutputs()?['body/Submitted#Value'],'Yes')
@contains(triggerOutputs()?['body/Submitted#Value'],'Yes'))

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Hi,

Sorry I thought I had found the solution but this also does not work

The expression I used was @equals(triggerOutputs()?['body/FurtherInfo/Value'],'Yes')

I found this by putting a Condition in the flow immediately after the trigger and then started to enter the expression adding the dynamic field I wanted. It then populated the expression for me!

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (6)

Report
Hi @Anonymous :

Pease try:

@equals(triggerOutputs()?['body/Submitted/Value'], 'Yes')

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you Bof that now works perfectly

In case anyone else has this problem after much wrangling I realised I had made an amendment in the SharePoint list which was not picked up in PowerAutomate so it could not find the trigger output.

Was this reply helpful? Yes No
Geniusweb 2 on at

Like (0)

Report

Hello,

can you please advise how to use trigger conditions based on selection first OR second choice?
In total I have column with 4 predefined choices but I want to trigger automation only if first choice (YES) or second choice (MAYBE) is selected.

Thank you.

Was this reply helpful? Yes No
navyjax2 98 on at

Like (0)

Report
@or(equals(triggerOutputs()?['body/MyField/Value'], 'YES'),equals(triggerOutputs()?['body/MyField/Value'], 'MAYBE'))
The format is basically taking an "equals" with the "triggerOutputs()", a "?", the field name off of the body and appending "Value" if it's a Choice or Lookup field, then a comma and the value you are looking for:
equals(triggerOutputs()?['body/MyField/Value'], 'YES')
and repeat this format for every choice you want the flow to trigger off of, with commas in-between those blocks, then encapsulate the whole thing with the
@or( .... )

Was this reply helpful? Yes No