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

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Sending single email containing all the related records

(0) ShareShare
ReportReport
Posted on by 21

Hello,

 

I have generated some distinct records that look like this using the "union" function. I need to send a single HTML email for each of the following "PM Email"s that contains only their related records. So Ibrahim should be sent 2 records while Adam should be sent 1 record as per the table below. I know this could be done using "Apply to each".

 

PM Email

PM Name

NC Description

NC Status

Project Name

NC Due Date

iabuzahra@abcd.com

Ibrahim

NC1

Open

Proj1

2023-12-22

iabuzahra@abcd.com

Ibrahim

NC2

Open

Proj1

2023-12-23

adam@abcd.com

Adam

NC2

Open

Proj2

2023-12-11

john@abcd.com

John

NC1

Open

Proj3

2023-12-13

 

I am able to send the full records as shown below. But my problem is sending those single emails for each of the email addresses

screen.png

I have the same question (0)
  • creativeopinion Profile Picture
    10,480 Super User 2025 Season 2 on at
    Re: Sending single email containing all the related records

    @ashraf999 Please take a look at this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

     

    IN THIS VIDEO:

     How to send multiple list items in a single email with a Power Automate Flow

     How to create a dynamic date range

     How to use the Convert Time Zone action

     How to use a Filter Query in the Get Items action

    How to count number of items in an array

     How to use the Select action to extract a users display name and email address

     How to create a unique list of email addresses

     How to use the Create HTML Table action

     How to customize the HTML Table with CSS styles

    How to use the Send an email (V2) action

    How to use the Append to String Variable action

    How to create a custom list of items for an email

    How to use the Send an email (V2) action

    How to display singular or plural text based on the number of items returned

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

  • ashraf999 Profile Picture
    21 on at
    Re: Sending single email containing all the related records

    I tried to replicate what is on the video but I am stuck here. I am getting no values for the filter array:

     

    screen2.png

    I am looping through emails instead of users . The output after "Apply to each 3" is the unique emails

     

    Untitled.png

  • Verified answer
    ashraf999 Profile Picture
    21 on at
    Re: Sending single email containing all the related records

    I resolved the issue by applying the following flow:

     

    screenshot.png

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 535 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 348 Moderator

#3
developerAJ Profile Picture

developerAJ 262

Last 30 days Overall leaderboard