I'm attempting to create a workflow in a SharePoint Online list where, if the 'assigned to' field is changed to a different name, that user is sent an email notification.
The issue is that SharePoint will activate this 'send email' workflow even if another column of the list item is modified. Therefore, I'm looking for a solution where the workflow fires only if that one 'assigned to' column changes.
I've seen some other posts which suggest a workaround where you create a hidden column that contains the old value. Something along the lines of:
IF [assignedTo] is not equal [old.assignedTo] then send email
Many posts mention this hidden column method, but I'm not sure how you can create the hidden column that retrieves the old value.
Any help would be much appreciated.