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:


Report
All responses (
Answers (