Others

Fix Power Automate Email Omitting Newly Added Excel Rows

Rana Garcia Sep 25, 2026 870 views

Question details

The user needs to resolve an issue where a Power Automate flow fails to include the most recently added Excel row in an automated email.

How to Fix Power Automate Email Omitting Newly Added Excel Rows

Product: Microsoft Excel, Power Automate
Device & OS: not provided
Scenario: Automating form responses into an Excel table and generating a summary email during the same flow run.
Observed behavior: The automated email omits the newest Excel row, and the new data only appears when the flow runs the next time.

Before you start

Check your Power Automate flow run history to ensure that the 'Add a row into a table' action is completing successfully before the email action triggers.

Solution 1Recommended

Add a Delay Action Before Sending the Email

Adding a brief pause allows the Excel file enough time to process and save the newly added row before the flow fetches the data for the email.

Cloud-based Excel tables occasionally experience a slight latency when saving new records. If Power Automate immediately retrieves data after adding a row, it may fetch the cached, previous state of the table.

Edit your Flow

Open your flow in the Power Automate editor and locate the space between your 'Add a row into a table' action and your email action.

Insert a New Step

Click the '+' icon to add a new action, search for 'Delay', and select the 'Delay' schedule action.

Configure the Delay

Set the 'Count' to 15 and the 'Unit' to 'Seconds'. This provides ample time for the Excel table to update.

Test the Flow

Save your changes and trigger the flow again to confirm that the newest row is now included in the email.

Add a Delay Action Before Sending the Email

Timing Optimization: A 15-second delay is usually sufficient. If the issue persists, you can safely increase this to 30 seconds.

Solution 2

Verify Action Sequencing and Data Retrieval

Ensure you are actively fetching the updated table data after the new row is added, rather than relying on stale variables.

Solution 3

Consult the Microsoft Power Platform Community

For complex flow structures or persistent synchronization bugs, the dedicated Microsoft Power Automate community can provide expert diagnostics.

Free Microsoft Office alternative

Experience Lightweight and Fast Spreadsheets with WPS Office

While Power Automate requires the Microsoft ecosystem, for everyday spreadsheet editing, analysis, and data management, WPS Office provides a powerful, fast, and free alternative. It seamlessly handles Microsoft Excel files without the heavy subscription costs.

1. Download the Installer: Visit the official WPS Office website and click 'Download WPS Office Free'.
2. Install the Software: Run the downloaded installer and follow the quick on-screen instructions.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and open any existing Excel files to start working immediately.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight installation that runs smoothly on older devicesFamiliar ribbon interface requiring zero learning curveBuilt-in advanced data analysis and charting tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Power Automate flow fetch old data from Excel?

This happens due to caching or processing delays in cloud storage (like OneDrive or SharePoint). Excel Online takes a few moments to commit a new row. If your flow requests the data before this save is complete, it retrieves the previous version of the table.

Can I trigger an email directly using the form response data instead?

Yes. Instead of fetching the data back from Excel, you can use the dynamic content directly from your 'Get response details' action (e.g., Microsoft Forms) to populate the email body. This completely bypasses the Excel sync delay.

Does WPS Office integrate with Microsoft Power Automate?

Power Automate is a proprietary Microsoft 365 service designed primarily for Microsoft products. WPS Office is a standalone, powerful alternative for local and cloud document editing and does not natively trigger Microsoft Power Automate flows.

Office Quick Solutions