How to send each person one email with their own Excel rows in Power Automate

Upload the sample workbook to OneDrive. It has a table named Invoices with the columns Invoice, Customer, Amount, Due date, Status, Manager and Manager email. Three rows are Paid, and the flow skips them. The demo uses plus addresses so all emails land in one mailbox, but for real use put each manager's own address in Manager email.

Click Create, then Scheduled cloud flow, and type Weekly open invoices per manager in Flow name. Click Calendar, select 16, November, 2026 (a Monday) and select 08:00 AM in the time box. In Repeat every select Week, then turn off Sunday, Tuesday, Wednesday, Thursday, Friday and Saturday so the preview shows On Monday every week. Click Create.

Click the Recurrence trigger. In Time zone, select your own time zone (I use (UTC-05:00) Eastern Time (US & Canada)). On these days already shows Monday. In At these hours select 8, press Escape, and type 0 in At these minutes so the preview shows Runs at 8:00 on Monday every week.

Click the plus icon below Recurrence, search for List rows present in a table, click the Standard filter and select List rows present in a table. Then set it up:

• Click the action name, type Open invoices and press Tab.
• Set Location to OneDrive for Business and Document Library to OneDrive. Click Open folder, pick your workbook (mine is Video demos > Open invoices.xlsx) and select Invoices in Table.
• Click Advanced parameters, select Filter Query and DateTime Format, and press Escape. Type Status ne 'Paid' in Filter Query and set DateTime Format to ISO 8601.
• On the Settings tab, turn on Pagination and type 5000 in Threshold.

Click the plus icon, search for Select, click Built-in and select Select. Rename it to Manager emails and press Tab. In From, click the lightning icon and select Open invoices > body/value. Click Switch to text mode next to Map, click the Map box, click fx, type item()?['Manager email'] and click Add.

Click the plus icon, search for Compose and select Compose. Rename it to Unique managers and press Tab. Click Inputs, click fx, type union(body('Manager_emails'),body('Manager_emails')) and click Add. Union keeps every value only once, so in the demo eleven addresses become three.

Click the plus icon, search for Apply to each and select Apply to each. Rename it to For each manager and press Tab. Click Select an output from previous steps, click the lightning icon and select Unique managers > Outputs. Everything inside this loop runs once for each manager.

Click the plus icon inside the loop, search for Filter array and select Filter array. Rename it to Their invoices and press Tab. In From, click the lightning icon and select Open invoices > body/value. Click Edit in advanced mode and type @equals(item()?['Manager email'], items('For_each_manager')) in the box.

Click the plus icon, search for Select, click Built-in and select Select. Rename it to Table columns, press Tab, and in From select Their invoices > Body from the lightning icon. For each column, type the key in Enter key, click Enter value, click fx, type the expression and click Add:

• Key Invoice, expression item()?['Invoice']
• Key Customer, expression item()?['Customer']
• Key Amount, expression formatNumber(float(item()?['Amount']),'C2','en-US')
• Key Due date, expression formatDateTime(item()?['Due date'],'dd MMM yyyy')
• Key Status, expression item()?['Status']

Scroll to the end of the loop, click the plus icon, search for Create HTML table, click Built-in and select Create HTML table. Rename it to HTML table, press Tab, select Table columns > Output in From and leave Columns on automatic. Then click the plus icon, search for Compose, select Compose and rename it to Styled table. Click Inputs, click fx, enter replace(replace(replace(body('HTML_table'),'<table>','<table style="border-collapse:collapse;font-family:Segoe UI,Arial,sans-serif;font-size:14px">'),'<th>','<th style="background:#1F4E79;color:#ffffff;text-align:left;padding:8px;border:1px solid #d0d7de">'),'<td>','<td style="padding:8px;border:1px solid #d0d7de">') and click Add.

Click the plus icon, search for Send an email (V2) and select Send an email (V2). Click the Settings gear next to To, select Use dynamic content, then in To click fx, enter items('For_each_manager') and click Add. Type Your open invoices this week in Subject. Build the Body in this order (use fx and Add for each expression):

• Type Hi
• Add the expression first(body('Their_invoices'))?['Manager']
• Type , and press Enter
• Type You have
• Add the expression length(body('Their_invoices'))
• Type open invoices this week: and press Enter
• Click the lightning icon, select Styled table > Outputs and press Enter
• Type Please follow up on the overdue ones first.

Click Save, then Test, select Manually and click Test. Click Continue if the connections screen shows, then Run flow and Done. In the run, click Unique managers to see one address per manager, and check that the loop shows 1 of 3. Open one of the new emails and check the To: line and that the table holds only that manager's unpaid rows.