Skip to main content

Notifications

Community site session details

Community site session details

Session Id : I+4pBQ+dHLnFXdkH5cCsN5
Power Automate - Using Flows
Answered

How to trigger flow only when a specific field is equal to a specific value in SharePoint List

Like (0) ShareShare
ReportReport
Posted on 27 Oct 2020 06:08:29 by

Hi all,

 

I'm trying to use the new trigger conditions on Flow to help save flow runs. I want to set up a trigger on power automation flow and have it only run when the status of that column change to "Yes". I have a SharePoint list where I have multiple columns & I would like to run the flow when the shipment damage column value is equal to yes then flow can trigger or run and send out mail notification to the department manager. 

 

SharePoint listSharePoint list

 

Thank you

  • Community Power Platform Member Profile Picture
    on 29 Oct 2020 at 20:30:49
    Re: How to trigger flow only when a specific field is equal to a specific value in SharePoint List

    Hi @Diksha ,

    Thanks, working perfectly. 

  • Verified answer
    Diksha Profile Picture
    301 on 28 Oct 2020 at 20:33:43
    Re: How to trigger flow only when a specific field is equal to a specific value in SharePoint List

    Hello @Anonymous ,

     

    What is the internal name of Shipment Damage column?

    Make sure to use internal name only in trigger condition.

     

    Also, if true is not working then try to use Yes in condition.

    I have tried using Yes and it worked for me.

     

    Let us know if you still face any issues.

     

     

    If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .

    Thank You !!!

  • Community Power Platform Member Profile Picture
    on 28 Oct 2020 at 18:54:45
    Re: How to trigger flow only when a specific field is equal to a specific value in SharePoint List

    Hi @v-litu-msft , 

    Please find the attached screenshot. Flow is not getting trigger. 

    Dill_1-1603911180050.png

     

     

    Dill_0-1603910915552.png

     

    Sharepoint list screenshot 

     

    Dill_2-1603911270890.png

     

  • v-litu-msft Profile Picture
    on 28 Oct 2020 at 08:37:00
    Re: How to trigger flow only when a specific field is equal to a specific value in SharePoint List

    Hi @Anonymous,

     

    I can see your ShipmentDamage column is a Yes/No type, they are the boolean value true and false, the expression is correct:

    @equals(triggerBody()?['ShipmentDamage'], true)

    Screenshot 2020-10-28 163242.jpg

     

    There is no need to add the compose action, it's just an additional action on my side for the test. I assume the reason for your Flow not work is the column name has been changed, could you please share a screenshot of your Flow configuration? And an instance of the trigger output without any trigger condition.

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Diksha Profile Picture
    301 on 28 Oct 2020 at 08:26:14
    Re: How to trigger flow only when a specific field is equal to a specific value in SharePoint List

    Hello @Anonymous ,

     

    Use a trigger When an item is created or modified and set the Trigger Condition as below - 

    @equals(triggerBody()?['ShipmentDamage'], 'Yes')

     

    Capture.PNG

     

    I have added 2 entries in list , the flow runs only for one item where I set the ShipmentDamage to Yes

     

    If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .
    Thank You !!!

  • Community Power Platform Member Profile Picture
    on 28 Oct 2020 at 05:17:06
    Re: How to trigger flow only when a specific field is equal to a specific value in SharePoint List

    Hi @Diksha 

     

    Thanks for looking into this, but  I am not looking for a modified column solution. 
    I would like to know when we create a new item in SharePoint list and one off the column value is equal to yes, then how we can trigger the flow only when that column value is equal to yes. So I can save my API calls. 

     

     

     

  • Community Power Platform Member Profile Picture
    on 28 Oct 2020 at 05:12:15
    Re: How to trigger flow only when a specific field is equal to a specific value in SharePoint List

    Hi @v-litu-msft 

    Thanks for the suggestion, I tried below option it's not working 😞 Do I have to include compose condition before sending out the mail notification?

  • v-litu-msft Profile Picture
    on 27 Oct 2020 at 08:31:54
    Re: How to trigger flow only when a specific field is equal to a specific value in SharePoint List

    Hi @Anonymous,

     

    You could configure trigger condition to make the Flow only be triggered when the shipment damage column value is equal to yes.

    For example:

    @equals(triggerBody()?['ShipmentDamage'], true)

    Screenshot 2020-10-27 163036.jpg

     

    Screenshot 2020-10-27 163059.jpg

    Please have a try, it could help you. 

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Diksha Profile Picture
    301 on 27 Oct 2020 at 08:30:09
    Re: How to trigger flow only when a specific field is equal to a specific value in SharePoint List

    Hello @Anonymous ,

     

    There is no any trigger on a special column in list is modified, if you would like to trigger a flow when a special column in list is modified,

    I afraid that there is no way to achieve your needs in Microsoft Flow currently.

     

    If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

    As an alternative option , you can make use of SharePoint list versioning and HTTP request to check if the particular field is modified. 

    Check out this article which explains this in detail.

     

    If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .
    Thank You !!!

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 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,660 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow