Skip to main content

Notifications

Community site session details

Community site session details

Session Id : RMjmj+dDhwHHESzOEUMFKO
Power Automate - Building Flows
Unanswered

Limiting Email Notification to Attendees of Corresponding SharePoint List Item

Like (0) ShareShare
ReportReport
Posted on 7 Jun 2022 17:04:24 by 137

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

  • tbrock_troc Profile Picture
    137 on 08 Jun 2022 at 21:13:26
    Re: Limiting Email Notification to Attendees of Corresponding SharePoint List Item

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 61

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 47 Super User 2025 Season 1

#3
rzaneti Profile Picture

rzaneti 31 Super User 2025 Season 1

Overall leaderboard
Loading started