Transform Excel Data into HTML Table and Email: Power Automate

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:
   • Add a Table to an Excel File - Save E...  

HTML Table Styling https://www.w3schools.com/html/html_t... Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕