Forum Discussion
Power Automate Group Bookings to SharePoint
Hey guys, Has anyone managed to use power automate to pull data from Microsoft Bookings into a SharePoint list, to keep a record of things like attendance? Specifically I'm interested for group book...
Hi James, it’s hard work but you can get the data for a booking as it is updated (via the trigger) and then add it to the SharePoint list one row each time a new booking is updated I.e. a customer is added to the booking.
I have done it by using the last customer in whichever booking has been updated as they are always going to be the last customer in the list.
However, I’m currently struggling with the issue of cancellations as they don’t trigger the flow. There’s not enough guidance out there from Microsoft about managing group bookings via the connectors.
How have you got on since posting this?
I have done it by using the last customer in whichever booking has been updated as they are always going to be the last customer in the list.
However, I’m currently struggling with the issue of cancellations as they don’t trigger the flow. There’s not enough guidance out there from Microsoft about managing group bookings via the connectors.
How have you got on since posting this?
Hey Alex, thanks for this, I hadn't thought about using the last customer so will give that a try. Took me a little while to just get the new bookings working as I've never done anything like this before and we have a big variety of group and 121 services with custom questions etc.
I was going to try getting the days from the SharePoint list and see if I could compare it somehow to find the new entry. But your way seems much simpler.
In terms of structure you can try:
get last customer
create variables for all the top level stuff (ie self service app id, start time and date etc) and add them to an object
use apply to each for the custom answers by adding properties to an object (use a switch to do that)
then you can add the object to the SharePoint list
i used length function to work out if it was an update or a new booking.
hope that helps
not sure what I’m gonna do about cancellations but let me know how you get on.
Hello Alex_K0 I am trying to build a group booking services i.e N:N service and having same issue, to add new bookings/ delete new bookings. But the issue is, how do i fetch the new customer each time it comes up?
Hi JK_248,
Not entirely sure what the question is here. I think you are asking how do I determine the “new customer”. If you look at the way the data is added to the TSV file, you can see that the ‘Last’ customer is the one that triggered the update. I should point out that this method only works with the self-service bookings, for some reason, Microsoft don’t want to make it easy and allow the trigger to work when you add customers via the calendar!
Then if you use the ‘booking id’ and the ‘self-service id’ you can see if the record exists, which means you can get the flow to work on the basis of “is this customer (the last one) in the list already”, if not, add them, if yes, delete them from their original ‘booking id’ and add them to the list with their latest details.
i should point out that I haven’t actually implemented this, I have a production flow ready to go, but as it stands, our data is too important to operations for me to rely on this approach. It works in a test scenario though. We get too many bookings per hour to guarantee that it would be able to cope.
We are using the stupid TSV and running it through a verification (access & excel) system atm.
I’m waiting for Microsoft to develop a more robust API (via Graph) before changing our approach. Have you tried to harness Graph API yet? Worth a look if not.
