Integrate with MS Booking

[mjpautsch]

New app for O365 customers called Booking.

[Dan___]

As an update to my last post, we have now got automation of bookings to work successfully by creating a custom connector as shown here  and using the Graph-API calls to pull data from bookings.

I can now add this into my flow and pull back data from bookings with no issues so far

The API call for this was as follows and this only needs to be setup once and the connector can then be used by anyone you share it with:

GET /bookingBusinesses/{id}/calendarView?start={start-value}&end={end-value}

[meganvwalker]

Nice @Dan___ ! I like this approach with the Graph-API.

I've just finished writing up a post on this with Power Automate and using the Get events action from Microsoft Office 365. 

Action to get the bookings

So ultimately we can create something like this with a nice daily email. 

Format of daily email

[Dan___]

@meganvwalker awesome looking report.

Are you pulling this data by looking at the shared calendar that the bookings get put into?

[meganvwalker]

@Dan___ - yes, that's correct. 

[SmartPower]

Hi, 

How could we create an outlook contact from the customer data we collect in ms bookings? name, email, address etc. 

Or sync other selected bookings data with a crm tool?

Edit: Is it possible with these flow templates 

https://flow.microsoft.com/galleries/public/templates/a9dcb570f27811e6a0e7f98291dcd11a  

and 

https://flow.microsoft.com/galleries/public/templates/2bd714484de84d1391cb288208b9f609

?

Thank you, best wishes!

[meganvwalker]

@SmartPower - the first link you shared goes to a 404 so not sure what that is?

I've started writing some content about Microsoft Bookings using Power Automate, you can see the posts here: https://meganvwalker.com/category/microsoft-bookings/ 

The most recent one shows how you can access the bookings and how you could extract the Contact's Name, Email and Phone number. I have a blog out this week that will show how you could then create a Contact in Dynamics 365 if you wanted to. 

In theory once you get the data from the event booking, you could then use this to create a contact:

https://docs.microsoft.com/en-us/connectors/office365/#create-contact-(v2)

[meganvwalker]

@Dan___ - this is the post where I wrote about accessing the bookings using the Outlook connector in Power Automate, and then creating a daily email of all of the Bookings for that day (in case you were interested in how I did it without Graph-API!):

https://meganvwalker.com/email-daily-summary-of-bookings-using-power-automate/

[Dan___]

@SmartPower: The first link 404s and the 2nd looks like a flow to send an email when a sharepoint list is changed.

Bookings doesn't store info in SharePoint (as far as I am aware) so you will need to access bookings via the API what @meganvwalker shows here & in her blog should work great for your requirements.

If not you can create a custom PowerAutomate connector and pull virtually any data you want from bookings. This blog will show you the basics of this and you can find the Bookings API docs here.

[Dan___]

@meganvwalkeryou beat me to it by a few seconds 😀

Also thanks for the docs link, I will take a look

[SmartPower]

@meganvwalker @Dan___ Thanks for your input!

Just starting with power automate and was looking for a simple way to sync bookings customer with ms365 contact list.

Sorry, the right link is here - a flow template to copy contacts from a sharepoint list to a 365 contact list:

 https://emea.flow.microsoft.com/de-de/galleries/public/templates/690ca78c75a347f28e4cf7f680dc1f42/ko...