Send Unique Emails with HTML Table using Data from Excel #PowerAutomate

How to combine two tables in excel to form one email per user, using Power Automate, Filter Array Actions, HTML Formatting / Styling, and Excel.

Also, learn how to get unique managers /emails using select and compose (with union) and create an array of Distinct Email Addresses.

To date I have answered 400+ solutions as a super user and this is an insight into how I build out a solution for an end user. Contributing to the forum is a great way to accelerate your understanding and career. Feel free to reach out to me as DamoBird365 on LinkedIn / Twitter & Reddit or drop me a message below.

00:00 Intro
00:46 Getting the data setup in Excel
01:55 Creating the PowerAutomate Flow
03:31 Filter Array
07:00 Email HTML Table Styling
08:24 Running the flow
09:17 Editing the columns returned by Create HTML Table
11:25 Using Select, Compose, Union to get Distinct Email Addresses
14:22 quick overview of new Solution with Distinct Emails
15:20 Woopsie - dynamic Email no longer exists
15:55 Review of Flow History and Exploring the Distinct Array of Emails
16:21 Outro

[datadragyn]

I appreciate the fact that you keep the errors you encounter instead of editing them out.

[anshukumari]

A similar solution is available on YouTube but the way to make it simpler in terms of explaining is what I like about you. I really look forward to your videos. Thanks for your time and effort. You are helping people like me to do better in career.

[allrise]

Thank you so much for this video! Our leadership team was in a panic about how sending out a ton of individualized emails and this provided a perfect solution. I've never used PowerAutomate before and I was able to get this created in an hour.

[erinfield]

This was incredibly instructive, I'm going to be watching this 30 more times. So my problem is I want to do what you're doing here, but in Power BI, and I want Power Automate to filter what points are selected on a map of properties in Power BI, and send an e-mail with the loan numbers hyperlinked along with their addresses, city, postal code, etc. All the loan data is stored in Sharepoint. The hyperlink leads to an inspection form (already created in Power Apps). Thank-you if you do a video for this!

[A-broken-clay-jar]

This is what I was looking to expand to my Power Automate email series.

[FabioSilva-kjbm]

Amazing. It was just what I've been looking for hours. I really appreciated. Thanks for the clear explanation.

[garcialex]

Awesome!! I was trying to make something like this but I was lost. I need to send many emails based on the client info when every client can have many contracts related and wanted to just do what you showed. Many thanks!

[racewin]

knowing about filter array was very useful. I was doing apply all condition and reading rows one by one. Super thanks 🙏

[kunalIndia]

Thank you so much. You helped me on my way to build automation for my work. I appreciate. :)

[apacsvcmarketingcytiva]

Hi, thank you for the great video! You have saved tons of my time! Some additional questions on this video - 1) can you please kindly guide if I could use cc/bcc function with this flow? If yes, is there a video that I can refer to? 2) can I also add/use Name in the email body? For example, instead of sending only the table, I was wondering if I could customize email body as: Hi XXX (Name), hope this email finds you well. :)
Thank you for your time!

[TimothyCha-uv]

Just wanted to add my thanks to posting this video! Great stuff. I am new to Power Automate. I was able to recreate the initial scenario with a separate unique manager table. However, when I removed that table from the flow, my "Send an email" action was preceded by a second "Apply to each" and many duplicate emails were sent. I think this occurred because in my email body, I was trying to include a field from the Data table (in my case, it was the first name of the manager).
Any tips on how to add this from the Data table itself (for instance, the column H value from your video 1:42)?

[Worrelpa]

Thanks Damian. One further tip I would give. For any html emails put the html into a compose action and then inject the outputs of that into the email.

Why? Well that send email step has two modes standard editor and html. If you put things in the html editor and accidentally put it back to standard things get seriously messed up especially special characters like // <> etc. That has messed up some of my flows big time.

The other advantage of using the compose steps is you canconstruct emails in sections and inject outputs as you need them. If an output through some logical result is blank then the email has nothing to inject. Conversely you can insert sections of text or html conditionally. Without having to have multiple email steps.

[MADMIDGET]

Thanks Damian, have you got any videos using the desktop version, the processes you are using in this video, is not available to me on the desktop version? I can't find any other videos that have exactly what you demonstrate above, but in the desktop version. Any help would be much appreciated!

[FabioSilva-kjbm]

Hi Damian. Thanks for your explanations. I have a question. I did the filter array in my environment. It worked fine. However, when migrating the flow to production in my customer's environment the array does not filter and sends all the values in the email. Do you probably know what could be the reason? I checked and I followed the same steps as in my environment.

Thanks, Fabio

[robertjeffers]

Very helpful, thank you. I have a similar issue. However in my "managers" table I have all the possible managers. My second table only has information for a subset of those managers. The issue I have when I do the above is I end up sending empty emails to any manager who does not have data in table 2. How do I suppress those emails? I know its an inner join, but don't know how to do that on power automate. Thank you

[Benning]

Thank you for your video. How can I achieve this through Sharepoint? I'm trying to send emails to each row (each recipient) and add html table to each email as it pertains to.

[naeeminfo]

Hello Sir, thanks for the guidance, I would like to ask some more guidance, how to filter Excel rows with a client code or unique email address and send them an HTML table with their list of invoices using Power Automate. I have a multiple clients' list in an Excel file, with columns for invoice dates, invoice amount, paid payment, remaining balance, and remarks. In the same Excel sheet, I have additional columns like a customizable subject column, a customer unique ID for each client, and email recipients (To and CC). Could you please guide me on how to filter the Excel rows based on the client code or unique email address and then send them an HTML table with their list of invoices using Power Automate?

[vinimaysingh]

Hi, just 1 query-

One of my columns has date value and another has number. While converting into HTML table, date value is formatted as numbers and number value column does not have thousand separator. How do I fix that? Thanks.

[robertcrazy]

It was verry useful watching this video. I managed to create my own automation flow using the steps explained in your video. I'm having an issue though. The styling of the table it's only applied to the first table and not the second one. What could be wrong? I also added a Compose action and added the html table styling there, before the Send an Email action witch also only applies the styling to the first table. Thank you!

[kareldurovic]

I have 5 excel files that are based on template of part timers attendance. Columns are dates, name, worked hours. I need to combine these every month into one excel or html table and send it to my mamager. The new table should have columns name, total hours and column for each day in that particular month (1, 2, 3, 4, 5 and so on).

How could i combine those excel files into one report using power automate?