Forum Discussion
Extracting custom fields from bookings
- Jan 17, 2021
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
One way to go about it is to add this calendar to your outlook calendar and then use print> daily or weekly (whichever you prefer >detailed agenda (tick this option).
This shall give you all the information. Hope that helps.
- maynarpJul 27, 2020Copper Contributor
Thanks sagark92, this partially works but the feature is lacking built-in export of the configured custom fields. Getting a detailed page for each meeting/booking with the complete details is simply doesn't scale. You would need some OCR to transpose that to an Excel spreadsheet.
I have raised this issue in the User Vote community for this to become available and it has been pending moderator approval for multiple days.
https://techcommunity.microsoft.com/t5/microsoft-bookings/microsoft-bookings-reports/m-p/197177/
They are sitting on this since they released the TSV export years ago.
https://outlook.uservoice.com/forums/314907-microsoft-bookings/suggestions/15773461-custom-fields-on-the-booking-page
Have you seen other ways to get access to these custom fields?