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
Kudo Kingpin

outstanding news - finally. We really waited for this one ... thanks a ton  😀😍 it

Frequent Visitor
Frequent Visitor

Please apply the same logic to Microsoft Planner:

 

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Planner-Trigger-When-a-task-is-modified/idi...

 

All Microsoft Flow Products should have a "When X is updated/modified" 

Helper III

So, where are with this idea, please?  I really need this functionality, and see this request has been in Planning for quite some time.  Please give an updated response as to current status.  Thanks!  

Advocate II

Please we need this feature!!

Regular Visitor

@Chakkaradeep    Has this feature  "When a column value changes in a list or library" been delivered yet?

Frequent Visitor

Has this feature  "When a column value changes in a list or library" been delivered yet?

Power Automate
Status changed to: 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,