Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / How to extract all lon...
Customer experience | Sales, Customer Insights,...
Suggested answer

How to extract all long multi choice question responses when msfp_name is truncated to 100 characters in msfp_questionresponse

(0) ShareShare
ReportReport
Posted on by _Adrian 15

Hi,

How can I extract all the answers that were selected for a multiple choice question, when these are long answers? I can see msfp_name in msfp_questionresponse that has each selected answers in "" and delimited with a comma, but this field has a maximum length of 100 characters. This truncates the field and I can't see all the responses. Is there another way to extract all the selections?

I have various multiple choice questions for which the response options are short statements and therefore many characters. If there are say 5 responses each with 50 characters, if more than 2 are selected, the msfp_name is truncated at 100 characters and so I can't see what they are.

Can anyone suggest another approach?

Thanks,

Adrian

  • graemeg Profile Picture
    graemeg 65 on at
    RE: How to extract all long multi choice question responses when msfp_name is truncated to 100 characters in msfp_questionresponse

    I have been into the detail with this one.  Using Dataverse as the reporting database limits fields to 100 characters, there is no solution to this within this database.  The alternative is to use the Common Data Services database where the 100 character limit is not present.  I found this highly frustrating as Microsoft are promoting the use of Dataverse and tag Common Data Services as "legacy".

  • graemeg Profile Picture
    graemeg 65 on at
    RE: How to extract all long multi choice question responses when msfp_name is truncated to 100 characters in msfp_questionresponse

    I hit an identical problem to this and had to regress from Dataverse to Common Data Services for some of the surveys I have.

  • _Adrian Profile Picture
    _Adrian 15 on at
    RE: How to extract all long multi choice question responses when msfp_name is truncated to 100 characters in msfp_questionresponse

    Thanks Welly. As was recommended, I was using TDS enabled Dataverse connector. I have now switched to the CDS legacy connector using API, which works but is much slower.

    (Note to anyone else that plans to do this, that data from each connector is NOT the same... tread carefully! Fields can have an additional "_" at the start, so some msfp_xxx fields in Dataverse become _msfp_xxx when using legacy connector. Also, ID fields are changed to lowercase.)

    Truncating free text answers and multi-choice selections to 100 characters often renders the response unusable and therefore I feel that the Dataverse connector is not fit for purpose. I think that this is a fairly obvious flaw and hopefully one that will be fixed soon. Until then, I don't think Customer Voice documentation should be promoting its use. I've spent many hours on this, and other users will have the same problem.

    Thanks for your help (and the help from the tech support ticket I raised in parallel) in finding a workaround.

  • Suggested answer
    Welly Lee Profile Picture
    Welly Lee on at
    RE: How to extract all long multi choice question responses when msfp_name is truncated to 100 characters in msfp_questionresponse

    Are you using the new Dataverse connector? The Dataverse connector does not support multi-line text, so you need to use Common Data Service (legacy) connector

  • _Adrian Profile Picture
    _Adrian 15 on at
    RE: How to extract all long multi choice question responses when msfp_name is truncated to 100 characters in msfp_questionresponse

    Hi Welly,

    I've since found out that the msfp_response column is configured as a multi-line field and that multi-line text fields are NOT yet supported by TDS. This is why I can't see it.

    I had enabled TDS to allow connection to the Dataverse, as mentioned here:

    docs.microsoft.com/.../view-entity-data-power-bi

    Note that I have Customer Voice as a stand alone, and not part of D365 (only mentioned in case that makes a difference).

    Is there another way to access the data with the msfp_response field?

    Thanks,

    Adrian

  • _Adrian Profile Picture
    _Adrian 15 on at
    RE: How to extract all long multi choice question responses when msfp_name is truncated to 100 characters in msfp_questionresponse

    Hi Welly,

    Thanks for the suggestion but unfortunately msfp_response does not exist in msfp_questionresponse. I can see that it is mentioned in the developer guide (docs.microsoft.com/.../msfp_questionresponse, but I can't see that field in my data. I've checked all the other tables too, and msfp_response seems to be missing...

  • Welly Lee Profile Picture
    Welly Lee on at
    RE: How to extract all long multi choice question responses when msfp_name is truncated to 100 characters in msfp_questionresponse

    _Adrian -- please use msfp_response  (instead of msfp_name) to extract the full text

  • _Adrian Profile Picture
    _Adrian 15 on at
    RE: How to extract all long multi choice question responses when msfp_name is truncated to 100 characters in msfp_questionresponse

    Bump

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans