How to stop infinite flow trigger in Power Automate using flag column
Infinite flow trigger is a common scenario in workflow softwares like Nintex, K2 and even in Power Automate. If the Canvas app is involved in this process we can handle it easily with the “Flag” column.
Create a Flag column with default values as “Yes”
Customize form for this list, Set default value for the “Flag” control as “Yes” and hide that Datacard.
Navigate to the workflow, In the Update item action set the “Flag” field as “No”.
Now we will make use of the Trigger Condition in Power automate to trigger the flow on a specific condition.
Select the Menu of “When an item or a file is modified” trigger action => Select Settings => Add trigger condition
Now we will update the item, to check the flow triggered more than once.
We are setting to trigger if the flag column has “Yes” in the flow, When we update the record it is updated as “Yes” and while updating the item in flow as “No” it will not trigger again.
This will work if we have a canvas app to update the flag value otherwise we have to rely on other options mentioned in the CSOM update and Rest API update posts.
Please post your queries in the comment section. Happy building 🙂