How to Fix Null Customer Answer in Microsoft Bookings Power Automate
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.

- 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.
Ensure you have administrative access to both the Microsoft Bookings calendar and the Power Automate environment where the flow is running.
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.
Open your Microsoft Bookings calendar and view the specific appointment details to confirm that the customer actually filled out the custom question field.
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.
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.

Escalate the Issue to Microsoft Support
If the flow is configured correctly and responses exist but still return as null, escalate the issue to the dedicated Microsoft Q&A forum.
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. Visit the WPS Office website: Go to the official WPS website on your browser.
- 2. Download the installer: Click the Free Download button to get the lightweight installation file for your operating system.
- 3. Install and launch: Run the downloaded file, complete the quick installation, and start creating compatible office documents immediately.

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.




