Forum Discussion
Mquallet
Jul 24, 2025Copper Contributor
MS Bookings - Date When person Booked Appt
I need to be able to see when a person used the bookings page to book an appointment as well as the actual booked time so i can see the lag time between when a person requested an appointment and whe...
Jul 28, 2025
You're hitting one of the biggest limitations of Microsoft Bookings: it doesn't natively expose the "booking creation date/time" (i.e., when the user actually submitted the booking request). By default, when you connect via Power Query (Exchange, Graph, or Excel export), you only get the scheduled appointment time, not the booking submission timestamp.
Use Power Automate on incoming emails as a tracker.
Here’s what you need:
- Shared mailbox (used by Bookings)
- Flow that captures:
- Email subject
- Booking time (from body)
- Submission time (from email metadata)
Store all that in SharePoint or Dataverse, and then analyze the lag time in Power BI or Excel.
------------------------------------
Don't forget to mark as solution if my answer suits you