Forum Discussion

ayoshimura's avatar
ayoshimura
Copper Contributor
May 14, 2020

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?

  • jaymaradiaga's avatar
    jaymaradiaga
    Iron 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

    • ruiestves's avatar
      ruiestves
      Copper 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
      • RobElliott's avatar
        RobElliott
        Silver 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 Melo's avatar
      Olga Melo
      Brass 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.

      • ruiestves's avatar
        ruiestves
        Copper Contributor
        Hi Olga,
        How many itens have you in your list? How do you solve it?
        thank you

Resources