Others

How to Send One Daily Power Automate Email from Excel

Olivia Miller Oct 12, 2026 870 views

Question details

The user needs to combine multiple form responses from Excel or SharePoint into a single daily HTML email using Power Automate, rather than receiving a separate email for every single row.

How to Send One Daily Power Automate Email from Excel

Product: Microsoft Excel, Power Automate
Device & OS: not provided
Scenario: Automating daily email reports to summarize new submissions recorded in an Excel spreadsheet or SharePoint list.
Observed behavior: Currently, an email is being triggered for every individual row processed. The goal is to aggregate these rows into one consolidated daily digest email containing an HTML table.

Before you start

Ensure your Excel file is saved in OneDrive or SharePoint Online, and that your data range is formatted as an official Excel Table (Insert > Table) containing a date column to track submission times.

Solution 1Recommended

Create a Scheduled Flow to Aggregate Excel Rows

Build a Power Automate flow that runs daily, filters the Excel table for new records, generates an HTML table, and sends one consolidated email outside of any data loops.

To prevent Power Automate from sending an email for every row, you must collect the data into an array first. You will use a recurrence trigger, fetch the table rows, filter them for the current day, generate an HTML table, and finally send the email action once the loop and data gathering are complete.

Set the Recurrence Trigger

In Power Automate, create a 'Scheduled cloud flow'. Set the recurrence frequency so the flow runs once every day at your preferred time.

List Rows Present in a Table

Add the 'List rows present in a table' action. Select your OneDrive or SharePoint location, document library, Excel file, and the specific Table name containing your data.

Filter the Array

Add a 'Filter array' action. Set the 'From' field to the output (value) of the previous step. Configure the condition to filter rows where your submission date column matches today's date.

Create an HTML Table

Add the 'Create HTML table' action. Use the body output from the 'Filter array' action as the input. This automatically formats your filtered rows into a clean table structure.

Send the Email Outside the Loop

Add the 'Send an email (V2)' action at the very end of your flow. Insert the output from the 'Create HTML table' action into the email body. Ensure this action is not placed inside any 'Apply to each' blocks.

Create a Scheduled Flow to Aggregate Excel Rows

Check Action Placement: If you notice the 'Send an email' action is wrapped in an 'Apply to each' container, drag it outside the container to ensure only one email is sent.

Free Microsoft Office alternative

Manage Your Spreadsheet Data Seamlessly with WPS Office

While Power Automate workflows are deeply integrated with the Microsoft ecosystem, WPS Office provides a robust, lightweight, and highly compatible alternative for organizing, editing, and managing your daily Excel data.

1. Download and Install WPS Office: Visit the official WPS website to download the free suite and follow the installation wizard.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open any existing .xlsx or .csv files without losing formatting.
3. Organize Your Data: Use built-in filters, pivot tables, and formulas to track and manage your daily submissions efficiently.

Seamless compatibility with Microsoft Excel (.xlsx, .xls) formatsLightweight application that runs smoothly on older or low-spec devicesFree built-in PDF editing tools and advanced data analysis featuresFamiliar spreadsheet interface for a zero-learning-curve migration

microsoft office alternative - wps office

Frequently Asked Questions

Why is Power Automate sending an email for every single Excel row?

This happens when the 'Send an email' action is mistakenly placed inside an 'Apply to each' loop. When inside a loop, the flow executes the email action once for every row it processes. Moving the email action below and outside of the loop fixes this issue.

How do I filter Excel data by today's date in Power Automate?

You can use the 'Filter array' action on your Excel data output. Set the condition so that your date column equals the dynamic expression `formatDateTime(utcNow(), 'yyyy-MM-dd')`, ensuring the formats match exactly.

Do I need to format my Excel data as a Table for Power Automate to read it?

Yes, Power Automate requires Excel data to be strictly formatted as an official Table (accessible via Insert > Table in Excel). The 'List rows present in a table' action cannot read raw worksheet ranges.

Can I use a SharePoint list instead of an Excel file for this daily email?

Absolutely. You can replace the 'List rows present in a table' action with the SharePoint 'Get items' action. The rest of the flow (filtering, creating the HTML table, and sending the single email) remains virtually exactly the same.

Office Quick Solutions