Forum Discussion
toby.mcdaid
Dec 04, 2018Copper Contributor
Automatically send an email to a user when 'assigned to' column is modified? (SharePoint Online)
We have a list that contains items which go through an approval process. When a list item is first created, a name is put into the 'assigned to' column, indicating the first approver. When that user ...
Matt Weston
Dec 04, 2018Iron Contributor
Hi Toby, in the old days of event receivers your had a before and after properties which you could use to ascertain whether a field had changed. With Flow you may need to be a little more devious with your resolution, by storing the "previous approver" in a field which you hide away. Then each time your Flow runs, compare the "Approver" to the "Previous Approver" and if they don't match then process as a new approval. Then each time your run the approval, change the "Previous Approver" to the name of the person who just approved (How many times can I say approve in one sentence!).
Try that first of all and see if we get into the ballpark of what you're trying to achieve.