In SharePoint 2010, I have a people picker field named 'Additional Assignee' that allows multiple entries. I need to be able to generate an email notification each time someone is added, but the notification should only be sent to the new people added and not the people already listed (they would have received an email when the item was created.) Any ideas on how to best accomplish this? Thank you!
Off the top of my head, this may be a situation where you have another list, and, when your Additional Assignee gets a notification, it logs their name into this different list.
The workflow then would be "Is Additional Assignee NOT in the list? Then, send a notification and log them to the list. If they ARE in the list, then don't send a notification"
What do you think - would that work?
I see this as a scenario where you need to compare the current values in the "Additional Assignee" to the previous value and then determine the difference. While you can trigger a workflow to start based on comparing the current and previous value, there is no way to get the data from the previous value of a field in the workflow. So the way that you could accomplish comparing the current value to the previous is through the use of a second column that would store the previous value.