Forum Discussion
Solved
Triggering flow when column in SharePoint List is edited
Hello
I want to create a flow that runs when information in a column of a SharePoint List is updated
There is an action called "When an item is created or modified". But is there an action that specifically watches at a column and starts when this column is updated?
Thank you very much
JFM_12
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
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.
Dears,
Please i need your support i am using the solution suggested form your side, however in the first step "Get changes for an item or file" and i pick "ID" it suddenly changes into "apply to each" as indicated in the screenshot
- Hello Lalit
Hello Ganesh
Lalit, you write on the step 4 about Filter. But with that trigger you mention there is no "Trigger".
4. In the Filter section, click Add condition.
Do you mean to add an action an then filter it?
Thank you
JFM_12Above response by Lalit is AI generated response and it does not work in Power Automate flows (I believe he did not test his solution before responding here). There is no filter option in the "trigger".
Check the links given in my response and solution given by April Dunnam, it should work for you.
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.
Hi JFM_12
Yes, you can trigger a flow when a column in a SharePoint List is edited. To do this, you can use the following steps:
- Create a new flow in Power Automate.
- Add the When an item is created or modified trigger.
- In the Site address and List name fields, select the SharePoint site and list where you want to trigger the flow.
- In the Filter section, click Add condition.
- From the Dropdown menu, select Column changed.
- From the Column menu, select the column that you want to watch for changes.
- Click Save.
- Add the actions that you want to run when the column is updated.
- Save and test the flow.
For example, you could create a flow that sends an email to a specific person when the Status column in a SharePoint list is changed to Completed.
To do this, you would add the following steps to your flow:
- Add the Get changes for an item or file (properties only) action.
- In the Site address, List name, and Item ID fields, select the corresponding values from the trigger.
- In the Column field, select the Status column.
- Add the Send an email (V2) action.
- In the To field, enter the email address of the person who you want to receive the email.
- In the Subject field, enter a subject line for the email.
- In the Body field, enter the body of the email.
- Save and test the flow.
Once you have created and tested your flow, it will be triggered whenever the specified column in the SharePoint list is updated.
- Hello Lalit
Thank you very much.
I will implement it and give feedback
Regards
Juan
