Others

Fix Missing Microsoft Forms Likert Responses in Excel and Power Automate

Maira MehtabMaira Mehtab Nov 18, 2026 868 views

Question details

The user needs to troubleshoot intermittent missing Likert responses in Microsoft Forms exports and Power Automate.

Fix Missing Microsoft Forms Likert Responses in Excel and Power Automate
Product
Microsoft Forms, Excel, Power Automate, and SharePoint
Device & OS
not provided
Scenario
A required Likert table collects employee skill-set responses, which are exported to Excel and sent to a SharePoint list through Power Automate.
Observed behavior
Some Likert answers are missing from Excel and appear as null in Power Automate, while responses to other questions are captured.
Before you start

Identify a response with missing Likert data and note its response ID and submission time. Check both the Excel export and the corresponding Power Automate run so you can compare what each received.

Solution 1Recommended

Compare the Excel export and test a duplicate form

Use controlled test submissions to check whether the issue affects the original form or the downstream flow.

1
Check the Excel export

Open the form in Microsoft Forms, select the Responses tab, and choose Open in Excel. Find the affected response and check the columns for each Likert statement.

2
Inspect the flow run

In Power Automate, open the flow and select its run history. Open an affected run and inspect the Get response details outputs and the SharePoint action inputs for null or missing Likert values.

3
Test another browser

Open the form's response link in another browser, submit a clearly identified test response, and compare its Likert answers in the Excel export and flow run.

4
Test a duplicate form

In Microsoft Forms, use the form's Share options to get a link to duplicate it, then create a copy and submit test responses. Check the copy's Responses tab and Open in Excel export; test a separate flow for the copy if needed.

Compare the Excel export and test a duplicate form
Keep the existing collection link in mind: A duplicate is a separate form and does not replace the original link. Testing it does not require asking all employees to resubmit.
Free Microsoft Office alternative

Review Excel Exports with WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for opening and reviewing Microsoft Office files. It can help you work with exported spreadsheets, although it cannot repair missing Microsoft Forms or Power Automate data.

Review Likert response columns in exported worksheetsCompatible with Microsoft Excel XLSX filesFamiliar spreadsheet interface for an easy transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where can I check whether a Likert answer reached Excel?

In Microsoft Forms, open the form, select Responses, and choose Open in Excel. Find the response and inspect the columns for the Likert statements.

What does a null Likert value in Power Automate mean?

A null value indicates that the action output has no value for that field. Open the affected run in the flow's run history and compare Get response details with the inputs sent to SharePoint.

Will duplicating the form preserve the original response link?

The original form and link remain separate from the duplicate. Use the duplicate for test submissions without directing existing respondents to a new link.

Can separate questions recover missing Likert answers?

No. Separate questions are a workaround for future submissions, not a way to restore answers that were not captured. Update and test the Power Automate mappings after adding them.

When should I contact Microsoft support?

If controlled tests still show missing Likert data, ask a Microsoft 365 administrator to open a support request in the admin center. Include response IDs, submission times, and affected flow-run details.