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 ther...
ruiestves
Mar 10, 2021Copper Contributor
Hi 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
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
RobElliott
Mar 10, 2021Silver 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
- ruiestvesMar 17, 2021Copper ContributorWe can embebed Power Apps in a Form 365?
- RobElliottMar 17, 2021Silver Contributor
ruiestves No, you create the form in Power Apps and then either give your users the weblink to it or embed it in a SharePoint page with the Power Apps web part.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- ruiestvesMar 17, 2021Copper ContributorThank you.
But to publish (to general public) by an URL is not free?
- ruiestvesMar 10, 2021Copper ContributorThank you RobElliott
I se is just possible a list of 250 itens in a dropdown menu. I know is nos a confortable experience for the user, but is a real list of 308 Districts in my country, where the user must choice one.
thank you very much for your sugestions. - Olga MeloMar 10, 2021Brass Contributor
RobElliott , the downside to Powerapps is that you can't make it public!
- RobElliottMar 10, 2021Silver Contributor
Olga Melo actually you can but you need to use Power Apps portals and that comes at a price: https://powerapps.microsoft.com/en-us/portals
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.