cancel
Showing results for 
Search instead for 
Did you mean: 

Create a trigger for SharePoint list columns

It would be nice to have a trigger if a certain column in a SharePoint list is modified. For example, if the column "Status" is modified, or if the column "Assigned To" is populated. So we don't have to use the trigger "When an item is created or modified", where you have to create a lot of workaround conditions just to make sure that the column that was updated is what you need. 

Status: Started

Hi all,

 

Happy to announce that we started the development of building granular trigger for SharePoint item and file changes along with a new action to check if a particular column value was modified since the last flow run.

 

To support this, we will be releasing a new trigger and a new action that works along with this new trigger to help you get started. 

 

  1. 'When an item or file is modified' trigger
    1. Only triggers on an item or file updates, not on an item or file creation.
  2. 'Get item or file properties changes' action
    1. This new action returns information about whether or not a column's value was modified.
    2. This action when released will:
      1. Only work with the 'When an item or file is modified' trigger.
      2. Require versioning to be turned on for the associated list or library 

 

With these two updates, you can now build a flow when someone modifies a list or library and then using the new action check if a particular column or file property was modified since the last flow run. For example, you can check if the Status column was modified since the last run and then get the current Status value, else do something else.  

 

After this update, we will continue to work on enabling the 'Get item or file properties changes' to provide old and new values of the columns as well. 

 

Thank you all for being patient with us. Will update this thread as we have more updates.

 

Thanks,

Comments
Frequent Visitor

This is really needed.

Frequent Visitor

Another business case here where it would help not only the technical administrators but also the self-service users.

Advocate I

So this idea is nearly 18 months young, and has some of the most votes. This is clearly a feature that is needed. When will this be implemented?

Regular Visitor

Users like SP lists to control the intake of requests as a rudimentary ticketing system. Flow is setup to send notifications to submitters based on item 'status' column. Current triggers/actions offer a setup where every time the item is being edited (irrelevant of the field) the flow sends the email notification to the user based on the column value used in the Switch. The business application is to have control over email correspondence to account for maintenance and user error. If admin wants to analyze or recode historical data, there is no way to do this without spamming all users. 

New Member

What's up with this request already?!   How can anyone create a robust workflow without knowing what specific column has been modified?

Regular Visitor

This would help a great deal to have this feature!

Power Automate
Status changed to: Under Review

Hi all,

 

We understand the pain points expressed here, and we are currently investigating options in building granular flow triggers for item updates and column changes in SharePoint.

 

We respectfully ask for your continued patience on this topic for the remainder of this calendar year. We are committed to a viable solution for our customers worldwide, and will continue to post updates here as we solidify our plans (which will most likely be early next year). Again, thank you for your patience, and your feedback on Microsoft Flow integrations with SharePoint.

 

Thanks,

Chakkaradeep (Chaks)

Advocate II

@Chakkaradeep Thank you for your attention to this all-important enhancement! Really looking forward to this and other enhancements to Flow. If you ever need an example use case, please feel free to let me know. My organization relies heavily on complex Flows and we have had to create several complicated workarounds to address limitations like this one. Thank you again!

 

-Alex, RHCC

Advocate V

*Ironic*
I read "early next year". Wow, that's only 1.5 years after this topic was opened, and keep in mind that most of the time it was one of the top-chosen topics. This is very fast for a company that works according to customer-oriented agile development methods. * ironic off*

 

Excuse me for not having good words, but after chatting in other topics, and watching some months in the "ideas-forums" and seeing that it takes very, very long time untill top-chosen ideas are worked on, in times of agile development methods, that's still very disappointed for me.

 

@Chakkaradeep 

In any case, nice to read that you will start to work on this at all!

 

 

Please do not forget to bring this topic along, that you promised and therefore closed!

 

-> Disable Event Firing when Flow updates a SharePoint list item
https://powerusers.microsoft.com/t5/Flow-Ideas/Disable-Event-Firing-when-Flow-updates-a-SharePoint-l...

 

(Found Problems deeply explained on Page 14-15++ in that topic)

 

 

In general: Please take a look at the other top-selected topics that are partially several years old here in Flow Ideas and also in MS Forms Ideas.
I think that the top 10-15 of the open ideas out of the hundreds of ideas should be actively worked on. At least in next months, and not in next years.

Thank you!

Power Automate

I wanted to share this video which discusses the Trigger Condition setting on triggers. Please let me know if this helps with the scenarios you're thinking about for this idea:

 

Link: https://www.youtube.com/watch?v=FcTMBQ9KuUA

Thank you,

Audrie