Get bookings from power automate

[Sumaira]

Hello Community Experts,

How do i get the booking details from Microsoft bookings? I don't find any trigger for that.

How do i achieve this requirement?

Kindly guide

Thanks in advance!

[Expiscornovus]

Hi @Sumaira,

As far as I am aware there is no connector for this product yet. I do see a UserVoice idea for this:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Triggers-for-Bookings/idi-p/594425

You could interact with Booking via the Graph API though: https://docs.microsoft.com/en-us/graph/api/resources/booking-api-overview?view=graph-rest-beta

[Sumaira]

@Expiscornovus thanks for the response

Can you please advise me on how to use graph api with power automate?

Best regards!

[Sumaira]

@Expiscornovus I want to have a trigger of when a booking is created

How do i do that

Its an urgent high priority requirement

Please guide @Expiscornovus 

Best regards!

[Expiscornovus · Accepted solution]

Hi @Sumaira,

I just saw Microsoft Booking is connected to a specific account with a calendar. So it would be possible by using the when a new event is created (V3) trigger. 

1. Go to the booking page an check which account is used for the booking calendar

2. Add a new event is created (V3) trigger action and make sure you are use the account from step 1

[Sumaira]

@Expiscornovus Many thanks for the response

how do i get below details please advise

specific booking’s

1. date and time

2. Microsoft Teams join URL

3. Microsoft Teams dial-in conference

Thanks!

[tslupphaug]

This looks like a great workaround, at least for triggering an action when a new booking is made. But, will it be possible to extract the individual data fields from Bookings using this method? E.g. say you have fields like name, phone number, email and perhaps a few custom questions in your booking form; how could you extract these from the calendar event and use them in your flow? 

[Expiscornovus]

Hi @tslupphaug & @Sumaira,

I believe that information is stored in the body of the event. Normally the body content looks a bit like this.

********************************************************
NOTE: This is a read-only view of the booking.
Please use Microsoft Bookings for web, iOS or Android to edit this booking.
Any changes made here will be lost.
********************************************************

Customer Info
--------------------
Name: Contoso Sports
Email: contososports@yourdomain.onmicrosoft.com
Phone Number: 0123456789

Booking Info
--------------------
Service name: Initial consult
Location: Our office address

Internal Notes
-----------------------
This is where you can add notes about this service that only you and your staff
see.

A possible solution could be to use some split functions to extract that data. 

Below is an example of how to use that approach to extract the customer name from the body. You have to repeat that same approach for the other fields though.

1. Add an HTML to text action. Use the body dynamic value from the event trigger action

2. Add an compose action. Use the following expression to extract the customer name from the body with two split functions.

split(split(outputs('Html_to_text')?['body'], 'Name: ')?[1], 'Email: ')?[0]

[tslupphaug]

Thanks a lot @Expiscornovus! I managed to get this working with Name and Email, but, when I try to extract custom fields I get an error message.

Calendar event body (the part I'm failing to extract text from):

Egendefinerte felter
----------------------
Spørsmål 1 – Bedrift
 Svar – Testbedriften AS
Spørsmål 2 – 

The text I'm trying to extract here is "Testbedriften AS". Expression:

split(split(outputs('Html_to_text')?['body'], 'Bedrift Svar – ')?[1], 'Spørsmål 2')?[0]

Error message received when running the flow:

[Expiscornovus]

Hi @tslupphaug,

It looks like it can't find 'Bedrift Svar - '. I think this is because part of that text is on a new line.

Can you try and use this expression instead:

split(split(outputs('Compose_3'), 'Svar – ')?[1], 'Spørsmål 2')?[0]

[tslupphaug]

@Expiscornovus: My problem here is that the "Custom fields" consists of multiple questions and answers, where all answers are being preceeded with just "Answer - " ("Svar" in Norwegian). If I don't include the preceding line, I won't be able to identify the right line to choose.

So if you have e.g. 3 custom fields, it will show up something like this:

Custom fields
----------------------
Question 1 – Company
 Answer – Company A
Question 2 – Nationality
 Answer – Norwegian
Question 3 – Your date of birth
 Answer – 01.02.1987

Internal Notes
-----------------------

 (sorry for not being clear about this in my previous post)

[Expiscornovus]

Hi @tslupphaug,

Thanks for explaining that. My Norwegian is not that good 😉

In that case you can split on the 'Question 1 - Company' part, that should be unique enough. And if you want to remove the answer part you can use a third split function or maybe a replace function instead of that could also be an option.

split(split(split(outputs('Compose_3'), 'Spørsmål 1 – Bedrift')?[1], 'Svar – ')?[1], 'Spørsmål 2 – ')?[0]

[tslupphaug]

@Expiscornovus Thanks again for all your help, couldn't have done it without you! I got it all to work now, with a few minor tweaks.

An advice for anyone attempting the same as me: if you're running into problems, start with simpler splits to begin with. Then work your way step by step. And be aware that " - " is not the same as " – ".

[Sumaira]

@Expiscornovus Thanks a lot for the help

I'm struggling with below scenario now with respect to booking, when booking is created in ms booking, i want multiple customers Name, phone number and email ID to send sms and emails to them at once

I checked using same approach ,but it is not giving me customers details there

Can you please suggest me how do i get multiple customers details to send sms to them?

Please guide,

Thanks in Advance

[tjmatheson]

Hi @Sumaira , I've been looking at Power Automate, to resolve this issue. I found, that I was able to see sent email's to multiple customers. Its not a direct reference, but you see in the exchange, by using message trace, a sent email, with the service name, and time of email sent. It does not tell you customer name, phone number and email Id. So armed with this information I tried setting up a power automate, looking at the sent mailbox of the booking page. However, despite sending the mail, the mailbox, does not have an email in the sent mailbox, when first setting up a booking. If you cancel the booking, the mailbox will have a sent, "cancelled" booking email. However, you cannot see a confirmed booking, or a new event. When you add a staff member, you do see a sent email, however, it carries the note 

NOTE: This is a Multi customer booking. Log into Bookings to see customer information and notes for this event.

Booking Info
--------------------
Service name: xxxxxx

At this point,  I'm not sure where to take it. 

[tslupphaug]

I'm having the same issue as @Sumaira. As long as it's only one customer, it can be automated using the details contained within the calendar event. But with multiple customers appointments, there doesn't seem to be any way to retrieve the customers' info.

Does anyone know if a proper connector between MS Boookings and Power Automate is planned or in the works? Or if this can be solved in any other way? I really hope someone from Bookings or PA sees this thread. For my specific purposes, I could solve the problem if only I was allowed to create appointments and time intervals shorter than 5 mins.

@Expiscornovus Since you've been so helpful; you don't happen to know if there's any way to achieve automation with multiple customer bookings as well (where the details aren't available in the calendar event or emails)?

[alderchew]

@Expiscornovus , I've set up power automate, but when i try to create the booking through the booking page, the flow get timeout eventually, but if I manually add the new event through the calendar, it has complete successfully. Are you able to help?

Thanks 

[pwintert]

@Expiscornovus  I can see how this would work and began traveling down that road parsing through the body to pull the relevant information required to solve my problems when I ran into a new one.  Bookings with Multiple Attendees.  Each individual booking information is not transferred into the calendar booking, specifically the body. Instead its a generic message that says " This is a Multi customer booking. Log into Bookings to see customer
information and notes for this event." .   Any ideas how to get the name/email of that attendee?   

[pwintert]

@tslupphaug Did you ever solve your issue with multiple bookings? Having the same issue and I can parse through and do what i need to for individuals but really need it to work for all scenarios. 

[tslupphaug]

@pwintert: Nope. Ran into the same problem, and could not find a solution for it. Since the details for multiple attendees bookings are hidden inside Bookings, I don't think this is possible currently. 

I think our best bet would be to wait for an official connection to Bookings in Power Automate, possibly arriving sometime in 2050...