Obtain Contacts from msfp_surveyresponse

(0) Share

Report

Posted on by tomas coquimbo

I'm developing a report with power bi and I need relationships between the msfp_surveyresponse table and the Contact table, but according to the documentation, the "from" field should be there, but it isn't.

Could you please help me.

Regards

Categories:

Solution Templates

All responses (2)

Answers (0)

OG-24051445-0 10 on at

Like (0)

Report

Obtain Contacts from msfp_surveyresponse

I have the exactly the same issue with no resolution. Welly Lee's suggestion does not help, because I want to be able to join to the Contact table. The Respondent (msfp_respondent) and Respondent email (msfp_respondentemail) fields are just text fields and not IDs I can use to join.

Anyone else have other ideas?
Suggested answer

Welly Lee on at

Like (0)

Report

RE: Obtain Contacts from msfp_surveyresponse

tomas coquimbo - please use Respondent (msfp_respondent) and Respondent email (msfp_respondentemail) fields on the Customer Voice Survey Responses table to get the respondent info. Refer to the ERD at Entity Reference for Dynamics 365 Customer Voice | Microsoft Docs