How to Limit Microsoft Forms to a Maximum Number of Responses
Question details
The user wants to automatically close a Microsoft Form after receiving a specific number of submissions, such as 25 responses.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Collecting limited data or registrations through online forms.
- Observed behavior
- Microsoft Forms lacks a native feature to set a hard numerical limit on the number of accepted responses.
Since Microsoft Forms does not offer a built-in response limit feature, you will need to monitor your form manually or use scheduled time limits as a workaround.
Manually Close Microsoft Forms to New Responses
Monitor your response count and manually disable the form once your target number is reached.
Open your Microsoft Form and navigate to the 'Responses' tab to check the current submission count.
Click the three-dot menu (...) in the upper-right corner and select 'Settings'.
Under 'Options for responses', uncheck the box for 'Accept responses'.
Type a message in the 'Message to recipients' box to inform users that the form has reached its capacity and is no longer accepting submissions.
Set a Start and End Date for Submissions
Use a time limit to restrict responses instead of a numerical limit.
Submit a Feature Request to Microsoft
Since this is a known limitation, you can submit feedback directly to Microsoft to request the feature.
Create Documents and Forms with WPS Office
While Microsoft Forms lacks built-in response limits, you might find that exploring alternative office suites gives you more flexibility. WPS Office is a lightweight, fully-featured suite that provides excellent compatibility with Microsoft Word, Excel, and PowerPoint formats. It includes tools for data collection, document creation, and PDF editing, all in one easy-to-use platform.
Frequently Asked Questions
Can I use Power Automate to limit Microsoft Forms responses?
Yes, advanced users can create a flow in Power Automate that triggers when a response is submitted, counts the total rows in an associated Excel spreadsheet, and automatically turns off the 'Accept responses' setting in the form when the exact numerical limit is reached.
Will respondents lose their data if the form is closed while they are typing?
If you manually uncheck 'Accept responses' while someone is actively filling out the form, they will receive an error message upon clicking 'Submit', and their partially filled responses will not be saved.
Is there any native Microsoft app that supports a strict submission quota?
Currently, no native Microsoft 365 app offers a simple numeric cap out-of-the-box. Users typically rely on Power Automate workflows or switch to dedicated third-party survey tools when a strict response quota is required.
