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 / 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,975 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,975 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

Forum hierarchy changes are complete!

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

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard