Trigger Options in Microsoft Flow

Question

I have been struggling with this issue in the last few days. I have a simple SP online list with Status and comments fields. The flow is triggered when the Status changes to Completed. What I want to achieve is when I update the comment filed(it can be at anytime even after the status change completed), the flow doesn't begin. At the moment, the flow is triggered when the item gets modified, and every time I add something to the comment field, the flow will start.

Kind Regards

Answer 1

so as I understand it, you wont the flow to trigger when status is set to Completed, and after that not to run again.

Right now your trigger condition will run on every edit as long as the Status is set to Completed. So you need to add one more condition so that it only runs the first time it is set to Completed. There are different ways this can be achieved, but I think in your case this makes the most sense:

1. Add another field "WorkflowHasRun" and set the fields default value to "No"
2. Update the trigger condition to @and(equals(triggerOutputs()?['body/Status/Value'], 'Completed'),equals(triggerOutputs()?['body/WorkflowHasRun/Value'], 'No'))
3. Add an update item action to your workflow that sets the "HasWorkflowRun" value to "Yes"

This way the workflow will only fire once per item after it is set to Completed.

There is of couse also the possibility to let the flow check if the Status field has changed (with the Get Changes action), but this is perhaps more suited if items can go back from the Completed status and then later again go to Completed.

Hope it works :)