Power Automate – Create separate Excel files per manager and email automatically

I’m looking for some help with Power Automate + Excel.

Scenario:

• I have a master Excel workbook with \~1,800 rows (one per colleague). • Each row includes a Manager Email column. • Multiple colleagues can share the same manager email (e.g., 6–15 direct reports per manager). • There are many unique managers in the file. 

What I want to achieve:

1. Identify each unique Manager Email in the master sheet. 2. For each unique manager: • Create a new Excel workbook. • Copy only the rows where that manager’s email appears. 3. Automatically email that workbook to the relevant manager. 

So in simple terms:

If the master file had:

• 100 rows • 10 unique managers • 10 colleagues per manager 

I’d want:

• 10 separate Excel files • Each file containing only the 10 rows for that specific manager • Each file automatically emailed to that manager 

I’m about 90% of the way there conceptually, but I’m unsure about the best approach in Power Automate to:

• Get the distinct list of manager emails • Filter rows per manager • Generate separate workbooks dynamically • Attach and send them 

Has anyone built something similar or can suggest the cleanest way to structure this flow?

Thanks in advance!