Others

How to Create Appointment Time Slots in Microsoft Forms

Camila Milosovich Sep 28, 2026 869 views

Question details

The user wants to set up appointment scheduling with specific time slots in Microsoft Forms, ensuring that each slot can be selected by respondents.

How to Create Appointment Time Slots in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a booking or appointment form where respondents can select their preferred available time periods.
Observed behavior: Microsoft Forms allows creating choice questions for time preferences but lacks a native appointment-slot feature to automatically prevent multiple users from selecting the same time slot once it is booked.

Before you start

Determine whether you need strict one-person-per-slot enforcement. If preventing double-booking is critical, you will need access to Microsoft Power Automate or a dedicated scheduling tool like Microsoft Bookings.

Solution 1

Create Basic Time Slots Using a Choice Question

Set up a standard Microsoft Form where respondents select their preferred time slot from a manually created list of options.

This is the simplest way to collect appointment preferences. However, keep in mind that this method does not automatically hide or disable a time slot once someone chooses it.

Create a new form

Go to Microsoft Forms online and click 'New Form' to start building your appointment questionnaire.

Add a Choice question

Click the '+ Add new' button and select 'Choice'. Enter a prompt such as 'Select your preferred appointment time'.

Input time slots

In the option fields, manually type out the available time periods, such as '9:00 AM – 10:00 AM' and '10:00 AM – 11:00 AM'.

Limitation: Because this is a standard survey question, multiple respondents can still select the same time slot.

Solution 2Recommended

Automate Exclusive Time Slots with Power Automate

Use a Power Automate workflow to dynamically remove time slots from your form once they have been booked, preventing double-booking.

Solution 3

Use Microsoft Bookings for Native Scheduling

Switch to Microsoft Bookings, a dedicated app in the Microsoft 365 suite, to easily manage appointments without complex workarounds.

Free Microsoft Office alternative

Manage Schedules and Data with WPS Office

If navigating complex Microsoft Forms and Power Automate workflows seems overwhelming, try WPS Office. It is a fully featured, lightweight office suite that handles all your document, spreadsheet, and scheduling needs seamlessly.

1. Download WPS Office: Visit the official WPS website to download and install the free office suite on your device.
2. Explore Templates: Open the application and navigate to the Templates section on the homepage.
3. Find Schedule Trackers: Search for 'Schedule' or 'Appointment' to find ready-to-use spreadsheet templates that make tracking bookings incredibly easy.

Completely free to download and use for essential office tasks.High compatibility with Microsoft Office formats, including Word, Excel, and PowerPoint.Access to hundreds of free scheduling, calendar, and appointment tracking templates.Lightweight design that runs smoothly on almost any device without lagging.

microsoft office alternative - wps office

Frequently Asked Questions

Can I set a limit on how many times a choice can be selected in Microsoft Forms?

Natively, Microsoft Forms does not have a feature to limit the number of times a specific choice (like a time slot) can be selected. You must use a workaround like Power Automate to dynamically remove selected options.

Is Microsoft Bookings better than Forms for appointments?

Yes, Microsoft Bookings is specifically designed for scheduling. It automatically handles time slot availability, prevents double-booking, and integrates seamlessly with Outlook calendars, making it much better suited for appointments than Microsoft Forms.

How do I export my Microsoft Forms appointment data to Excel?

Open your form in Microsoft Forms, go to the 'Responses' tab at the top of the page, and click the 'Open in Excel' button. This will download a spreadsheet containing all respondent data and their selected time slots.

Office Quick Solutions