Skip to main content

Notifications

Power Automate - Building Flows
Answered

Trigger condition from SharePoint choice column

Like (0) ShareShare
ReportReport
Posted on 25 Jan 2022 18:06:30 by

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

 

MGB42_0-1643133706591.png

 

  • navyjax2 Profile Picture
    navyjax2 98 on 21 Mar 2024 at 18:59:48
    Re: Trigger condition from SharePoint choice column
    @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( .... )

     

  • Geniusweb Profile Picture
    Geniusweb 2 on 19 Oct 2023 at 10:40:03
    Re: Trigger condition from SharePoint choice column

    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.

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 28 Jan 2022 at 09:37:06
    Re: Trigger condition from SharePoint choice column

    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. 

  • Verified answer
    v-bofeng-msft Profile Picture
    v-bofeng-msft on 28 Jan 2022 at 03:01:07
    Re: Trigger condition from SharePoint choice column

    Hi @Anonymous :

    Pease try:

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

    vbofengmsft_0-1643338845913.png

    Best Regards,

    Bof

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 25 Jan 2022 at 18:15:22
    Re: Trigger condition from SharePoint choice column

    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!

    MGB42_0-1643134496751.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,769

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,466

Leaderboard