By default, MS Bookings put all of your custom fields into a single array of objects, so you will need to access the answers by referencing its index. Let's take this sample Booking page, with 2 custom fields:
In Power Automate, I'm first assigning the Custom Question Answers dynamic content to a Compose, just to visualize its outputs:
And they are an array of objects, where the order of the elements follows the same order of the fields in the Booking page:
Then in a email action (this is not your exact use case, but you can leverage the same logic), I'm simply using an expression to reference the Compose output, followed by the index of the custom field (0 for first, 1 for the second, and so on, highlighted in yellow), and the Answer property (in green):
For your use case, you can use the same expression, but passing it as input to your Excel column inputs in the Add a row present into a table action. You also won't need the For each loop, which was added by default to your flow by Power Automate.
After submitting the booking request, this is the output in Outlook in the email message for the dynamic content corresponding to the custom fields answers:
I'm also sharing some content about the topics discussed here for further reference, which can be helpful for you or for other users that find this thread in the future:
Let me know if it works for you or if you need any additional help!
If this is the answer to your question, please mark the post as
Accepted Answer.
If this answer helps you in any way, please give it a
like.
Check more Power Platform content on my
website.
Lets connect on
LinkedIn.
