Mar 04 2020
- last edited on
Aug 06 2023
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.
Mar 04 2020 10:27 PM
Mar 05 2020 01:30 AM - edited Mar 05 2020 04:27 AM
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.
Microsoft Power Automate Community Super User
Sep 27 2021 05:42 AM - edited Sep 27 2021 07:02 AM
Hi Rob ,
It was really a good insight. Could you please share the process of drop down listings based on input of another field? I am trying to create a conditional drop down in MS forms like your attached snip.
Thanks in advance.