HTML email from excel file to multiple user

Like (0) Share

Report

Posted on 12 Aug 2021 07:58:12 by sharontung

Hello,

I'm create a flow using data from an Excel spreadsheet to individually send an email to recipients listed in the table. The email contains a html table. right now i stuck continue the flow to send individual emails.

Excel Table

End result

How to amend the flow for example sharon only able received 1 table according excel table instead 2 table.

All responses (3)

Answers (1)

Verified answer

Mitanshu 1,635 Super User 2025 Season 1 on 15 Aug 2021 at 16:07:38

Like (1)

Report

Re: HTML email from excel file to multiple user

I take from your message that now you are now getting a list of distinct emails and that only one email is sent to each person.

To make sure they get only their rows, under the Apply to Each loop - you need to add a Filter Array action (which I see you have added).

Under From - you select dynamic content the "Value" coming from Excel action
Under Choose a Value (on left of condition) - you select dynamic content "Email" which is a column
Under Choose a Value (on right of condition) - you select dynamic content "Current Item"

Use the resultant array to format your message and send the email out to "Current Item" - I don't think you don't need a second Apply to Each loop.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.
sharontung 27 on 15 Aug 2021 at 10:35:29

Like (0)

Report

Re: HTML email from excel file to multiple user

Hi @happyume,
I tried follow the steps given but not luck still not working. Email did received but the data/ information in email were in incorrect method. Could you please advice further
I really need your advise urgent. below is the screenshot from my power automate flow.

Regards
Sharon
Mitanshu 1,635 Super User 2025 Season 1 on 12 Aug 2021 at 20:52:42

Like (0)

Report

Re: HTML email from excel file to multiple user

1 - Get array containing distinct email address using expression union(Manager,Manager)
2 - Iterate over this distinct email address array and send email containing specific table rows.

Please click Accept as solution 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 Thumbs Up.