Others

How to Disable a Microsoft Forms Question After 100 Responses

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to automatically stop accepting responses for a specific question in a Microsoft Forms survey once the total number of participants for that question reaches 100.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Managing a survey where a particular option or question has a strict capacity limit, such as exactly 100 family members.
Observed behavior: Microsoft Forms does not have a built-in feature to automatically disable or hide a single question based on the cumulative total of submitted responses.

Before you start

Ensure you are logged into your Microsoft 365 account with owner access to the form, as you will need permission to edit the survey structure or create Power Automate flows.

Solution 1Recommended

Manually Monitor and Remove the Question

Since Microsoft Forms cannot automatically disable individual questions based on quotas, you must track the response count manually and edit the form once the limit is reached.

This is the most direct workaround for the platform's limitations. Be cautious when deleting a question, as it will also remove the collected data for that specific field. Instead of deleting, it is often better to change the question text to indicate it is closed or use form branching to hide it.

Check current responses

Log into Microsoft Forms, open your survey, and click on the 'Responses' tab to view the current total count of submissions.

Edit the form structure

Once the count reaches 100, click back to the 'Questions' tab to modify your survey.

Update or hide the question

Select the specific question. Instead of deleting it (which erases past data), edit the question title to state '(Closed)' and remove the 'Required' toggle, or use branching logic to bypass this question for new respondents.

Data Loss Warning: Do not delete the question if you need to retain the first 100 responses. Deleting a question in Microsoft Forms permanently deletes the response data associated with it.

Solution 2

Use Power Automate for Limit Notifications

Set up a Power Automate flow to instantly notify you when your form reaches exactly 100 responses, allowing you to quickly go in and manually update the question.

Free Microsoft Office alternative

Enhance Your Productivity with WPS Office

While navigating limitations in online form builders, you can optimize your broader document workflow with WPS Office. It provides a free, lightweight, and highly compatible alternative to Microsoft Office, allowing you to easily create, edit, and share Word, Excel, and PowerPoint files without an expensive subscription.

1. Download the software: Visit the official WPS website and click 'Download WPS Office Free' to get the installer.
2. Install and launch: Run the downloaded file and follow the quick installation prompts, then launch the application.
3. Open your files: Drag and drop your existing Microsoft Office files into the WPS workspace to begin editing immediately.

Seamlessly open, edit, and save Microsoft Office formats including .docx, .xlsx, and .pptx.Enjoy a free, lightweight suite featuring Writer, Spreadsheet, Presentation, and PDF tools.Familiar user interface requiring zero learning curve for traditional Office users.Built-in customizable templates to quickly create professional documents and track survey data.

microsoft office alternative - wps office

Frequently Asked Questions

Can I set a response limit for an entire Microsoft Form?

Yes, while you cannot limit a single question, you can limit the entire form. If you use Power Automate, you can create a flow that changes the form's status to 'Closed' once a specific number of global responses is reached.

Does Microsoft Forms support conditional logic to hide questions?

Microsoft Forms supports 'Branching', which allows you to hide or show subsequent questions based on a user's previous answers. However, it cannot hide questions based on the total number of overall form submissions.

Can I restore a question if I accidentally delete it?

No. If you delete a question in Microsoft Forms, both the question and all previously collected response data for that specific field are permanently removed and cannot be restored.

Office Quick Solutions