Forum Discussion
ayoshimura
May 14, 2020Copper Contributor
Adding a long drop-down list
I'm creating a Form and have a long list of employees in an Excel file already. I'd like to be able to copy that list and paste it in MS Forms instead of having to input each name one-by-one. Is there a way to do that?
- jaymaradiagaIron Contributor
Hi ayoshimura
Yes, just make sure that your question is marked as dropdown and just make a copy and paste, see the attachment as an example.
Hope this helps.
JM
- ruiestvesCopper ContributorHi jaymaradiaga,
I've a long list with hundreads records to insert in a drop down box in the Forms. It is possible? I access the public link form and the results don't appear! It takes time to fill?
thank you- RobElliottSilver Contributor
ruiestves Olga Melo having hundreds of items in a dropdown list is a terrible experience for the user. You would be better to use Power Apps where you can have cascading dropdowns or have a search box to filter the list based on the letters you type. It's a much better user experience.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- Olga MeloBrass Contributor
jaymaradiaga Thank you!! You've saved me a lot of time.
I wish there was an option to search or start typing and get results on this long drop-down lists.
- ruiestvesCopper ContributorHi Olga,
How many itens have you in your list? How do you solve it?
thank you
- ayoshimuraCopper Contributor
jaymaradiaga WOW! Thank you!