work order - inspection response which dataverse table

(1) Share

Report

Posted on by Samantha73

2,453

Hi Guys

We are using inspection templates with work orders. I couldn't find a way to access the inspection responses so I can create a report after completing the inspections. Which table should I be accessing?

All responses (2)

Answers (1)

Verified answer

VaHiX 3,119 on at

Like (2)

Report
work order - inspection response which dataverse table

In Dynamics 365 Field Service, inspection responses are stored in specific tables within Microsoft Dataverse. To create reports based on these responses, you need to access the following tables:

Customer Voice Survey Question (msfp_question):

This table stores each inspection question.

Customer Voice Survey Response (msfp_surveyresponse):

This table contains the overall response to an inspection.

Customer Voice Survey Question Response (msfp_questionresponse):

This table holds each individual response to each inspection question.

Run reports on inspection responses - Dynamics 365 Field Service | Microsoft Learn

Add inspections to work orders - Dynamics 365 Field Service | Microsoft Learn
VaHiX 3,119 on at

Like (2)

Report
work order - inspection response which dataverse table

In Dynamics 365 Field Service, inspection responses are stored in specific tables within Microsoft Dataverse. To create reports based on these responses, you need to access the following tables:

Customer Voice Survey Question (msfp_question):

This table stores each inspection question.

Customer Voice Survey Response (msfp_surveyresponse):

This table contains the overall response to an inspection.

Customer Voice Survey Question Response (msfp_questionresponse):

This table holds each individual response to each inspection question.

Run reports on inspection responses - Dynamics 365 Field Service | Microsoft Learn

Add inspections to work orders - Dynamics 365 Field Service | Microsoft Learn