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,

Power Automate

Hi all,

 

We have an exciting SharePoint connector update available for you all to test in Power Automate preview environment. Would love you all to try and let us know any feedback. Excited to share the following new SharePoint trigger, and action is available to test in your Preview environment. 

  • When an item or a file is modified
  • Get changes for an item or a file (properties only)

As the name suggests, the trigger runs the flow only when an item or a file is modified. We hope this new trigger allows customers to build flows that run only on updates instead of the creation and modifications of an item or a file. 

 

when-an-item-modified-trigger.png

 

When an item or a file gets modified, one of the typical scenarios is the ability to understand what columns were updated. The 'Get changes for an item or a file' action, for a given item or a file, in a given time interval window, fetches you all the columns modified since the last flow check. 

  • You can use the dynamic outputs 'Trigger Windows Start Token' and 'Trigger Window End Token' from the 'When an item or file modified' trigger for specifying the time interval in this flow action. 
  • The action's output includes dynamic Boolean properties that help you quickly identify which columns have changed since the last flow check. For example: 
    • Has Column Changed: Id
    • Has Column Changed: Title
    • Has Column Changed: Level
  • To use this action, you will need to turn on versioning in the list or the library. Under the hood, it uses Version History to look at past states of the item and diffs each version that's relevant in the time window and reports on which columns have changed.

 

get-changes-for-item-file.png

You can now quickly check if the column had changed and build your flow accordingly. 

 

check-for-column-modifications.png

 

Thanks,

Chakkaradeep

New Member

We also need this feature to be deployed. We have older SharePoint sites where Nintex forms are used extensively and we are migrating to Sharepoint 365. Power Automate doesn't have this feature to trigger an action only when an existing (specific) field from a list is modified. We are non IT users and this trigger would help tremendous our effort in the migration to Power Automate. Thank you!