Forum Discussion

Brass Contributor

May 07, 2020

Solved

Extracting custom fields from bookings

Hi trying to setup a booking system for customers attending a site. Due to social distancing, we have to limit the number of spaces available and we have successfully manged to set this up using boo...

Bookings

custom fields

Extract

Kimberly_Huffman
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
Bookings event details to CSV file using Power Automate.docx431 KB

Farida Bharmal

Copper Contributor

Feb 09, 2021

Kimberly_Huffman is it possible to export the Power App solution and share it? Thank you for your help!!

Kimberly_Huffman

Brass Contributor

Feb 09, 2021

Hi! Unfortunately I cannot; however, the document I attached earlier in this thread has all of my steps. If there are any particular steps, actions, etc. you have questions about, I'll be more than happy to answer.
~Kimberly

DashBois
Copper Contributor
Mar 08, 2021
Kimberly_Huffman
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_Huffman
  Brass Contributor
  Mar 08, 2021
  DashBois - 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.
  - CScott1861
    Copper Contributor
    Mar 26, 2021
    Brilliant solution! was scratching my head trying to figure out a way to extract this data
- Steve_Prentice
  Iron Contributor
  Mar 08, 2021
  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 license
  
  Not sure that's in Kimberly's doc... It could be that you need to do that bit if you haven't already?
  
  Cheers