How to Fix Missing Excel Form Responses in Power Automate
Question details
The user needs to diagnose why Microsoft Forms responses stored in an Excel table on OneDrive are intermittently missing from a Power Automate flow.

- Product
- Microsoft Excel, Microsoft Forms, and Power Automate
- Device & OS
- not provided
- Scenario
- A user has a Microsoft Form linked to an Excel table in OneDrive and a Power Automate flow that reads the table, but some submitted responses do not appear in the flow run.
- Observed behavior
- Some form responses exist in the Forms response list or Excel table but are not processed by Power Automate; the missing records are intermittent.
Confirm that you can access the Microsoft Forms response list, the connected Excel workbook in OneDrive, and the Power Automate run history for the affected flow. Note the response IDs of missing submissions so you can trace where each record is lost.
Check Where the Response Is Lost in Forms, Excel, and Power Automate Run History
Use this first when missing responses are intermittent and you need to isolate the exact failure point.
The fastest way to narrow down the issue is to compare the same response ID across Microsoft Forms, the Excel table, and Power Automate run history. This shows whether the record never reached Excel or reached Excel but was not read by the flow.
In Microsoft Forms, open the form, select the Responses tab, and click Open results in Excel to open the connected workbook.
In the Excel table, search for the missing response ID, respondent email, or submission time to confirm whether the row exists.
In Power Automate, go to My flows, open the affected flow, and expand the run history around the missing submission time.
Use the unique response ID to determine whether the response failed before Excel or between Excel and the Power Automate flow.

Fix Power Automate Flow Issues When Excel Already Has the Response
Use this when the missing response exists in Excel but the flow does not process it.
Add Unique Response ID Checks and Reconciliation in Power Automate
Use this to prevent future missed records after you have fixed the immediate cause.
Use WPS Office as a Free, Lightweight Alternative for Excel Spreadsheet Work
The missing-response issue belongs to Microsoft Power Automate and Excel Online cloud flows. For local Excel spreadsheet review, cleanup, and analysis, WPS Office is a free and lightweight alternative with familiar ribbon tools, full .xlsx compatibility, and seamless migration from Microsoft Excel.
- 1. Download WPS Office: Download WPS Office from the official WPS website and install it on your device.
- 2. Open the Excel workbook: Open WPS Spreadsheets, then open the .xlsx workbook exported from Microsoft Forms or downloaded from OneDrive.
- 3. Review and clean the response table: Use the familiar ribbon tools in WPS Spreadsheets to inspect, filter, clean, or share the response table without cloud automation dependencies.

Frequently Asked Questions
Why does Power Automate miss some Microsoft Forms responses even when they are in Excel?
This is usually caused by pagination limits, filter conditions, concurrency settings, or the flow relying on row position instead of a unique response ID. Check the List rows action settings and Power Automate run history to identify the cause.
How can I tell if a missing response never reached Excel?
Open the form responses in Excel and search for the missing response ID or submission details. If the row is absent from Excel, check the Microsoft Forms-to-Excel synchronization and whether the workbook is locked or being edited.
Does WPS Office work with Microsoft Forms and Power Automate?
WPS Office can open and edit the Excel workbook locally with .xlsx compatibility, but Power Automate cloud flows and Microsoft Forms synchronization are Microsoft-specific services and are not controlled by WPS Office.
Should I use row number to track responses in Power Automate?
No, row numbers can change when a table is sorted, filtered, or edited. Use the unique Microsoft Forms response ID and add reconciliation checks to avoid skipped or duplicate records.
Can I open the Excel response table in WPS Spreadsheets for cleanup?
Yes, download the .xlsx file from OneDrive and open it in WPS Spreadsheets. WPS supports Excel tables, formulas, and formatting for local review and cleanup.




