Others

Can Microsoft Forms Remove an Option After It Is Selected?

Olivia Miller Oct 10, 2026 869 views

Question details

The user is looking for a way to make a specific choice in Microsoft Forms disappear or become unavailable once a respondent selects it.

Can Microsoft Forms Remove an Option After Selection?

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a sign-up sheet, volunteer assignment, or time-slot booking where each multiple-choice option should only be available once.
Observed behavior: Microsoft Forms currently allows multiple respondents to select the same option without automatically hiding it after the first selection.

Before you start

Because Microsoft Forms does not natively support choice elimination, ensure you have access to Microsoft Power Apps and SharePoint if you plan to build a custom workaround.

Solution 1Recommended

Use Microsoft Power Apps for Unique Selections

Since Microsoft Forms lacks a native choice elimination feature, Power Apps is the recommended Microsoft platform to build forms with vanishing or limited-capacity options.

Microsoft Forms is designed for basic surveys and quizzes. For advanced booking systems where an option must disappear once claimed, you need a database-backed solution.

Power Apps combined with SharePoint lists allows you to create custom forms and hide items that have already been selected by previous users.

Set up a SharePoint List

Create a new SharePoint list containing all your available time slots or volunteer assignments, including a column named 'Status'.

Create a Power App

Generate an app from your SharePoint list by selecting Integrate, choosing Power Apps, and clicking Create an app.

Filter Available Options

Modify the app's gallery or dropdown formula (using the Filter function) to only display items where the 'Status' column is set to 'Available'.

Update Status on Submission

Use the Patch function to change the item's status to 'Booked' when a user submits their choice, effectively removing it from the available list.

Use Microsoft Power Apps for Unique Selections

Community Support: Building apps in Power Apps can be complex. We recommend consulting the Microsoft Power Apps Community forums for specific formula and workflow guidance.

Solution 2

Submit Feature Feedback to Microsoft

Request this feature directly from Microsoft so it might be considered for future updates to Microsoft Forms.

Free Microsoft Office alternative

Try WPS Office for Your Daily Productivity Needs

If you find Microsoft's ecosystem too complex or expensive for straightforward tasks, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for document creation without the steep learning curve.

1. Download the Installer: Visit the official WPS website and click the download button for your operating system.
2. Install WPS Office: Run the setup file and follow the on-screen instructions to complete the installation.
3. Open Your Files: Launch WPS Office and seamlessly open your existing Microsoft Word, Excel, or PowerPoint files without losing any formatting.

Completely free and lightweight Office suite alternative.Fully compatible with Microsoft Office formats including .docx, .xlsx, and .pptx.Familiar tabbed user interface for a seamless migration.Built-in PDF editing tools for versatile document management.

microsoft office alternative - wps office

Frequently Asked Questions

Can I limit the number of times an option can be chosen in MS Forms?

No, Microsoft Forms does not currently have a built-in capacity limit or a way to restrict how many times a specific multiple-choice option can be selected by different respondents.

Are there any free add-ins for Microsoft Forms to hide selected options?

Unlike some other form builders that support choice-eliminating add-ons, Microsoft Forms does not support third-party add-ins for individual forms. You must use Power Apps or Power Automate to achieve this.

How do I create a sign-up sheet where slots disappear once taken?

The most reliable method within the Microsoft 365 ecosystem is to use Microsoft Lists or SharePoint Lists integrated with a custom Power App, allowing you to filter out choices that have already been marked as claimed.

Office Quick Solutions