Issues with copy pasting multiple item list to automatically generate multiple-choice question items

Brass Contributor

I posted this issue on the Uservoice, but since it's important, I'm reposting here too.

 

The process of copy/pasting a list of items (from Excel, OneNote, text editor) into a single item field of a multiple choice question to automatically generate the response items has a couple bugs.

 

1) There is a 37 item limit. A list of items bigger than 37 (I have 50 students each of my classes and I need to copy/paste their names into the form) causes Forms to freeze/not save beyond the 37th item. Copy/pasting my long list in separate chunks (copy/paste first 25 names, then the rest) does not work. Forms still gets stuck and is unable to save. My workaround is copy/pasting each student name (50!) one at a time ☹

 

2) Although it may not look like it when copy/pasting a list of items to automatically generate response items, carriage return text strings are being attached to the end of each item response. All my responses now have a "_x000D_" at the end when I open up my resulting data in Power Bi, and having to work around that is tedious and frustrating.

 

Bonus! Multiple choice questions with multiple responses enabled has a funky output too. If a user selects both my "Pitch" and "Rhythm" items, instead of the answer showing up as "Pitch;Duration;", it shows up as the following in Excel:

 

"Pitch
;Duration
;"

 

And shows up as "Pitch_x000D_;Duration_x000D_;" in Power Bi.

 

These problems wrecked my workflow with 3 Forms I'll be using for the rest of the year with multiple classes. Please take a look into these issues.

 

Reference Tweet conversation with pic of Form Saving issue: https://twitter.com/AndrewNRoxanna/status/1066487541258317825

 

Pic of carriage return text strings in Power Bi: https://twitter.com/AndrewNRoxanna/status/1070911335322464256

1 Reply

Did more assessments with my students this week, you can see where I now need to go into my Form's Excel workbook and delete all the hidden "_x000D_" carriage returns. 

 

Annotation 2019-01-12 121541.jpg