Others

How to Limit Microsoft Bookings to a Fixed Number of Customer Appointments

WPS Editor Sep 28, 2026 870 views

Question details

The user wants to restrict the total number of appointments a specific customer can book across different staff members, such as limiting a client to exactly 10 sessions.

How to Limit Customer Appointments in Microsoft Bookings

Product: Microsoft Bookings
Device & OS: not provided
Scenario: Managing customer reservations and preventing a single user from overbooking beyond an allowed quota.
Observed behavior: Microsoft Bookings currently lacks a built-in feature or setting to cap the maximum number of appointments per individual customer.

Before you start

Because Microsoft Bookings does not have a native feature to cap appointments per customer, you will need access to Microsoft Forms and Power Automate to create a custom tracking workflow.

Solution 1Recommended

Use Power Automate and Microsoft Forms to Track and Limit Bookings

Create a custom workflow that intercepts booking requests, counts the customer's previous appointments, and prevents scheduling if they exceed the limit.

Since you cannot set a hard cap within the Bookings interface, you can use Microsoft Forms as the customer-facing booking portal. Power Automate can then verify the customer's eligibility before confirming the appointment.

Create a Booking Request Form

Go to Microsoft Forms and create a form to capture your customer's scheduling details, ensuring you make the email address a required field.

Set up a Tracking List

Open SharePoint or Excel Online and create a list or spreadsheet to log each form submission and keep a running count of requests associated with each email address.

Configure the Power Automate Flow

In Power Automate, create a new automated cloud flow that triggers 'When a new response is submitted' in your Microsoft Form.

Add a Condition for the Appointment Limit

Add a step to 'Get items' from your SharePoint list to count previous entries by the customer. Then, insert a 'Condition' block: if the count is greater than or equal to your limit (e.g., 10), proceed to the 'Yes' branch.

Finalize Approval or Rejection

In the 'Yes' branch (limit exceeded), add an action to send an email notifying the customer they have reached their maximum sessions. In the 'No' branch, add the action 'Create a booking' to officially schedule the appointment in Microsoft Bookings.

Use Power Automate and Microsoft Forms to Track and Limit Bookings

Requires Power Automate Licensing: This workaround requires a Microsoft 365 subscription that includes Power Automate and the ability to use standard connectors for SharePoint, Forms, and Bookings.

Solution 2

Submit a Feature Request to Microsoft

Help prioritize the development of a native appointment limitation feature by submitting feedback directly to the Microsoft product team.

Free Microsoft Office alternative

Track Your Appointments and Data with WPS Office

While Microsoft Bookings requires complex Power Automate workflows to limit appointments, tracking your customer scheduling data doesn't have to be difficult. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office for organizing your customer databases and tracking quotas manually or via spreadsheet formulas.

1. Download and Install: Get WPS Office from the official website and install it on your PC or mobile device.
2. Open WPS Spreadsheet: Launch the application and open a new Spreadsheet to act as your customer appointment tracker.
3. Track Customer Data: Use built-in functions like COUNTIF to easily monitor how many times a specific customer email appears in your manual scheduling log.

Completely free, fast, and lightweight office suiteSeamless format compatibility with Microsoft Excel (.xlsx), Word, and PowerPointEasy-to-use spreadsheet interface for tracking customer appointment countsBuilt-in templates for scheduling, CRM, and data management

Frequently Asked Questions

Can I limit how far in advance customers can book in Microsoft Bookings?

Yes, you can control the booking window. Go to the Booking Page settings, and under the Scheduling policy section, set the 'Maximum lead time' to specify how many days in advance appointments can be made.

Is it possible to restrict bookings to specific email domains?

Microsoft Bookings does not natively restrict bookings by email domain. To achieve this, you would need to use a custom Microsoft Forms and Power Automate workflow that checks the domain before generating the booking.

Can I limit the number of attendees for a specific service in Bookings?

Yes. If you are offering a group service (like a class or webinar), you can go to the Services tab, select the specific service, and set the 'Maximum number of attendees' per session.

Does Microsoft plan to add a feature to cap appointments per customer?

This is a frequently requested feature on the Microsoft Feedback portal, but Microsoft has not yet announced an official roadmap or release date for implementing a native per-customer limit in Bookings.

Office Quick Solutions