Oct 01 2023 10:51 PM
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
Oct 01 2023 11:46 PM
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:
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:
Once you have created and tested your flow, it will be triggered whenever the specified column in the SharePoint list is updated.
Oct 06 2023 12:21 AM
Oct 06 2023 06:06 AM
Solution
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.
Oct 25 2023 05:00 AM
Oct 25 2023 05:56 AM
Above 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.
Oct 25 2023 06:21 AM
Oct 25 2023 10:30 AM - edited Oct 25 2023 10:33 AM
@JFM_12 I fully agree with @ganeshsanap who is a highly experienced member of our community; the responses by @Lalit Mohan are always AI-generated and often contain errors. Many forums don't allow AI-generated responses and I think the Microsoft tech forums should do this as well; they don't indicate that the poster has any idea what they are talking about or has any real-world experience and it's just lazy. But more damagingly it's often giving a totally wrong answer.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
Oct 25 2023 11:32 PM
Jun 11 2024 01:01 PM
Aug 27 2024 12:46 PM
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
Oct 06 2023 06:06 AM
Solution
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.