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

%3CLINGO-SUB%20id%3D%22lingo-sub-306094%22%20slang%3D%22en-US%22%3EIssues%20with%20copy%20pasting%20multiple%20item%20list%20to%20automatically%20generate%20multiple-choice%20question%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306094%22%20slang%3D%22en-US%22%3E%3CP%3EI%20posted%20this%20issue%20on%20the%20%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F36362194-issues-with-copy-pasting-multiple-items-to-automat%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EUservoice%3C%2FA%3E%2C%20but%20since%20it's%20important%2C%20I'm%20reposting%20here%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20process%20of%20copy%2Fpasting%20a%20list%20of%20items%20(from%20Excel%2C%20OneNote%2C%20text%20editor)%20into%20a%20single%20item%20field%20of%20a%20multiple%20choice%20question%20to%20automatically%20generate%20the%20response%20items%20has%20a%20couple%20bugs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20There%20is%20a%2037%20item%20limit.%20A%20list%20of%20items%20bigger%20than%2037%20(I%20have%2050%20students%20each%20of%20my%20classes%20and%20I%20need%20to%20copy%2Fpaste%20their%20names%20into%20the%20form)%20causes%20Forms%20to%20freeze%2Fnot%20save%20beyond%20the%2037th%20item.%20Copy%2Fpasting%20my%20long%20list%20in%20separate%20chunks%20(copy%2Fpaste%20first%2025%20names%2C%20then%20the%20rest)%20does%20not%20work.%20Forms%20still%20gets%20stuck%20and%20is%20unable%20to%20save.%20My%20workaround%20is%20copy%2Fpasting%20each%20student%20name%20(50!)%20one%20at%20a%20time%20%E2%98%B9%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20Although%20it%20may%20not%20look%20like%20it%20when%20copy%2Fpasting%20a%20list%20of%20items%20to%20automatically%20generate%20response%20items%2C%20carriage%20return%20text%20strings%20are%20being%20attached%20to%20the%20end%20of%20each%20item%20response.%20All%20my%20responses%20now%20have%20a%20%22_x000D_%22%20at%20the%20end%20when%20I%20open%20up%20my%20resulting%20data%20in%20Power%20Bi%2C%20and%20having%20to%20work%20around%20that%20is%20tedious%20and%20frustrating.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBonus!%20Multiple%20choice%20questions%20with%20multiple%20responses%20enabled%20has%20a%20funky%20output%20too.%20If%20a%20user%20selects%20both%20my%20%22Pitch%22%20and%20%22Rhythm%22%20items%2C%20instead%20of%20the%20answer%20showing%20up%20as%20%22Pitch%3BDuration%3B%22%2C%20it%20shows%20up%20as%20the%20following%20in%20Excel%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Pitch%3CBR%20%2F%3E%3BDuration%3CBR%20%2F%3E%3B%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20shows%20up%20as%20%22Pitch_x000D_%3BDuration_x000D_%3B%22%20in%20Power%20Bi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20problems%20wrecked%20my%20workflow%20with%203%20Forms%20I'll%20be%20using%20for%20the%20rest%20of%20the%20year%20with%20multiple%20classes.%20Please%20take%20a%20look%20into%20these%20issues.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReference%20Tweet%20conversation%20with%20pic%20of%20Form%20Saving%20issue%3A%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FAndrewNRoxanna%2Fstatus%2F1066487541258317825%22%20rel%3D%22nofollow%20noreferrer%20noopener%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftwitter.com%2FAndrewNRoxanna%2Fstatus%2F1066487541258317825%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPic%20of%20carriage%20return%20text%20strings%20in%20Power%20Bi%3A%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FAndrewNRoxanna%2Fstatus%2F1070911335322464256%22%20rel%3D%22nofollow%20noreferrer%20noopener%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftwitter.com%2FAndrewNRoxanna%2Fstatus%2F1070911335322464256%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-306094%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314170%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20copy%20pasting%20multiple%20item%20list%20to%20automatically%20generate%20multiple-choice%20question%20i%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314170%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EDid%20more%20assessments%20with%20my%20students%20this%20week%2C%20you%20can%20see%20where%20I%20now%20need%20to%20go%20into%20my%20Form's%20Excel%20workbook%20and%20delete%20all%20the%20hidden%20%22_x000D_%22%20carriage%20returns.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Annotation%202019-01-12%20121541.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F65922i7C697F7DE8175D76%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202019-01-12%20121541.jpg%22%20alt%3D%22Annotation%202019-01-12%20121541.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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