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 / Send separate emails w...
Power Automate
Unanswered

Send separate emails with HTML Table

(0) ShareShare
ReportReport
Posted on by 90

Hello Forum!!

 

I have a SharePoint List where I would like to create an HTML table and send emails to users.

 

For example:

 

Employee Name              Task Name                               Date

Joe Stephens                   Clean Science Room                 6/12/2020

Joe Stephens                   Clean Math Room                     6/12/2020

Sally Rae                          Fix School Bus                           6/12/2020

Sally Rae                          Training                                     6/12/2020

Sally Rae                          Meeting                                     6/12/2020

Jimmy Doe                      Manage Classroom                    6/12/2020

Jimmy Doe                      Update Gradebooks                   6/12/2020

 

I would like to send 3 separate emails, one for each person that shows only their tasks in an html table.

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,981 Most Valuable Professional on at

    Hi @lparkerMDVIP 

     

    Have you got employee names before hand. Then construct an array with all the values. If you don't have the employee names before hand then first do a Get Items and iterate each records and append an array variable with unique name. Before append you need to check whether name already exists or not. Once you had all the names then do a Get Items and set the filter query using each names. Finally you use the send email using the Get items filter query results.

     

    Thanks

  • abm abm Profile Picture
    32,981 Most Valuable Professional on at

    Hi @lparkerMDVIP 

     

    Please see this post about how to get unique values from an array.

     

    https://powerusers.microsoft.com/t5/Building-Flows/Having-an-array-take-unique-values-email-addresses-from-a/td-p/278513

     

    Thanks

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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 60 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 54

#3
Expiscornovus Profile Picture

Expiscornovus 47 Most Valuable Professional

Last 30 days Overall leaderboard