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?
I managed to do this with 2 flows one with trigger for new bookings and one trigger for when booking is updated
I’m trying to achieve when booking is create or updated add row to a table
however doing it this way when the update trigger runs it automatically adds an apply each and re adds all the users
Alex_K0 could you tell me how you did your variable it may resolve my issue
- Hi @JEdmunds,
Sorry I only just checked this and noticed your comment. Which variable? Did you manage to get it sorted?
Happy to share.
