Скачать с ютуб Transform Excel Data into HTML Table and Email: Power Automate в хорошем качестве

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 ☕