Forum Discussion

Jernyn_Ho's avatar
Jernyn_Ho
Copper Contributor
Mar 05, 2020

Microsoft Form Drop Down List Issue

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...
microsoft forms
RobElliott's avatar
RobElliott
Silver Contributor
Mar 05, 2020

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.

 

 

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

Keen_Hon's avatar
Keen_Hon
Copper Contributor
Sep 16, 2020

RobElliott Did you do this in Microsoft Forms or Sharepoint Forms?

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Sep 16, 2020

    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

Resources