Others

How to Hide or Lock a Prefilled Field in Microsoft Forms

Maira Mehtab Sep 28, 2026 869 views

Question details

The user is looking for a way to disable, hide, or lock a prefilled field in Microsoft Forms to prevent respondents from modifying the prefilled answers.

How to Hide or Lock a Prefilled Field in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Sharing a prefilled form link where certain fields are pre-populated but need to remain immutable and unchanged by the respondent.
Observed behavior: Microsoft Forms currently allows any respondent with the link to edit the prefilled fields and modify or reshare the link with altered values.

Before you start

Please note that Microsoft Forms does not currently support making prefilled fields immutable or read-only natively. You will need to rely on post-submission data validation if strict data control is required.

Solution 1Recommended

Validate Form Submissions Using Power Automate

Since you cannot lock fields directly in Microsoft Forms, use Power Automate to validate the data securely after the form is submitted.

Because Microsoft Forms does not offer a built-in security control to lock prefilled values, it is highly recommended not to use prefilled fields for strict security purposes. Instead, you can set up an automated workflow to cross-check the submitted ID or data against your database to ensure authenticity.

Set up a Power Automate flow

Log into Microsoft Power Automate and create an automated cloud flow. Set the trigger to 'When a new response is submitted' in Microsoft Forms.

Get response details

Add a new step and select the 'Get response details' action to retrieve the specific answers submitted by the respondent.

Add a validation condition

Insert a 'Condition' control step to check if the value in the prefilled field matches your expected secure records or database.

Define success and failure actions

If the condition is met (true), proceed with processing the data. If not (false), trigger an email alert to the admin or automatically reject the submission.

Validate Form Submissions Using Power Automate

Security Notice: Never rely solely on prefilled URLs for authentication or sensitive data, as the URL parameters can be easily manipulated by anyone who possesses the link.

Solution 2

Submit a Feature Request to Microsoft

Request the read-only field feature directly from Microsoft so it may be included in future updates.

Free Microsoft Office alternative

Need a Highly Customizable Office Suite? Try WPS Office

While Microsoft Forms lacks certain field-locking capabilities, managing your collected data shouldn't be a hassle. WPS Office provides a lightweight, free alternative to Microsoft Office, ensuring seamless compatibility with Excel spreadsheets and offering robust tools for data validation and sheet protection.

1. Download and Install: Visit the official WPS website and download the free WPS Office suite for your operating system.
2. Export Forms Data: Export your Microsoft Forms responses as an Excel (.xlsx) file from your browser.
3. Protect Data in WPS Spreadsheet: Open the downloaded .xlsx file in WPS Spreadsheet, highlight the columns you want to lock, and use the 'Protect Sheet' feature to prevent unauthorized edits.

Fully compatible with Microsoft Excel (.xlsx) formats for analyzing exported form data.Advanced data validation and cell-locking features to protect sensitive spreadsheet information.Free, lightweight, and fast installation on Windows, Mac, and Linux.Familiar user interface makes it incredibly easy to learn and migrate without a steep learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Does Microsoft Forms Pro allow locking a prefilled field?

No, Forms Pro does not currently provide a feature to make prefilled values immutable. Anyone with the generated link can still modify the prefilled answers and reshare the link.

Can I hide a specific question in Microsoft Forms?

Microsoft Forms does not have a native 'hide' toggle for individual fields. However, you can use branching logic to skip over questions based on previous answers, effectively keeping them out of sight for certain respondents.

Is it safe to use prefilled fields for sensitive security IDs?

No. Because prefilled fields can be edited by the respondent, they should never be used as a strict security control. Always use a post-submission validation method, such as Power Automate, to verify sensitive data.

Will Microsoft add the ability to lock fields in the future?

The feature may be under development. You can check the official Microsoft 365 Roadmap online for updates regarding read-only or locked field functionalities in Microsoft Forms.

Office Quick Solutions