Forum Discussion

AndyfF360's avatar
AndyfF360
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's avatar
Kimberly_Huffman
Brass Contributor
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

Farida Bharmal's avatar
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's avatar
    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's avatar
      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's avatar
        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.

Resources