Forum Discussion
Trigger sharepoint workflow when a column value is modified
I've a list which has 30 column fields. One of the fields is Annualized benefit and Review status & Review status(before) Annualized benefit is a numeric field (user input) and Review status is a dr...
The change in field values are stored in version history of each list item. So, when annualized benefit field is modified. The previous and new value are available in version history. Is there any way to retrieve and check for change in value and trigger email alert and set the value back to old value?
I was able to use information from https://powerusers.microsoft.com/t5/Using-Flows/Wait-for-field-change-in-Lists/td-p/113864 to do something much like that. I was able to get the current value as well as the previous value, compare them, and take the appropriate action based on the results.