Data Import & Export

How to Fix Missing Excel Form Responses in Power Automate

Khadija KhanKhadija Khan Nov 13, 2026 868 views

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.

How to Fix Missing Excel Form Responses in Power Automate
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the form response results in Excel

In Microsoft Forms, open the form, select the Responses tab, and click Open results in Excel to open the connected workbook.

2
Find the missing response ID in Excel

In the Excel table, search for the missing response ID, respondent email, or submission time to confirm whether the row exists.

3
Review the Power Automate run history

In Power Automate, go to My flows, open the affected flow, and expand the run history around the missing submission time.

4
Compare the same record across all three locations

Use the unique response ID to determine whether the response failed before Excel or between Excel and the Power Automate flow.

Check Where the Response Is Lost in Forms, Excel, and Power Automate Run History
Use a unique response ID: Do not rely on row position, because rows can shift when the Excel table is sorted, filtered, or edited.
Free Microsoft Office alternative

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. 1. Download WPS Office: Download WPS Office from the official WPS website and install it on your device.
  2. 2. Open the Excel workbook: Open WPS Spreadsheets, then open the .xlsx workbook exported from Microsoft Forms or downloaded from OneDrive.
  3. 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.
Opens and edits .xlsx Excel workbooks with full Microsoft Office format compatibility.Free and lightweight spreadsheet tools for reviewing and cleaning exported form response data.Familiar ribbon interface makes it easy to move between Microsoft Excel and WPS Spreadsheets.No dependency on Power Automate cloud flows for local spreadsheet analysis and troubleshooting.Seamless migration of existing Excel files without losing formulas, tables, or formatting.
microsoft office alternative - wps office

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.