How to Limit Responses for Individual Choice Options in Microsoft Forms
Question details
The user wants to limit the number of times a specific choice can be selected in a Microsoft Form, such as capping class registrations at four people per option.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Setting up an event or class registration form where each choice option has a strict maximum capacity.
- Observed behavior
- Microsoft Forms does not have a built-in feature to automatically disable or remove an individual choice once it reaches a specific number of selections.
Before proceeding, check if you have access to Microsoft Power Automate with your Microsoft 365 account, as you will need it to create a custom automated limit enforcement.
Use Power Automate to Track and Update Choices
Since Microsoft Forms lacks a built-in option limit, you can use Power Automate combined with Excel Online to track responses and dynamically manage the form.
This is an advanced workaround. It requires creating a flow that triggers every time a response is submitted, checks the count against an Excel spreadsheet, and alerts you or uses API calls to remove the option when capacity is reached.
Create an Excel Online spreadsheet in SharePoint or OneDrive. Insert a table with two columns: 'Choice Option' and 'Current Count', and fill in your form options.
Go to Power Automate, select 'Create', and choose 'Automated cloud flow'. Set the trigger to 'When a new response is submitted' and select your Microsoft Form.
Add a 'Get response details' action. Then, add an 'Update a row' action for Excel to increment the 'Current Count' for the option the user selected.
Add a 'Condition' step: if the 'Current Count' is equal to your limit (e.g., 4), set up an action to send you an email notification so you can manually remove the choice, or use an HTTP request action to update the form automatically if you are familiar with the Forms API.
Manually Monitor and Remove Options
For smaller forms with low traffic, you can periodically check the response count and manually remove options that have reached their capacity.
Need a simpler office suite? Try WPS Office
While complex form automations can be challenging in Microsoft 365, WPS Office provides a lightweight, highly compatible alternative for your document, spreadsheet, and presentation needs without the steep learning curve.
- 1. Download the Installer: Visit the official WPS website and click 'Download WPS Office Free' to get the latest version for your device.
- 2. Install WPS Office: Run the downloaded setup file and follow the straightforward on-screen instructions to complete the installation.
- 3. Open Your Microsoft Files: Launch WPS Office to easily open, edit, and save your existing Microsoft Office documents and spreadsheets without format loss.
Frequently Asked Questions
Can I limit the total number of responses for the entire Microsoft Form?
Yes. While you cannot natively limit individual choice options, you can limit the entire form from receiving further submissions. Click the three dots (More form settings) in the top right corner, select Settings, and uncheck 'Accept responses'. You can also customize a message to inform users the form is full.
Will Microsoft add a built-in feature to limit choice options in Forms?
Microsoft updates its products based on user feedback. Currently, per-option limits and choice elimination are highly requested on the Microsoft Feedback portal, but no official release date has been announced.
Are there other form builders that support individual choice limits?
Yes. While Microsoft Forms lacks this, other tools offer workarounds or native add-ons. For instance, Google Forms has add-ons like 'Choice Eliminator' that automatically remove options once limits are reached, which may be an easier alternative for basic class registrations.
