Forum Discussion
Extracting custom fields from bookings
AndyfF360 I was able to extract custom field data successfully using Power Automate so in case you have future needs. Karine2411 , sagark92 , maynarp , topcat437 , Steve_Prentice in case you are interested.
Flow Description
This flow runs nightly and extracts user data from events located in a custom account calendar (this account is being used by the Bookings app to schedule appointments) then creates a CSV file stored in a Shared Documents team library. Attached are the details of my solution.
Hope this helps!
~Kimberly
3. Assign Echcange license so you can trigger Flow on the creation of an Outlook event. In the video, she uses 'Get Bookings' action but that's now 'When an event is added, updated or deleted. v3'
My Bookings data now goes into a sharepoint list.
topcat437 Thanks... I like your idea and doing it right now.
A couple of follow up questions if I may?
For us, changing the password and licencing seems to have made the booking calendar "disappear" from the admin portal, you can still get to it by a direct link, but no longer search for it, did you find that?
The data gets returned in "body" and is just a load of HTML, which is horrendous to search for the data and make it easily usable, did you find anything nice to help with that, or just pure hard work with substring() to save it in to variables?
- Worked like a charm!
