Microsoft Form Drop Down List Issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1210444%22%20slang%3D%22en-US%22%3EMicrosoft%20Form%20Drop%20Down%20List%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1210444%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20tasked%20to%20create%20a%20form%20with%20a%20drop%20down%20list%20of%20%3CSTRONG%3E3000%20options%3C%2FSTRONG%3E.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20able%20to%20copy%20and%20paste%20the%20list%20of%20options%20into%20Microsoft%20Form.%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20the%20%3CSTRONG%3Eform%20would%20not%20save%3C%2FSTRONG%3E%20and%20the%20%3CSTRONG%3Edrop%20down%20list%20does%20not%20work%20on%20mobile%20phone%3C%2FSTRONG%3E.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20it%20is%20preview%20in%20the%20testing%20environment%2C%20the%20drop%20down%20list%20is%20working%2C%20but%20when%20the%20link%20is%20shared%20to%20someone%20else%2C%20the%20%3CSTRONG%3Erespondent%20was%20not%20able%20to%20view%20the%20drop%20down%20list%3C%2FSTRONG%3E%20at%20all.%26nbsp%3BWhat%20was%20shown%20to%20the%20respondent%20is%20option%201%20and%20option%202%20only.%3C%2FP%3E%3CP%3EHoping%20to%20get%20some%20great%20ideas%20to%20this%20issue.%26nbsp%3B%3CBR%20%2F%3EThanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1210444%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eimportant%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1210592%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Form%20Drop%20Down%20List%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1210592%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3ESee%20article%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-forms%2Fdrop-down-box-and-lists%2Fm-p%2F21465%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-forms%2Fdrop-down-box-and-lists%2Fm-p%2F21465%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20is%20not%20100%25%20clear%20on%20this%20functionality.%20What%20we%20know%3CBR%20%2F%3E%3CBR%20%2F%3E-%20Drop%20down%20view%20doesn%E2%80%99t%20work%20on%20mobile%2C%20there%20is%20a%20user%20voice%20open%20for%20this%3CBR%20%2F%3E%3CBR%20%2F%3E-%20There%20may%20be%20a%20limit%20to%20the%20number%20of%20options%20-%20yet%20there%20is%20nothing%20I%20can%20find%20on%20these%20forums%20or%20in%20official%20docs%20suggesting%20a%20limit.%20We%20know%20it%E2%80%99s%20at%20least%20750%20as%20it%20worked%20in%20that%20article%3CBR%20%2F%3E%3CBR%20%2F%3E-%20Doesn%E2%80%99t%20look%20like%20it%20works%20if%20you%20have%20the%20multiple%20answers%20selected%20so%20you%20will%20need%20to%20turn%20that%20off%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20answers%20your%20question%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chria%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1210865%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Form%20Drop%20Down%20List%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1210865%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F574817%22%20target%3D%22_blank%22%3E%40Jernyn_Ho%3C%2FA%3E%26nbsp%3Bfrom%20a%20usability%20perspective%20a%20dropdown%20with%203000%20items%20would%20be%20a%20nightmare.%20If%20I%20had%20been%20asked%20to%20do%20this%20my%20immediate%20reaction%20would%20be%20to%20look%20at%20using%20a%20Power%20Apps%20form%20with%20cascading%20dropdowns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20very%20simple%20example%20I%20produced%20linked%20to%20a%20SharePoint%20list%20was%20for%20a%20user%20to%20select%20a%20county%20in%20the%20UK%20and%20the%20following%20dropdown%20contained%20just%20those%20towns%20and%20villages%20in%20that%20county.%20So%20although%20the%20list%20of%20towns%20and%20villages%20was%20several%20thousand%20long%2C%20a%20user%20only%20ever%20saw%20a%20much%20smaller%20number%20relevant%20to%20the%20earlier%20selection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22townsCounties.png%22%20style%3D%22width%3A%20500px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F175427iCA91FA2066A5E378%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22townsCounties.png%22%20alt%3D%22townsCounties.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20something%20along%20those%20lines%20would%20be%20my%20recommendation%20for%20achieving%20what%20you've%20been%20asked%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1672796%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Form%20Drop%20Down%20List%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1672796%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BDid%20you%20do%20this%20in%20Microsoft%20Forms%20or%20Sharepoint%20Forms%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1672851%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Form%20Drop%20Down%20List%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1672851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F795585%22%20target%3D%22_blank%22%3E%40Keen_Hon%3C%2FA%3E%26nbsp%3Bit%20was%20a%20Power%20Apps%20form%20with%20a%20SharePoint%20list%20as%20the%20data%20source.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, 

 

I've been tasked to create a form with a drop down list of 3000 options

I'm able to copy and paste the list of options into Microsoft Form. 

However, the form would not save and the drop down list does not work on mobile phone

When it is preview in the testing environment, the drop down list is working, but when the link is shared to someone else, the respondent was not able to view the drop down list at all. What was shown to the respondent is option 1 and option 2 only.

Hoping to get some great ideas to this issue. 
Thanks! 

4 Replies
Highlighted
Hi,

See article

https://techcommunity.microsoft.com/t5/microsoft-forms/drop-down-box-and-lists/m-p/21465

It is not 100% clear on this functionality. What we know

- Drop down view doesn’t work on mobile, there is a user voice open for this

- There may be a limit to the number of options - yet there is nothing I can find on these forums or in official docs suggesting a limit. We know it’s at least 750 as it worked in that article

- Doesn’t look like it works if you have the multiple answers selected so you will need to turn that off

Hope that answers your question

Best, Chria
Highlighted

Hi @Jernyn_Ho from a usability perspective a dropdown with 3000 items would be a nightmare. If I had been asked to do this my immediate reaction would be to look at using a Power Apps form with cascading dropdowns.

 

A very simple example I produced linked to a SharePoint list was for a user to select a county in the UK and the following dropdown contained just those towns and villages in that county. So although the list of towns and villages was several thousand long, a user only ever saw a much smaller number relevant to the earlier selection.

 

townsCounties.png

 

So something along those lines would be my recommendation for achieving what you've been asked to do.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@Rob Elliott Did you do this in Microsoft Forms or Sharepoint Forms?

Highlighted

@Keen_Hon it was a Power Apps form with a SharePoint list as the data source.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User