Skip to main content

Notifications

Community site session details

Community site session details

Session Id : jHrgwA5aNzs7lD/dGTIuG1
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
    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
    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
    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
    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
    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard
Loading started