cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Pieter_Veenstra

Modified trigger should give previous values for fields changed

Submitted by on ‎02-28-2018 05:01 AM

When triggering a Flow on the modification of a list item then it should be possile to get the current and previous values of the fields that were changed. 

 

Status: Started

Hi all,

 

Happy to announce that we started the development of building granular trigger for SharePoint item and file changes along with the plan to provide old and new values.

 

To be able to infer and provide old and new values, we will first need the ability for a trigger that can run when an item is modified and then the ability to get what changed for that modified item. So, 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. 

 

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

 

Thanks,

Chakkaradeep

See more ideas labeled with:
36 Comments (36 New)
Comments
lukascaplikas
Helper I
Helper I
‎11-23-2020 04:46 AM

Lets wait for this section:

 

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.

 

😕

 

Currently I want to see what was old value and current value.

JamesVulicevic
Regular Visitor
‎01-07-2021 11:24 AM

Hi @Chakkaradeep When is the feature to get the old value be available. It is much needed!


Thanks,

 

James

Anonymous
Not applicable
‎04-09-2021 07:05 AM

Seems silly to me that this isn't default functionality.  Please implement.  

PabloD
Advocate I
Advocate I
‎05-26-2021 03:10 PM

Meh. It will not give the old/new value, so if you need to compare the values (instead of only detecting if something changed) you still need to access the previous version via the SharePoint API... 

Here's someone who did that, if you are interested: https://www.catapultsystems.com/blogs/get-previous-versions-of-sharepoint-list-items-in-flow/

teqs
Kudo Collector
Kudo Collector
‎05-30-2021 07:54 AM

quote from MS dev comment:
"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. "

Really cool that MS is working at this at all. But it still feels a bad to read a explanation like this for a feature from 2018 which was top voted most of the time. This feature really make things easier. Thanks for implementing soon!

Martin14
New Member
Monday

Oooooh I was hoping for this to be done by now, haven't needed it in a while but now I do again, but no update on when it will be done. Could I ask for an update on the status?