Forum Discussion
James_Furmage
Feb 11, 2024Copper Contributor
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...
James_Furmage
Mar 04, 2024Copper Contributor
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.
Alex_K0
Mar 04, 2024Brass Contributor
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.
- JK_248Dec 18, 2024Copper Contributor
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?
- Alex_K0Dec 19, 2024Brass Contributor
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.