Power Automate Bookings Connector update - now with custom questions and answers! 

The custom questions and answers are returned as an array. The cleanest way to get the data out would be to use a select action to retrieve the questions and responses, then you can use the array index to get the appropriate answer from the output of the select.

​@@cvkealey Thank you Chad for your response! I built a flow exactly as the one you showed above. As such, I believe I accomplished the first part of your suggestion (getting data using select action to retrieve question and responses), as this is what was right before the 'Create HTML table' action. What do you mean by 'use the array index'?

The "index" is the number or order of the item in the array. The first item or element in each array has an index of 0, the second item's index is 1 and so on. The custom question response data is ordered based on the order the questions appear. Also, each element in that array is an object with several key/value pairs, such as "Question" (containing the question text) and "Answer" (containing their response). So, to get the answer to the first question, you would use the format ?[0]?['Answer']. See this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6fLyGFWKyPE.html, specifically around here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6fLyGFWKyPE.html?t=412 for a demonstration.

@@AbinThomas23 Using Chad's suggestion as a base, I did the following. Initialized arrays for each answer, and for the value of each array, I entered the following triggerOutputs()?['body/CustomQuestionAnswers']?[0]?['Answer']. [0] represents the first item (question) in the array, [1] would represent the second, and so on... So when you're entering dynamic values for your excel, simply select the corresponding variable, providing you've renamed your variables to match the question.

To get the custom questions and answers, you need to use the "item()" expression. Unfortunately, you can't just choose it as dynamic content. You can see the proper syntax here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kzNpsyVYI34.htmlsi=4f6y6RQXtzjs_JLD&t=300. Also, in this video, I'm using a 1:1 booking. If you have a group booking, the questions and answers are still there, just in a slightly different place. I don't have a video showing that, but if you have a compose action at the start of your flow to show the "body" of the output from the trigger, you should be able to find it by looking at a flow run.

I'm planning a more detailed video on handling custom questions. It should be out in the next week or two. As for the approval, you certainly could start an approval when a new booking is made, but there's no supported method for programmatically updating or cancelling a booking appointment, so there's no way to, for example, cancel an appointment if it's rejected.

Thankzies sir ;)@@cvkealey

Do you mean the form used to make a Booking or some other form (like a follow up form after the appointment)? The one used to make the Booking isn't a Microsoft Forms form, but the data is available via the Bookings connector. It's structured differently, but there.

As shown (at about 3:03), the answers to custom questions are returned as an array (even if there's only one question, it's still in array format). If you have only one question, you could use the first expression to return the response to that and plug it into a text field in SharePoint. If you have multiples, you can use the join expression to get them all together, or create a csv or html table from the array.

@@cvkealey thanks Chad. Don’t suppose you could do a dummy flow by any chance 😬 I’m new to all of this but it would solve a heap of problems if I can get this to work 🤦‍♀️

I can't really give you the answer...at least not without knowing (in detail) what you are trying to accomplish (ie: what you want to do with those custom question answers). As I mentioned, they're stored in an array, so you need to understand what an array is and how to work with one. This video is an excellent introduction to arrays: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PRKcQ0Q4BJE.htmlsi=nw_qhkViX3HFyYq8 and this one is a bit more advanced and detailed: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-d99Rr5djcME.htmlsi=AfBgKjzI3qT_Bx0v If you need additional help, I would suggest posting a clear description of what you have and what you want to do in the Power Automate Community (powerusers.microsoft.com/t5/Get-Help-with-Power-Automate/ct-p/FL_GeneralDiscussions). You can tag me there (@ChadVKealey).

@@cvkealey thanks so much chad. I’ll look through the video’s 😊

@@cvkealeyThanks so much for this. I think it gets me very close to where I need to be... What I'd like is to pull the value for each custom question into a separate column for the same row of an Excel spreadsheet. Any idea, please?

The questions and answers are an array of objects, each question/answer pair being an "object". So, you can retrieve the answers using the appropriate array notation. So, after the Select shown, if you want to get just the answer to the first question, you would use (in a compose action or the data field you're sending to SQL) this expression: outputs()?[0]?['Answer']

I'm sure there is. In fact, I believe the previous/original connector returned custom question data ONLY for group (1:N) bookings, not 1:1 bookings. Unfortunately, I don't have any users that do group bookings, so I haven't spent any time testing with those. The technique should be the same.

It's possible your admins are blocking it. I would suggest contacting your IT department.