Transform Excel Data into HTML Table and Email: Power Automate #PowerAutomate #Outlook

Are you tired of manually summarizing excel data and sending it to multiple managers? In this video, I'll show you how to take an excel table as input, get distinct values such as manager names and clients and send HTML table(s) as a summary to each of the distinct managers. Not only that, but you'll also learn how to split the data into individual clients and send different tables to the same manager. This powerful technique can also be applied to a Microsoft List.

This is a great solution for those who want to automate the process of summarizing and sending data to multiple managers. Whether you're working with excel tables or Microsoft Lists, this video has got you covered. Don't miss out on this opportunity to learn how to take an excel table as input and send HTML table(s) as a summary to each of the distinct managers using Power Automate. Make sure to hit the like and subscribe button!

00:00 Intro
01:12 Start of Demo
01:56 Distinct Values using Select and Union
03:06 Create HTML Tables via Apply to Each
06:50 Creating an Object and therefore Array of HTML Tables
11:55 More examples on Distinct Values
12:50 FIltering on the unique tables based on Distinct Managers
15:37 Joining the Tables
18:03 Send an Email
19:06 Demo of solution and the resulting Table(s)
20:03 Extending the solution to include unique email addresses
22:49 Outtro

Add table to incoming Excel File attachment using Office Scripts:

[iandobbs]

What a star! I’ve been struggling all day to find a way to automate emailing a filtered table of results from Excel/Power Query (where sensitive data is in the query but not in the table)! Delighted to have found your channel Damien - thank you so much! Can’t wait to try this out tomorrow. 👍

[jamesarthur]

This is what I've been looking for. You are the best.
Thank you so much

[evandrodossantosYou]

This video is a Hand Book Chapter for me. Thanks

[pbiqueryous]

Thanks Damien, eternally grateful for this knowledge. You are truly helping us solve real-world challenges which are troubling us to this day! You have definitely prevented us from project collapse! :)

[ivanbork]

Thanks Damian
That was a great inspiration, and a great help
Like the option to follow your instruction step by step, and then add my local changes to fit our needs in the end

[malove]

Your video means a lot for me ❤

The only thing I need to know is how to include the client's name in the email subject, especially if the email contains multiple client names.

[gabrielesabbatino]

Brilliant as usual! Thx so much for your work!

[WilsonC]

Good instructional video. I received an empty output when I applied each filter array. I am not sure what is going on; it just did not work out.
It took me ten hours to solve the issue. Finally Ahha...I discovered that I forgot to switch text mode at the "Select>map" so that the system is able to pick up the string! That is the key.

No doubt I must thank you to your tutorial video and improve me as well from mistake.

[mariolopez-odpr]

Thanks Damien!, Another great video!, your explanation is so clear and very detailed. This is what I'd call a complex flow, but you make it so simple. Thanks for sharing your knowledge and expertise.

[pfcoop]

Great video! I'm going to try this on an Excel Order form.

[badriruslan]

just the one i need right now. thanks for the video.

[ThakralShubham]

Thanks Hopefully this will work in my case

[Zeidinho]

Thanks for the video. Unless I misheard, I think you may have confused the semi colon (;) and colon (:). Example at 7:33

[aatsw]

Top notched contents. Thank you! Subscribed.

[cryptomugen]

This was a fantastic tutorial. Love how you explained each step. Clear and concise. Question, I see that you grabbed the first entry for each manager which grabs the first tax amount for the corresponding client. Would be great if you could expand on this and show us steps on how we can get a sum total of tax amounts for each client.

[weierschatten]

This is the best thing I've seen done with PA yet! Trying to get it to work with SPO, got a mistake somewhere because the tables aren't showing up in the email and sometimes it wants the "field_x" instead of a headers name, maybe something to do with SPO.

[niiivee]

Exactly what I was looking for... Thanks for the video Damien. One question though, is it possible to do the same using excel files with more than 30000 rows?

[oliwiabajdak]

Thanks for this great video! Do you possibly know why I dont see 'value' option in list rows present in a table? Only body and body/value

[phoenixkissme]

Thank you for your video. I have one question. Can the subject be dynamic as well?

[shyambhadresa]

Really helpful video! Would you have a demo where instead of converting to HTML tables per manager, you create a csv/excel file for each set of data which is attached to the email?
Thanks.