cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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

1 ACCEPTED SOLUTION

Accepted Solutions

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 !!!

View solution in original post

9 REPLIES 9
Diksha
Resolver IV
Resolver IV

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 !!!

v-litu-msft
Community Support
Community Support

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.

Anonymous
Not applicable

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?

Anonymous
Not applicable

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. 

 

 

 

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 !!!

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.

Anonymous
Not applicable

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

 

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 !!!

Anonymous
Not applicable

Hi @Diksha ,

Thanks, working perfectly. 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,549)