Stop Sending Emails One-by-One — Send Personalized Emails from Excel (Power Automate)

🚀 Send Personalized Reports Automatically (Power Automate by Manager)

In this video, I walk through how to use Power Automate to take a large dataset and automatically send personalized emails to each manager—so they only see the information relevant to them.

No more sending one giant report.
No more manual copy-paste.

Just clean, targeted communication at scale.

🧠 What This Solves

Most reporting processes fall into one of two traps:
• One massive report sent to everyone
• Or manual effort to split data and send individual emails

This solution fixes both by:

→ Grouping data by manager
→ Sending each person a customized report automatically

⚙️ How the Flow Works

1. Source Data (Master Dataset)
• Start with a list of associate-level data
• Each record includes a manager reference

2. Generate Unique Manager List
• Extract a distinct list of managers
• Creates the foundation for targeted communication

3. Apply to Each – Manager Loop
• Loop through each manager
• Treat each one as a separate communication group

4. Filter Relevant Records
• Pull only the associates tied to that manager
• Reduces the dataset to what actually matters

5. Shape the Data (Select)
• Clean up the structure of the output
• Keep only the fields needed for reporting

6. Create HTML Table
• Convert the filtered data into a readable table
• Prepares it for email delivery

7. Send Personalized Email
• Each manager receives their own report
• Only their team, nothing extra

✉️ Final Output

Instead of:
• One bloated report
• Managers searching for their data
• Manual email creation

You get:

✔ One email per manager
✔ Clean, relevant data
✔ A scalable reporting process

🔑 Key Concepts Covered
• Creating unique lists from a dataset
• Filtering data dynamically by recipient
• Using Select to reshape outputs
• Converting data into HTML tables
• Designing automation for targeted communication

💡 By the End of This Video, You’ll Know How To:

✔ Break a master dataset into personalized reports
✔ Automate manager-level communication
✔ Build scalable email reporting workflows
✔ Eliminate repetitive manual distribution tasks

🎯 Real-World Use Cases
• HR team rosters and updates
• Operations supervisor reporting
• IT access reviews by manager
• Finance ownership-based reporting
• Any scenario where one dataset → many recipients

🚀 Why This Matters

This pattern shifts your communication from:

→ “Here’s everything—go find your part”

to

→ “Here’s exactly what you’re responsible for”

That’s where clarity and accountability start to improve.

🔥 Big Takeaway

This isn’t just about sending emails.

It’s about building a scalable communication system that delivers the right data to the right person—automatically.

📌 Resources & Links

🔗 Promotion Nomination Full Build: https://www.youtube.com/watch?v=zx-Qrtjv7I4⸻

💬 Let’s Connect

If this helped you, drop a comment and let me know how you’d use this in your reporting process.

And if you’re building in Power Automate or Power Apps—subscribe.
That’s exactly what this channel is about.
00:00 - Start
00:53 - Look at our Raw Data
02:09 - Starting our Power Automate
03:30 - Get Unique Manager List
05:19 - Customize Direct Report List
06:47 - Get Manager Items
07:00 - HTML List
11:25 - Test is Out
11:58 - HTML Clean Up
12:20 - Final Output

Видео Stop Sending Emails One-by-One — Send Personalized Emails from Excel (Power Automate) канала Chris Freeman