Forum Discussion
Triggering flow when column in SharePoint List is edited
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.
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.
Thank you very much.
I will implement it and give feedback
Regards
Juan