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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sending Consolidated R...
Power Automate
Answered

Sending Consolidated Reminder Emails to Multiple Assigned Users

(0) ShareShare
ReportReport
Posted on by 11

I'm fairly new to Power Automate and am facing a challenge with a specific task. I have a SharePoint document library and need to send a single reminder email for multiple documents to each individual listed in the "Assigned To" column, which allows for multiple people. Each assigned person has unique permissions and can only see their documents.

Here is an example of the library structure:

 

Name

Title

DueDate

Status

AssignedTo

Doc1

Description1

20231106

Completed

Person1; Person2

Doc2

Description2

20231205

Pending

Person1; Person2

Doc3

Description3

20240101

Pending 

Person1; Person3

Doc4

Description4

20231115

Pending 

Person4; Person2

Doc5

Description5

20231120

Pending 

Person4; Person3

 

I have found a great post on how to create a reminder I need, which sends one email to the 'Assigned To' person: https://powerusers.microsoft.com/t5/Building-Flows/Sending-one-reminder-for-multiple-tasks/m-p/150723

 

However, my situation is complicated by the fact that the "AssignedTo" field contains multiple persons (usually 2-3), and I need to send a list of their incomplete tasks to each person. For example, in the scenario above, 'Person1' would receive an email including "Doc2" and "Doc3", 'Person2' would receive "Doc2" and "Doc4", and so forth.

 

I would greatly appreciate any guidance or help with this.

 

Thank you in advance!

Categories:
I have the same question (0)
  • Verified answer
    v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @martusha 

    According to your description, you want to send an email to the people with the Pending data.

    Here are the steps you can refer to :
    (1)This is my test data in my SharePoint List:

    vyueyunmsft_0-1699325951123.png

    (2)This is my flow:

    vyueyunmsft_3-1699326076624.png

     

    [1]The "Get Items" and "initial variable" steps:

    vyueyunmsft_2-1699326015577.png

    [2]The "Apply to each 2" action:

    vyueyunmsft_4-1699326133105.png

    items('Apply_to_each')?['Email']

     

    [3]The "Apply to each 3 " action:

    vyueyunmsft_5-1699326318076.png

    union(variables('Persons'),variables('Persons'))

    toLower(join(item()?['AssignedTo#Claims'],','))

    toLower(items('Apply_to_each_3'))

     

     

    (3)Then we can get the email for the aniyazhang:

    vyueyunmsft_6-1699326387027.png

     

     

    Best Regards,

    Yueyun Zhang

  • martusha Profile Picture
    11 on at

    OMG! What's working! Thank you very much!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 873

#2
Valantis Profile Picture

Valantis 813

#3
Haque Profile Picture

Haque 526

Last 30 days Overall leaderboard