Send & Receive Issues

How to Send One Outlook Email per Recipient from Excel Rows via Power Automate

Tauseeq MagsiTauseeq Magsi Nov 10, 2026 869 views

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.

How to Send One Outlook Email per Recipient from Excel Rows via Power Automate
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.
Before you start

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.

Solution 1Recommended

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.

1
Retrieve Excel Data

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.

2
Create a Distinct List of Emails

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.

3
Filter Rows for Each Recipient

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.

4
Format as HTML and Send

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 Power Automate to Group Data and Send Consolidated Emails
Pagination Threshold: If your Excel table contains more than 256 rows, click the three dots (...) on the 'List rows present in a table' action, go to Settings, turn on 'Pagination', and set a higher threshold (e.g., 5000).
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your computer.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xlsm files without losing any data formatting.
  3. 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.
Fully compatible with Microsoft Excel formats (.xlsx, .xls) and macro-enabled workbooks (.xlsm).Lightweight application that uses minimal system resources while maintaining high performance.Familiar tabbed user interface, ensuring a seamless transition and zero learning curve.Advanced data filtering, pivoting, and local VBA scripting support included for free.
microsoft office alternative - wps office

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.