Bookings Overbooking and Double-Book Alert

Overview

This flow proactively prevents scheduling errors in Microsoft Bookings. On a short schedule it scans upcoming appointments for staff double-bookings, back-to-back appointments without a buffer, and days that exceed a staff member's capacity, then alerts the manager and the team in Microsoft Teams and by Outlook email so conflicts are resolved before the appointment day arrives.

Why it matters: Double-bookings and over-capacity days damage customer experience and stress staff. Catching them on a 30-minute cadence lets the team fix the schedule proactively rather than discovering the clash at the door.

Status: Built. Solution: FlowLibs - Bookings Overbooking and Double-Book Alert. Flow ships Off (demo).

Architecture note - connector-first with a documented Graph fallback: The Microsoft Bookings connector (shared_microsoftbookings) is trigger-only plus an admin list call. Its live swagger exposes only webhook triggers (CreateAppointment / UpdateAppointment / CancelAppointment), ListBookingsBusinessUserAsAdmin, and DeleteWebhook. There is no GetAppointments and no ListStaff action, so a scheduled "read all upcoming appointments and compare them" pattern cannot be done with the connector alone. The flow still uses the Bookings connector (ListBookingsBusinessUserAsAdmin, which validates the connection) and uses Microsoft Graph via the built-in HTTP action only for the reads the connector lacks (calendarView for appointments, staffMembers for staff). Teams and Outlook use their standard connectors. Graph credentials are bound to flowlibs_ environment variables - never inlined.

Use Case

A services team (clinics, salons, advisory desks, field services) runs everything through Microsoft Bookings. They want an early-warning system that surfaces scheduling conflicts - overlaps for the same staff member, gaps smaller than the required turnaround buffer, and any staff member booked beyond their daily limit - and routes those to the people who can fix them.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Microsoft Bookings	shared_microsoftbookings	ListBookingsBusinessUserAsAdmin
Microsoft Teams	shared_teams	PostMessageToConversation
Office 365 Outlook	shared_office365	SendEmailV2

Note — All connections are referenced as solution connection references; the flow is portable between environments as long as a connection is mapped at import time.

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Auto-resolve

Propose alternate reschedule slots for each conflict (query staff free/busy and include suggestions in the alert).

Per-service buffer rules

Replace the single BufferMinutes with a per-service map, keyed by serviceId.

PTO awareness

Cross-check appointments against staff Outlook out-of-office to flag bookings on time-off.

Per-calendar-day capacity

The capacity check counts today's appointments; extend it to evaluate every day in the lookahead window.

Event-driven variant

Swap the Recurrence trigger for the Bookings CreateAppointment/UpdateAppointment webhook trigger to check at booking time.

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

@greater(length(intersection(coalesce(A?['staffMemberIds'],createArray()), coalesce(B?['staffMemberIds'],createArray()))), 0)

@less(ticks(B.startDateTime.dateTime), ticks(addMinutes(A.endDateTime.dateTime, varBufferMinutes)))

@and(contains(coalesce(item()?['staffMemberIds'],createArray()), staff?['id']), equals(formatDateTime(item()?['startDateTime']?['dateTime'],'yyyy-MM-dd'), formatDateTime(utcNow(),'yyyy-MM-dd')))

@greater(length(body('Filter_Today_For_Staff')), int(coalesce(json(variables('varCapacityMap'))?[staffId], '999')))

concat(GraphBaseUrl,'/v1.0/solutions/bookingBusinesses/',businessSmtp,'/calendarView?start=',utcNow(),'&end=',addDays(utcNow(),lookaheadDays))

Customize & download