Forum Discussion
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...
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
I used Power Automate (Flow).
https://www.youtube.com/watch?v=sBqGs-pACK4
1. MS Bookings uses Exchange
2. Get your admin to set the password for the email account the Bookings calendar uses
3. Assign Echcange license so you can trigger Flow on the creation of an Outlook event. In the video, she uses 'Get Bookings' action but that's now 'When an event is added, updated or deleted. v3'
3. Assign Echcange license so you can trigger Flow on the creation of an Outlook event. In the video, she uses 'Get Bookings' action but that's now 'When an event is added, updated or deleted. v3'
4. Trigger on new event added and read the event data and it's all there. Extract the info from the text of the Event body which includes the custom field questions asked.
So stupidly simple !!!!!!! but took me hours of head-scratching and Googling.
My Bookings data now goes into a sharepoint list.
My Bookings data now goes into a sharepoint list.
Edited
Worked like a charm!