Adding a long drop-down list

%3CLINGO-SUB%20id%3D%22lingo-sub-1390929%22%20slang%3D%22en-US%22%3EAdding%20a%20long%20drop-down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1390929%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20creating%20a%20Form%20and%20have%20a%20long%20list%20of%20employees%20in%20an%20Excel%20file%20already.%20I'd%20like%20to%20be%20able%20to%20copy%20that%20list%20and%20paste%20it%20in%20MS%20Forms%20instead%20of%20having%20to%20input%20each%20name%20one-by-one.%20Is%20there%20a%20way%20to%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1390929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDrop-Down%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1392968%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20long%20drop-down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392968%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%2F668583%22%20target%3D%22_blank%22%3E%40ayoshimura%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20just%20make%20sure%20that%20your%20question%20is%20marked%20as%20dropdown%20and%20just%20make%20a%20copy%20and%20paste%2C%20see%20the%20attachment%20as%20an%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%3C%2FP%3E%3CP%3EJM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393195%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20long%20drop-down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393195%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F608854%22%20target%3D%22_blank%22%3E%40jmaradiagahn%3C%2FA%3E%26nbsp%3BWOW!%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1476926%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20long%20drop-down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1476926%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F608854%22%20target%3D%22_blank%22%3E%40jmaradiagahn%3C%2FA%3E%26nbsp%3BThank%20you!!%20You've%20saved%20me%20a%20lot%20of%20time.%3C%2FP%3E%3CP%3EI%20wish%20there%20was%20an%20option%20to%20search%20or%20start%20typing%20and%20get%20results%20on%20this%20long%26nbsp%3B%20drop-down%20lists.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1477770%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20long%20drop-down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477770%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%2F131750%22%20target%3D%22_blank%22%3E%40Olga%20Melo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreat!%20I'm%20glad%20to%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EJM%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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?

17 Replies

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

@jmaradiagaio WOW! Thank you!

@jmaradiagaio 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.

Hi @Olga Melo 

Great! I'm glad to help.

 

Regards,

JM

Hi @jmaradiagaio,

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

@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

@RobElliott , the downside to Powerapps is that you can't make it public! 

@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.

Thank 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.
Hi Olga,
How many itens have you in your list? How do you solve it?
thank you
Over 800 records. I ended up using survey123, creating cascading dropdowns to facilitate the user experience.
I'll try lime survey
We can embebed Power Apps in a Form 365?

@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

Thank you.
But to publish (to general public) by an URL is not free?

No it's not, as the users would be outside your organisation you can't just give them the web link because it won't work, it has do be done with Power Apps Portals which is not free.

Thank you.