How to Send One Outlook Email per Recipient from Excel Rows via Power Automate
Question details
The user needs to group data in an Excel spreadsheet by recipient and send a single consolidated Outlook email to each person containing their matching rows formatted as an HTML table.

- Product
- Microsoft Excel, Power Automate
- Device & OS
- not provided
- Scenario
- Automating bulk email notifications where each recipient receives a consolidated list of items relevant to them, rather than multiple separate emails for every row.
- Observed behavior
- The user wants to establish a workflow that extracts Excel table data, groups it by unique email addresses, formats it as an HTML table, and dispatches it via Outlook.
Ensure your Excel data includes a dedicated column for recipient email addresses, is formatted as an official Excel Table (Ctrl+T), and is saved in a cloud location like OneDrive for Business or SharePoint.
Use Power Automate to Group Data and Send Consolidated Emails
Create an automated cloud workflow to extract your Excel data, isolate unique email addresses, format the grouped data into HTML tables, and send them via Outlook.
Power Automate is highly effective for processing cloud-stored Excel tables. By using data operations like Select, Union, and Filter Array, you can dynamically group rows so recipients only receive one email with all their relevant information.
Create a new Flow in Power Automate. Add the 'List rows present in a table' action, point it to your OneDrive or SharePoint location, and select your target Excel file and Table.
Add a 'Select' action. Set the 'From' field to the dynamic value of your Excel table rows, and map the email column. Next, add a 'Compose' action and use the expression union(body('Select'),body('Select')) to remove duplicate email addresses.
Add an 'Apply to each' loop and use the outputs from your Compose action (the unique emails). Inside the loop, add a 'Filter array' action. Set the 'From' array to the output of your 'List rows present in a table' step, and configure the condition where the 'Email' column is equal to the current item in the loop.
Inside the loop, below the Filter array, add a 'Create HTML table' action using the body of the filtered array. Finally, add the 'Send an email (V2)' action. Place the current loop item in the 'To' field, write your subject line, and insert the output of the 'Create HTML table' into the email body.

Use Excel VBA for Desktop Environments
Utilize a custom VBA macro to loop through your spreadsheet, filter rows by recipient, generate an HTML body, and send emails directly through the Outlook desktop client.
Try WPS Office for Your Spreadsheet and Automation Needs
While Power Automate workflows are specifically integrated into the Microsoft cloud ecosystem, WPS Office provides a free, lightweight, and highly compatible desktop alternative for managing complex spreadsheets, running VBA macros, and executing standard mail merges.
- 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your computer.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xlsm files without losing any data formatting.
- 3. Utilize Macros and Mail Merge: Access the 'Developer' tab to run VBA macros, or use the built-in Mail Merge features for local email automation.

Frequently Asked Questions
Why is my Power Automate flow only fetching 256 rows from Excel?
By default, the 'List rows present in a table' action limits data retrieval to 256 rows to optimize performance. To process larger datasets, click the settings menu for this action, toggle 'Pagination' on, and input a threshold limit that exceeds your row count.
How can I make the HTML table in the Outlook email look more professional?
You can add custom CSS to your table. In your Power Automate flow, switch the 'Send an email (V2)' action to code view (</>). Insert a <style> block defining borders, padding, and headers, and place it directly above the dynamic HTML table output.
Does my Excel file need to be closed for Power Automate to run?
Power Automate can generally read from an open Excel file stored in OneDrive or SharePoint. However, if you or another user is actively modifying the table structure (like renaming columns or the table itself) while the flow executes, the flow may fail.
Why is my 'Filter array' action returning empty results?
This usually happens due to trailing spaces in your Excel data or case-sensitivity mismatches. Ensure your email addresses in Excel do not have accidental spaces, or use functions like trim() or toLower() in your Power Automate expressions to standardize the data before filtering.




