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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sending email with HTM...
Power Automate
Answered

Sending email with HTML Table

(1) ShareShare
ReportReport
Posted on by SA-27111520-0 6
HI,
 
I have a flow that I created to send an email containing an HTML table of items from a SharePoint list. This works fine if I add a static email address to the however, when I try to add a dynamic email address the email is added to an Apply to Each wrapper and the email is sent out for each item in the HTML table i.e if there are 5 rows in the HTML table the email gets sent out 5 times.
The Flow I have is shown below.
 
 
How can I set this up so that the email is sent out only once?
 
Many thanks in advance for any help that I might get.
Categories:
Building flows
I have the same question (0)
  • Verified answer
    ANB Profile Picture
    ANB 7,250 Super User 2026 Season 1 on at
    Hi @SA-27111520-0, The reason it is sent to multiple users because you are using dynamic content from Get Items action which is an array.
     
    Please try this:

    1. Send Email Outside "Apply to Each"

    • To send a single email to a dynamic recipient:
      • First, build the HTML table outside of the "Apply to each."
      • Then, collect your dynamic email address (for example, the value you want to send to) once into a variable or compose action—make sure it's not wrapped in the "Apply to each".
      • After building your HTML table and setting your email variable, use a "Send an Email" action outside the loop. Set "To" to your variable.
    •  
    2. For Multiple Recipients
     
    • If you want to send to all emails found in the SharePoint list:
      • Use the "Join" action to combine all the email addresses into a semicolon-separated string (e.g., user1@domain.com;user2@domain.com).
      • Set that string as your "To" field.
      • Place the "Send an Email" action outside of the "Apply to each."
    •  
    3. Example Approach
     
    • Get items from SharePoint
    • Initialize variable: EmailRecipients (type: String)
    • Apply to each (value from 'Get items'):
      • Append each item's email address to the variable, separated by a semicolon.
      • Build your HTML table, if needed.
    • Send an Email (outside of "Apply to each"):
      • To: EmailRecipients variable
      • Body: HTML Table
     

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.


    Thanks,
    ANB
     
  • SA-27111520-0 Profile Picture
    SA-27111520-0 6 on at
    Thank you for your feedback @ANB, this has resolved the issue.

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

News and Announcements

Welcome to the Power Platform Communities

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
Haque Profile Picture

Haque 605

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans