Others

How to Limit Sign-Up Choices to One Respondent in Microsoft Forms

Camila Milosovich Oct 10, 2026 869 views

Question details

The user wants to know how to restrict an appointment time slot choice in Microsoft Forms so that it becomes unavailable after a single person selects it.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating an internal sign-up sheet for events, such as headshot appointments, where each time slot can only accommodate one person.
Observed behavior: Microsoft Forms does not automatically remove, disable, or limit an answer choice after a respondent has selected it, leading to double-booked time slots.

Before you start

Keep in mind that Microsoft Forms is primarily designed for surveys and open data collection. Because it lacks built-in inventory or capacity management features, you will need to rely on workarounds or alternative scheduling applications.

Solution 1Recommended

Use Microsoft Bookings for Dedicated Scheduling

Since Microsoft Forms cannot enforce a one-person limit natively, using a dedicated appointment management application like Microsoft Bookings is the most reliable approach.

Microsoft Bookings is included in many Microsoft 365 plans and is specifically designed to handle time slots, staff availability, and capacity limits. It automatically removes time slots from the public view once they are booked.

Open Microsoft Bookings

Create a New Booking Page

Click on 'Create a new booking page' and enter your event details, such as 'Internal Headshots'.

Set Up a Service

Navigate to the 'Services' tab in the left-hand menu and click 'Add new service' for the appointment type.

Limit Attendee Capacity

In the service details, set the 'Maximum attendees per event' to 1. This ensures only one person can book each available time slot.

Save and Share

Save the service settings, publish your Booking page, and share the provided link with your internal team.

Use Microsoft Bookings for Dedicated Scheduling

Automated Confirmations: Unlike Microsoft Forms, Microsoft Bookings will also automatically send calendar invitations and reminders to the respondents once they secure their slot.

Solution 2

Implement a Power Automate Workaround

If you must use Microsoft Forms, you can use a complex Power Automate flow to dynamically update the form and remove the option after it is chosen.

Free Microsoft Office alternative

Manage Your Sign-Up Data Seamlessly with WPS Office

Whether you use Microsoft Forms or a scheduling app, you'll eventually need to export and manage your respondent data. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, allowing you to easily organize, filter, and analyze your sign-up sheets in WPS Spreadsheet.

1. Download and Install: Download WPS Office for free from the official website and complete the quick installation process.
2. Export Your Data: Export your sign-up sheet or survey data from your scheduling app as a CSV or Excel file.
3. Organize in WPS Spreadsheet: Open the downloaded file directly in WPS Spreadsheet to view, sort, and organize your respondent slots.

Fully compatible with Microsoft Excel formats (.xlsx and .csv) for seamless data export.Free and lightweight alternative to heavy Microsoft Office installations.Familiar user interface ensures a zero-learning-curve transition.Built-in templates help you quickly format your exported scheduling data.

microsoft office alternative - wps office

Frequently Asked Questions

Can I limit the total number of responses a Microsoft Form can receive?

No, Microsoft Forms does not have a built-in feature to cap the maximum number of total submissions. However, you can manually uncheck the 'Accept responses' box in the form settings to stop accepting entries, or use Power Automate to close it automatically after a certain threshold is reached.

Does Google Forms have an option to eliminate choices once selected?

Like Microsoft Forms, Google Forms does not natively support eliminating choices. However, you can install third-party add-ons such as 'Choice Eliminator' from the Google Workspace Marketplace to achieve this functionality.

Is there any way to warn users if a slot is already taken in Microsoft Forms?

Without using Power Automate to dynamically remove the choice, there is no way to display real-time availability or warnings within a standard Microsoft Form. Users will only know a slot is double-booked if you manually review the data and inform them afterward.

Office Quick Solutions