Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Customer Voice forum / Obtain Contacts from m...
Customer Voice forum
Suggested answer

Obtain Contacts from msfp_surveyresponse

Posted on by 5

Hi


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:
  • OG-24051445-0 Profile Picture
    OG-24051445-0 10 on at
    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 Profile Picture
    Welly Lee on at
    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans