Forum Discussion
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 when they actually booked one for.
Ive tried to connect to the exchange account using powerquery but only get the appointment date data an not the original log date.
Any suggestions?
1 Reply
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
