web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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)
  • _Adrian Profile Picture
    _Adrian 15 on at

    Bump

  • Welly Lee Profile Picture
    Welly Lee Microsoft Employee on at

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

  • _Adrian Profile Picture
    _Adrian 15 on at

    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...

  • _Adrian Profile Picture
    _Adrian 15 on at

    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

  • Suggested answer
    Welly Lee Profile Picture
    Welly Lee Microsoft Employee on at

    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

    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.

  • graemeg Profile Picture
    graemeg 67 on at

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

  • graemeg Profile Picture
    graemeg 67 on at

    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".

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 142 Super User 2026 Season 1

#2
Nagaraju_Matta Profile Picture

Nagaraju_Matta 128

#3
ManoVerse Profile Picture

ManoVerse 127 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans