web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • graemeg Profile Picture
    graemeg 67 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 67 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 141

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 132

#3
DAnny3211 Profile Picture

DAnny3211 130

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans