cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tbrock_troc
Helper II
Helper II

Limiting Email Notification to Attendees of Corresponding SharePoint List Item

My team uses a SharePoint list to track events and trainings and have been working on a 30-day email notification to alert the attendees that they are assigned to the event. The 'Attendees' field in this list is a person/group field. At this point, my flow is calculating the 30-day mark and sending emails to those listed in the 'Attendee' field.

 

However, the issue I have now noticed is that my flow appears to generating 1 string of emails for the all of the attendees for every event with the same start date. Here are some examples through my testing:

 

  • I had created 2 events with a start date that was 30-days out - one of the events had attendees listed and the other had a blank attendee list. When the scheduled flow triggered, the attendees listed for the one event received a notification for both events. The event without any attendees listed shared the same attendee list as the event with attendees listed.

  •  I had created 2 events with a start date that was 30-days out - each had a different person listed as an attendee. When the scheduled flow triggered, both attendees received email notifications for both events even though they were listed as an attendee on only one.

What would I need to do in order to limit the email notification to the attendee list for the corresponding SharePoint List item when multiple items have the same start date?

Here is my flow:

 

EmailNotification_1.png

 

 

 

 

 

 

 

 

 

 

 

 

 

EmailNotification_2_LI.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

EmailNotification_3.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

EmailNotification_4.png

 

 

 

 

EmailNotification_5.png

1 REPLY 1
tbrock_troc
Helper II
Helper II

It seems I was able to add to the ODATA filter to prevent events without attendees listed from being pulled in:

 

EmailNotification_6_LI.jpg

 

 

 

 

 

 

 

 

 

 

 

However, the email distribution lists for events with attendees are still being merged into a single distribution list which is applied to the email for each event.

How can I get the flow to only send the event details to the attendees of that specific event?

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,760)