How to Limit Microsoft Forms Responses by Capacity
Question details
The user wants to accept only a fixed number of responses (such as the first 50 event registrations) in Microsoft Forms.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Setting up an event registration, survey, or sign-up sheet that has a strict capacity limit.
- Observed behavior
- Microsoft Forms does not have a built-in, out-of-the-box setting to automatically limit the number of form submissions.
Ensure you have access to Microsoft Power Automate and a SharePoint site to create the tracking flow, as native capacity settings are not available in Microsoft Forms.
Use Power Automate to Automatically Cap Responses
Set up a flow in Power Automate to track submission counts in a SharePoint list and send automated replies based on your capacity limits.
Since Microsoft Forms lacks a native response cap feature, you can use Microsoft Power Automate to create a custom workflow. By routing form submissions into a SharePoint list, the flow can evaluate the response ID. If the ID is under your limit, it sends an acceptance email; if over, it sends a rejection email stating the event is full.
Set up a new SharePoint list to store the incoming registration data. Ensure the columns match the questions in your Microsoft Form.
Log into Power Automate, click 'Create', and select 'Automated cloud flow'. Choose the trigger 'When a new response is submitted' for Microsoft Forms.
Add an action to get the response details, then add a 'Condition' control. Set the condition to check if the unique response ID is less than or equal to your desired limit (e.g., 50).
In the 'If yes' branch, add a 'Send an email' action to confirm the registration. In the 'If no' branch, add another email action explaining that registration is closed.
Manually Disable Form Submissions
If you prefer not to use Power Automate, you can monitor the response count manually and close the form when it reaches capacity.
Manage Registration Data Easily with WPS Office
While Microsoft Forms requires complex Power Automate workflows for advanced limits, processing your exported registration data doesn't have to be complicated. WPS Office provides a free, lightweight suite with powerful spreadsheet capabilities to track capacities, manage lists, and handle office tasks effortlessly.
- 1. Download WPS Office: Install the free WPS Office suite on your PC or mobile device.
- 2. Open Exported Data: Export your Microsoft Forms responses to an Excel file and open the .xlsx file directly in WPS Spreadsheet.
- 3. Manage Capacity Lists: Use built-in sorting, filtering, and counting tools to quickly organize your first 50 registrants and manage waitlists.
Frequently Asked Questions
Does Microsoft Forms have a built-in setting to limit responses?
No, Microsoft Forms does not currently offer a native out-of-the-box setting to automatically close a form after a specific number of submissions. You must use Power Automate to manage limits or close the form manually.
How do I close a Microsoft Form manually?
Go to your form, click on the three dots (More form settings) in the top right corner, select Settings, and uncheck the 'Accept responses' option. You can then add a custom message for anyone who tries to open the link after it is closed.
Can I send an automatic 'registration full' email in Forms?
Yes, but only by setting up a workflow in Microsoft Power Automate that triggers an email when the unique response ID exceeds your predefined capacity limit.
Where can I find the response ID in Microsoft Forms?
The response ID is automatically generated sequentially for each submission. You can view it by going to the Responses tab and exporting your form data to an Excel file, where the ID appears in the first column.
