Others

How to Fix Null Customer Answer in Microsoft Bookings Power Automate

Steven ParkerSteven Parker Oct 23, 2026 870 views

Question details

Users need to troubleshoot a Power Automate flow that returns a null value for the Customer Answer field when triggered by a Microsoft Bookings one-to-many service.

How to Fix a Null Customer Answer in Microsoft Bookings
Product
Microsoft Bookings
Device & OS
not provided
Scenario
Automating data extraction from Microsoft Bookings using Power Automate for group or one-to-many services.
Observed behavior
The dynamic field for Customer Answer returns a null value instead of the actual response provided by the customer during the booking process.
Before you start

Ensure you have administrative access to both the Microsoft Bookings calendar and the Power Automate environment where the flow is running.

Solution 1Recommended

Verify Booking Responses and Check Dynamic Field Compatibility

Ensure the customer actually provided an answer and that the selected dynamic content is supported for one-to-many services in the Microsoft Graph API.

One-to-many services (group bookings) handle data differently than standard 1:1 appointments. Custom question responses for group bookings may not always map perfectly to standard dynamic fields in Power Automate.

1
Check the appointment manually

Open your Microsoft Bookings calendar and view the specific appointment details to confirm that the customer actually filled out the custom question field.

2
Review dynamic content mapping

In Power Automate, open your flow in edit mode and verify that the correct 'Customer Answer' dynamic content token is mapped to your output action.

3
Consult Graph API limitations

Check the Microsoft Graph API documentation to confirm if the specific custom question data is exposed for one-to-many service types, as some properties only populate for standard 1:1 bookings.

Verify Booking Responses and Check Dynamic Field Compatibility
Data Structure Differences: Group bookings structure customer details as an array within the appointment object. You may need to use an 'Apply to each' loop in Power Automate to parse individual customer answers.
Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While troubleshooting Microsoft Bookings and Power Automate integrations, you can rely on WPS Office for your daily document, spreadsheet, and presentation needs. It is a free, lightweight, and highly compatible alternative to Microsoft Office.

  1. 1. Visit the WPS Office website: Go to the official WPS website on your browser.
  2. 2. Download the installer: Click the Free Download button to get the lightweight installation file for your operating system.
  3. 3. Install and launch: Run the downloaded file, complete the quick installation, and start creating compatible office documents immediately.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight design ensures fast loading and smooth performance on any PC or Mac.Familiar, intuitive user interface requires no learning curve to switch.Built-in PDF editor to easily manage forms, customer agreements, and booking summaries.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate return a null value for Bookings custom questions?

This commonly happens if the customer skipped an optional question during the booking process, or if the API does not properly expose custom field data for one-to-many (group) service types.

How can I extract customer answers from Microsoft Bookings without Power Automate?

You can manually export your Microsoft Bookings calendar data. Open the Bookings web app, navigate to the Home or Calendar page, and select 'Export data' to download a TSV file that can be opened in spreadsheet software.

Are one-to-many services handled differently in the Microsoft Graph API?

Yes, one-to-many (group) bookings utilize a different data structure in the API compared to 1:1 appointments. Customer details are nested in an array, which can cause standard dynamic content fields in Power Automate to map incorrectly or return null if not parsed correctly.