Hi @Anonymous
Got a solution on how you can check whether the review column is updated or not .
For demo, i have created a demo sharepoint list
Now my requirement is when the Data3 column changes, i need to execute required actions 🙂
For that i have developed a sample flow like below
1. Here first used the trigger when file/item is modified
2. Next to detect what are changes happended in sharepoint/ what are column values have changed, I have used Get changes for item or a file to detect which columns has changed, this would true/false value for each column whether they have changed or not.
here ID is the id of list item changed obtained from when file/item is modified. Since field, we have to pass version previous to current version. Current version you can get it from the dynamic content under when file/item is modified.
to get previous version , we have to subtract 1 from the current version, so i have expression in Since field to do that
Expression used here : sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
Now after this, you can use a condition to check whether the review column is changed or not.
The output of get changes in item or file will be like below
You can see dynamic content starting with Has Column changed with column, this is boolean variable which denotes whether column is changed or not since last version to current version.
If changes, it will have value true, else it would have false.
so here i am checking whether Data3 column is changed or not here in my demo
If it is changed, it will go to yes section, there you can place all your sequence which you need to perform once review column is changed 🙂
Hope this helps !
Mark it as solution if it resolves your query
