Answered

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

(0) Share

Report

Posted on by Community Power Pla...

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 list

Thank you

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (1)

Diksha 301 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

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

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.

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

Like (0)

Report

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?

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

Like (0)

Report

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.

Was this reply helpful? Yes No
Diksha 301 on at

Like (0)

Report
Hello @Anonymous ,

Use a trigger When an item is created or modified and set the Trigger Condition as below -
@equals(triggerBody()?['ShipmentDamage'], 'Yes')

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

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

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

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.

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

Like (0)

Report

Hi @v-litu-msft ,

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

Sharepoint list screenshot

Was this reply helpful? Yes No
Verified answer

Diksha 301 on at

Like (1)

Report

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

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

Like (0)

Report

Hi @Diksha ,

Thanks, working perfectly.

Was this reply helpful? Yes No