I have a list (ListA) with a workflow that sends an email notification to persons indicated in the Approvers column. I will also like to send the same email notification to only the new additions to the Approvers column
List columns:
1. Approvers: specified while creating a new Item
2. PreviousApprovers: automatically populated with the information in the Approvers column in New mode
I currently have 2 workflows, Workflow1 starts on New and Workflow2 when an item is modified.
Kindly find below a breakdown of Workflow2 Desing:
- Query list: Queries ListA and stores the information in the Approvers column in collection variable colApprovers and the information in the PreviousApprovers column in another collection variable colPreviousApprovers
- Collection Operation:
Target Collection: colApprovers and Remove by value colPreviousApprovers
- Send Notification: Notification should only be sent to the new additions (the difference between colApprovers and colPreviousApprovers) but I have not been able to get this to work.
Also, I'd like to PreviousApprovers column in the list updated to include the newly added Approvers.
I will appreciate any help I can get with this.
Thank you.