SOLVED

Triggering flow when column in SharePoint List is edited

Iron Contributor

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

10 Replies

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:

  1. Create a new flow in Power Automate.
  2. Add the When an item is created or modified trigger.
  3. In the Site address and List name fields, select the SharePoint site and list where you want to trigger the flow.
  4. In the Filter section, click Add condition.
  5. From the Dropdown menu, select Column changed.
  6. From the Column menu, select the column that you want to watch for changes.
  7. Click Save.
  8. Add the actions that you want to run when the column is updated.
  9. 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:

  1. Add the Get changes for an item or file (properties only) action.
  2. In the Site address, List name, and Item ID fields, select the corresponding values from the trigger.
  3. In the Column field, select the Status column.
  4. Add the Send an email (V2) action.
  5. In the To field, enter the email address of the person who you want to receive the email.
  6. In the Subject field, enter a subject line for the email.
  7. In the Body field, enter the body of the email.
  8. 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
best response confirmed by JFM_12 (Iron Contributor)
Solution

@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.

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_12

@JFM_12 

 

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.

Hello
Thank you very much.
I did it and worked. Thank you very much
JFM_12

@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)

Hi Rob
Hope you are doing well.
Thank you very much for your answer.
Have great time.
Regards
Juan
I didn't know AI could pull stuff out their rear end 🙂 Thank you Rob and Ganeshsanap!

@ganeshsanap 

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 

 

Screenshot 2024-08-27 224430.png

1 best response

Accepted Solutions
best response confirmed by JFM_12 (Iron Contributor)
Solution

@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.

View solution in original post