web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Limiting Email Notific...
Power Automate
Unanswered

Limiting Email Notification to Attendees of Corresponding SharePoint List Item

(0) ShareShare
ReportReport
Posted on by 139

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

Categories:
I have the same question (0)
  • tbrock_troc Profile Picture
    139 on at

    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard