Others

How to Limit Microsoft Forms Choices to One Selection Each

Maira Mehtab Sep 28, 2026 869 views

Question details

The user wants to restrict Microsoft Forms so that each option within a multiple-choice question can only be selected once, making the choice unavailable for subsequent respondents.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a form for booking unique time slots, claiming specific inventory items, or any situation requiring mutually exclusive option selection across multiple users.
Observed behavior: Microsoft Forms natively allows limiting one response per person overall, but does not remove, lock, or disable individual choices after another user has selected them.

Before you start

Determine whether you simply need to limit a user to a single form submission or if you strictly need inventory-style choice depletion, as the latter requires external tools outside of native Microsoft Forms.

Solution 1Recommended

Limit to One Response Per Person (Native Forms Setting)

Use this built-in Microsoft Forms setting if your goal is just to prevent a single user from filling out the entire form multiple times.

Open Form Settings

Open your form in Microsoft Forms and click the 'More form settings' (three dots) icon in the top right corner of the screen.

Access Settings Menu

Select 'Settings' from the dropdown menu to open the configuration pane on the right.

Enable the Response Limit

Under the 'Who can fill out this form' section, choose 'Only people in my organization can respond' or 'Specific people in my organization can respond', then check the box for 'One response per person'.

Requirement: This feature requires respondents to belong to your organization and sign in. It cannot be used with anonymous forms where 'Anyone can respond' is selected.

Solution 2

Use Power Apps and SharePoint for Unique Selections

Since Microsoft Forms cannot dynamically hide choices once selected, build a solution using Power Apps and SharePoint to manage inventory or booking slots.

Free Microsoft Office alternative

Choose WPS Office for Seamless Form Data Management

While collecting responses requires specialized tools like Microsoft Forms, analyzing the collected data usually means working with complex spreadsheets. WPS Office is a free, lightweight, and easy-to-use alternative that lets you view, edit, and analyze your exported form results seamlessly.

1. Export Form Data: In Microsoft Forms, go to the Responses tab and click 'Open in Excel' to download your data.
2. Open with WPS Spreadsheet: Open the downloaded .xlsx file directly in WPS Spreadsheet without any formatting loss.
3. Analyze Responses: Use WPS Spreadsheet's built-in data sorting, filtering, and PivotTable tools to easily analyze your collected form responses.

100% compatible with Microsoft Excel (.xlsx) formats for analyzing exported form data.Free, lightweight, and uses minimal system resources compared to heavier alternatives.Familiar user interface with zero learning curve for seamless migration.Built-in advanced tools for data visualization, filtering, and pivot tables to summarize form responses.

microsoft office alternative - wps office

Frequently Asked Questions

Can I limit the number of times a specific option is chosen in Microsoft Forms?

Natively, Microsoft Forms does not support limiting the quantity of times a specific choice can be selected. You will need to use workarounds like Power Automate connected to SharePoint, or specialized tools like Microsoft Bookings or third-party inventory forms.

How do I make Microsoft Forms anonymous while still limiting responses?

You cannot guarantee a strict 'one response per person' limit on anonymous forms because Microsoft Forms relies on organizational login credentials to track who has responded. If you choose 'Anyone can respond', the 'One response per person' option is disabled.

Does Microsoft have a booking tool that prevents double-booking time slots?

Yes, Microsoft Bookings is designed specifically for scheduling. It automatically removes time slots from your public availability page once they are selected and confirmed by a user, preventing double-booking natively.

How can I suggest the choice-limit feature to Microsoft?

You can submit feedback directly to the development team by clicking the 'More form settings' (three dots) in the top right corner of Microsoft Forms, selecting 'Feedback', and explaining your requirement for a choice-depletion or inventory feature.

Office Quick Solutions