Others

How to Edit and Automate Microsoft Forms Responses

Ayan Masood Sep 25, 2026 870 views

Question details

The user wants to know how to automate Microsoft Forms responses to external files, edit submitted form data, and add administrator-only questions that are hidden from the form recipients.

How to Edit and Automate Microsoft Forms Responses

Product: Microsoft Forms
Device & OS: not provided
Scenario: Automating data extraction from form submissions and managing response editing or hidden admin fields.
Observed behavior: Microsoft Forms lacks native features to directly edit submitted responses or hide questions from recipients, requiring the use of external tools like Power Automate or Power Apps.

Before you start

Ensure you have access to Microsoft Power Automate with your Microsoft 365 account, as this is required to connect your Forms data to external applications like Excel or SharePoint.

Solution 1Recommended

Automate Forms Responses Using Microsoft Power Automate

Use Power Automate to automatically send submitted Microsoft Forms responses to an external file such as Excel, SharePoint, or Dataverse.

While Microsoft Forms cannot perform complex automation natively, integrating it with Microsoft Power Automate allows you to capture submissions in real time and store them in your preferred database or spreadsheet format.

Open Power Automate

Log into your Microsoft 365 account and open the Microsoft Power Automate application.

Create a New Automated Flow

Click on 'Create' in the left-hand menu and select 'Automated cloud flow' from the available options.

Set the Trigger

Name your flow and choose the trigger 'When a new response is submitted' under Microsoft Forms, then click 'Create'.

Select Your Form

In the flow editor, select your specific form from the 'Form Id' dropdown menu.

Add an Action to Export Data

Click 'New step' and choose an action such as 'Add a row into a table' (for Excel Online) or 'Create item' (for SharePoint) to map the form fields to your external file.

Advanced Workflows: For highly specific automated tasks or complex data routing, consider posting your workflow requirements in the Microsoft Power Platform Community to get tailored assistance from experts.

Solution 2

Workarounds for Editing Responses and Hiding Admin Questions

Use Microsoft Power Apps or export data to an external spreadsheet to bypass the limitations of editing responses and creating hidden fields in Microsoft Forms.

Free Microsoft Office alternative

Easily Manage Exported Form Data with WPS Office

While Microsoft Forms and Power Automate handle data collection, analyzing and editing the exported spreadsheet data is easier with WPS Office. As a free, lightweight alternative to Microsoft Office, WPS Spreadsheet offers full compatibility with Excel files, allowing you to organize, edit, and manage your form responses effortlessly.

1. Export Your Data: Export your Microsoft Forms responses to a Microsoft Excel (.xlsx) file using the 'Open in Excel' feature or a Power Automate flow.
2. Open WPS Office: Launch WPS Office on your device and click on the 'Spreadsheet' module.
3. Edit Form Responses: Open the downloaded Excel file in WPS Spreadsheet to view, analyze, and freely edit your collected form data.

Fully compatible with Microsoft Excel (.xlsx) formats exported from Microsoft FormsLightweight application that opens large datasets and spreadsheets quicklyFamiliar user interface requires no learning curve for Office usersFree to use for everyday data management, editing, and analysis

microsoft office alternative - wps office

Frequently Asked Questions

Can recipients edit their Microsoft Forms responses after submission?

Yes, if the form creator enables it. The creator must go to Settings and check 'Allow respondents to edit their responses.' However, the form administrator cannot edit the submitted responses directly within the Forms interface.

How do I import existing data into Microsoft Forms?

Microsoft Forms is primarily a data collection tool and does not support importing external data to populate form results. You can only gather new data through active form submissions.

Is it possible to hide specific questions in Microsoft Forms?

No, Microsoft Forms does not currently have a feature to hide specific questions from respondents or make them 'administrator-only'. For advanced form logic and hidden fields, you will need to build a custom solution using Microsoft Power Apps.

How do I link my Microsoft Form to an Excel spreadsheet?

Open your form in Microsoft Forms, navigate to the 'Responses' tab, and click 'Open in Excel'. For a continuous, real-time sync, you can set up a Microsoft Power Automate flow to add new responses directly into an Excel Online table.

Office Quick Solutions