How to get custom fields answers form MS Bookings through Power Automate

Question

How to get custom fields answers form MS Bookings through Power Automate

Anonymous

Hello!

I have two MS Bookings services with different custom fields. I want to get this data when the user responds when scheduling an appointment through Power Automate. When I created the flow, I checked the information and I could not see the user responses, but the documentation says that we can use the following data:

When I select for example Answer, it shows me nothing but a blank space.

If I review the data that Power Automate extracts when an appointment is created trigger I can't find the customer answers.

"headers": {"Connection": "Keep-Alive","Expect": "100-continue","Host": "prod-123.westus.logic.azure.com","X-BEServer": "DM6PR15MB3548","X-BEBuildNumber": "15.20.5791.27","webhook-id": "1a6416a1-a2cb-45e7-9263-e3038c2bbd25","Content-Length": "3439","Content-Type": "application/json; charset=utf-8"},"body": {"AdditionalInfo": "<html>\r\n<head>\r\n<meta name="Generator" content="Microsoft Exchange Server">\r\n\r\n<style></style>\r\n</head>\r\n<body>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div><font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span style="font-size:12pt;background-color:white;">Thank you for your interest and your time.</span></font><font face="Segoe UI,Segoe UI Web (West European),Segoe UI,-apple-system,BlinkMacSystemFont,Roboto,Helvetica Neue,sans-serif" size="2" color="#424242"><span style="font-size:14px;"><br>\r\n\r\n</span></font><font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span style="font-size:12pt;background-color:white;">You can earn $100 just by filling out this form </span></font><a href="https://obform.formstack.com/forms/hemacenter_donor_intake_copy" target="_blank">https://obform.formstack.com/forms/hemacenter_donor_intake_copy</a> <font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span style="font-size:12pt;background-color:white;"> and\r\ncoming in for a pre-screen appointment!</span></font><font face="Segoe UI,Segoe UI Web (West European),Segoe UI,-apple-system,BlinkMacSystemFont,Roboto,Helvetica Neue,sans-serif" size="2" color="#424242"><span style="font-size:14px;"><br>\r\n\r\n</span></font></div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</body>\r\n</html>\r\n","CustomerEmail": "email","CustomerId": "53c49f2c-5a5d-4b21-9784-3f4b04ed27c6","CustomerLocation": {"PhysicalAddress": {"City": "","CountryOrRegion": "","PostalCode": "","State": "","Street": ""}},"CustomerName": "test test","CustomerPhone": "12232424234","CustomerTimeZone": "","Customers": [{"Id": "53c49f2c-5a5d-4b21-9784-3f4b04ed27c6"}],"Duration": 1800,"EndTime": "11/14/2022 3:00:00 PM","FilledAttendeesCount": 1,"Id": "FmEoi0bTKyZMtdrfdvlvvvEAAAAABklGAAAAAK64pT03uI1Im1Tdps1IeswHAGEoi0bTKyZMtdrfdvlvvvEAAAAAAQ0AAGEoi0bTKyZMtdrfdvlvvvEAAAAABVIAAE4=","JoinWebURL": "","MaxAttendeesCount": 1,"SelfServiceAppointmentId": "283d696a-e656-4aff-b21d-90ca6fa260cc","ServiceId": "6ce4282e-1fbb-4ec2-8f8d-f01b455098ea","ServiceName": "Prescreening Appointment","StaffMembers": [{"DisplayName": "Prescreening Bed No. 2","EmailAddress": "******@test.com"}],"StartTime": "11/14/2022 2:30:00 PM","TrackingData": ""}} Can I access these custom fields to create this data in a SharePoint list?

Thank you

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Answer 1

Someone in Microsoft Community Hub helps me. Actually, you cannot access to customer array data (including custom answers) with 1:1 services. The only way to get the customers array is to make the booking service type 1:n customers.

You then need to iterate through the array to extract only the responses from the client in an array. I did it this way, if you find another way to do it please let me know.

Hello,

My apologies for resurrecting an older thread, but this is as close to a solution to my issue (same as the topic, unable to access Bookings custom field data) as I can find online. Could someone please expound on what is listed above? Does the Bookings end need to be configured somehow, or was it entirely a different way of using Power Automate to grab the data? Any insight would be greatly appreciated.

Answer 2

Hi Luisa,

How are you?

Hope you are doing well.

I am writing to follow up on this thread.

Regarding your concern, seems like you are getting some response from our relevant expert dedicated support channel resources, I am very glad that above dedicated support has provided some information from their side.

If my follow up is reliable for your thread, could you please provide vote / feedback so that other community member can see this information?

I will really appreciate your kind cooperation.

Stay safe and healthy.

Have a good day.

Sincerely,
Darpan

Answer 3

Hi,

Any update on this item or resolution? I have had the same issue trying to pull the answered custom fields into Sharepoint.

Hi, yes.

Someone in Microsoft Community Hub helps me. Actually, you cannot access to customer array data (including custom answers) with 1:1 services. The only way to get the customers array is to make the booking service type 1:n customers.

You then need to iterate through the array to extract only the responses from the client in an array. I did it this way, if you find another way to do it please let me know.

Answer 4

Anonymous

Hi,

Any update on this item or resolution? I have had the same issue trying to pull the answered custom fields into Sharepoint.

0 comments

Answer 5

Dear Luisa,

Good day!

Thank you for posting to Microsoft Community. We are glad to assist.

Based on your description, I understand that you have a query on how to get custom fields answers form MS Bookings through Power Automate.

Firstly, I would like to invite community members and MVPs in the forum to share their knowledge or any workaround and insight on this topic. We do apologize that we couldn't provide a good suggestion for you on debugging this flow. We sincerely recommend you raise this query in Microsoft Power Automate Community - Power Platform Community, which is the official forum for Power Automate. Experts there would conduct in-depth research on this error and provide you with more professional assistance.We ask you to post in above mentioned category is that we have limited resources and knowledge about automated workflows, and in the above-mentioned forum, you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction. Thank you for your kind understanding and have a great day!

Best Regards,

Ashraf | Microsoft Community Moderator

Share via

How to get custom fields answers form MS Bookings through Power Automate

6 answers