I have a SharePoint list of managers that has one multi-select lookup column (volunteer name) to a contacts list. The contacts list shows volunteer name and their email address.
When a manager record is changed and a contact has been added or removed, I would like to send an email to the manager and provide them with the email address of their volunteers.
The trigger is when an item has been modified (Manager List). How can I get all the email addresses from the Contacts list using the multi-select volunteer name lookup column from the Manager list?
