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
Kimberly_Huffman is it possible to export the Power App solution and share it? Thank you for your help!!
~Kimberly
- DashBoisMar 08, 2021Copper Contributor
Thanks so much for this.
When choosing the Calendar ID, I do not have the option for the MS Booking calendar, only those attached to my own mailbox. What can I do to troubleshoot this?
Thanks
- Kimberly_HuffmanMar 08, 2021Brass ContributorDashBois - we created 4 exchange accounts, each representing a staff being used in MS Bookings. I added the accounts to my Outlook account which then made them show up in the Calendar ID drop down. I have since removed those accounts from my Outlook and the flows are still working.
- CScott1861Mar 26, 2021Copper ContributorBrilliant solution! was scratching my head trying to figure out a way to extract this data
- Steve_PrenticeMar 08, 2021Iron Contributor
Hey DashBois... Further up in the thread there's a post from topcat437 which outlines some pre-reqs, to paraphrase...
2. Get an admin to set the password for the Bookings calendar's email account
3. Assign Exchange licenseNot sure that's in Kimberly's doc... It could be that you need to do that bit if you haven't already?
Cheers