Forum Discussion
Triggering flow when column in SharePoint List is edited
- Oct 06, 2023
There is no dedicated trigger for SharePoint list column changes. Also, you cannot check if the column value is changed or not directly using the trigger conditions.
Hence, you will have to let the flow run and then inside the flow check if column value is changed or not using "Condition" action. Based on the condition, you continue the flow if column value is changed or terminate the flow.
You can check if the column value is changed or not by following my answer at: Conditionally trigger flow based on the previous value stored in the column - link to detailed blog & video by April Dunnam provided here
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
The best solution is to create a mirror field for the monitored one and use a trigger condition inside the triggering event (e.g. "When an item or a file is created or modified"), with a formula "@not(equals(trigger...))" to compare the monitored field with its mirror one and, if different, trigger the flow that should end with updating the mirror field with the value of the monitored field. Not easy to explain in only a few lines, but a good demonstration is available here: https://www.youtube.com/watch?v=ky2GPnf_GpQ