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
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 Hey Kimberly... thanks so much for taking the time to share, I'm sure there's lots of others that'll find that really useful. Interestingly enough that looks scarily similar to my Logic App! Great minds and all that. 🙂 (Looks like we're doing exactly the same too, bookings for covid jabs for people like ASC)
I did find the need to do this:
Kimberly_Huffman This is also a nice way to get Name (for example):
You can't do that easily in Designer view, but if you drop in to Code view you can use "\n" to look for the end of line and split by that.... I'm just updating my code to using that way to do it in the hope that if someone changes things around in the Booking form that it doesn't break it in the code here quite so much. (Previously I was splitting by <br>, but now I've gone for the html to text convert as you've done!)
We're also finding limits of the amount of data that the Events connector seems to export... we're trying to export a date range of 7 days, yet the data gets truncated after a couple of days... very frustrating.
Steve_Prentice I know! I feel your pain. It seems that it will only pull about 255 records with the Get Calendar events action. That's why I created multiple scopes with a defined date range that wouldn't exceed 255. Luckily, the array variable was able to hold them all and I didn't have to create multiple arrays.
Steve_Prentice Thanks! That's a great tip and will be going back to modify my code to do the same!!
