Send Unique Emails with HTML Table using Data from Excel
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.
This video is a demo of how to solve the following question on the forum https://powerusers.microsoft.com/t5/B....
Sample Styling for HTML Table https://www.w3schools.com/Css/tryit.a...
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
Also check out • Transform Excel Data into HTML Table ...
#PowerAutomate #FlowNaut #Tables #Excel #Email Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕
