Answered

Sending email with HTML Table

(1) Share

Report

Posted on by SA-27111520-0

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)

All responses (2)

Answers (1)

Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
SA-27111520-0 6 on at

Like (0)

Report

Thank you for your feedback @ANB, this has resolved the issue.

Was this reply helpful? Yes No