Run reports on inspection responses

Create reports or dashboards in Power BI to analyze and act on inspection responses from technicians. Once enabled, all responses entered for an inspection are stored in Microsoft Dataverse and can be parsed into individual question responses.

The questions and responses are saved into the following Dataverse tables:

• Customer Voice survey question (msfp_question): Each inspection question.
• Customer Voice survey response (msfp_surveyresponse): A response to an inspection.
• Customer Voice survey question response (msfp_questionresponse): Each individual response to each inspection question.

Each image uploaded in inspections is stored as an annotation in the Inspection Attachment (msdyn_inspectionattachment) table. Retrieve them using Microsoft Power Automate flows.

Prerequisites

• You have admin privileges in Dynamics 365 Field Service
• You have access to Microsoft Power Apps
• You have access to Microsoft Power Automate

Enable analysis on inspection responses

Configure how often inspection responses are parsed and organized in a Dataverse table.

1. In Field Service, change to the Settings area.

2. Go to Field Service Settings and select the Inspection tab.

3. Ensure Analytics enabled is set to Yes.

4. For Analytics frequency, select how often to parse inspection responses:

   • Daily: Daily based on the Record generation start time.
   • Immediately: As soon as an inspection is marked complete.
   • Custom: A custom frequency between one and 365 days.

   Note

   When analytics frequency is set to Immediately, the inspection response is parsed and persisted as soon as the service task is completed; the parsed responses won't be updated even if the technician makes changes and completes the inspection again. However, if the analytics frequency is set to Daily or Custom, the responses are stored from the latest completion of the service task before the flow start time.

View inspection questions and responses

Questions on inspections are stored in Dataverse, and can be found in the table in Power Apps.

1. Sign in to Power Apps.

2. Select Tables and then All.

3. Search for and select the table you want to view. For example, Customer Voice survey response. This table is empty until an inspection is completed

   

View the status of the out-of-the-box inspection flows

Inspections use Power Automate flows, which are part of the out-of-the-box inspection capability. The following flows are used:

• Deserialization of Inspection Definition Flow: This flow is triggered when an inspection is published. It populates inspection questions into the Customer Voice survey question (msfp_question) table.
• Deserialization of Inspection Response – Recurrent Flow: This flow is triggered when the frequency is set to Daily or Custom. It updates the parsed inspection response JSON into Customer Voice survey response (msfp_surveyresponse) and creates new records for responses and corresponding questions in the Customer Voice survey question response (msfp_questionresponse) table.
• Deserialization of Inspection Response Flow: This flow takes care of response parsing when frequency is set to Immediately.

To view the status of the flows, sign in to Power Automate, select your Field Service environment, and then select My flows. Open one of the flows.

Use a Power Automate flow to parse inspection responses (deserialization of responses)

When a technician fills out an inspection, the answers to each inspection question are stored as JSON in the Inspection Response (msdyn_inspectionresponse) table. You can use a Power Automate flow to run a workflow on inspection responses. For example, if a technician responds 'Yes' to the inspection question Is a follow-up required? then a new follow-up work order service task could be added to the related work order. For more information, watch the video on running workflows on Inspection responses or go to Create a cloud flow in Power Automate.