Email specific user added/removed to/from Multi-Person Field (SharePoint / Power Automate)

Copper Contributor

I currently have an event list with a "Participant" person column set to allow multiple selections.  Is it possible to automate an email when a new user is added or removed from this column?  I don't want to email all the users in the column, just the new or removed user only.

Essentially, I want to automate an email to the user with the event details they have been registered for.  I would also like an automated email when a user is removed, to inform them they are no longer registered for the specific event.  Any help or direction will be greatly appreciated.

Thanks,

JLNMetsFan
"Let's Go Mets!"

2 Replies

Hi @JLNMetsFan , this sounds like a process best supported by two lists, one containing event detail and a second containing attendees. The email notifications would be relatively simple to automate if you were using a PowerApp frontend to administer the attendee list. Your submit/delete buttons would activate a flow to send an email.

 

If using purely Power Automate I'd still recommend two primary lists but you would also need an audit log of attendees to compare against in order to determine whether a record was added or deleted, and then trigger a conditional flow. After the emails were sent the audit log would be refreshed to match the current state of the attendee list.

@jonlake 

I've found videos on this suggestion "If using purely Power Automate I'd still recommend two primary lists but you would also need an audit log of attendees to compare against in order to determine whether a record was added or deleted, and then trigger a conditional flow. After the emails were sent the audit log would be refreshed to match the current state of the attendee list." And I get the list and then the audit list and the flow to refresh the audit log, however I can't find anything on the actual sending of the emails.

 

I have a list with tasks assigned to a person. I want to send an email to that person when they are either added or removed from that task. I'm not sure how to set up to send the email. This video is helpful but it doesn't show the part of sending the email. SharePoint & Power Automate - Only Run When a SINGLE COLUMN Changes!! (youtube.com)