Forum Discussion

cad-one's avatar
cad-one
Brass Contributor
Jun 29, 2020

Drop Down For USA States & Cities

Hi,

 

In  Microsoft form, I would like users to click on a drop-down list to select a US state. Then in another drop-down list a City.

 

Is this possible to do?

 

Thanks

C1

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor

    Hi cad-one 

     

    Microsoft Forms doesn't allow for that type of cascade menu.

     

    The only way I could think of to do it is to have a branching question for each state with the city in it. I suspect this would get messy for you.

     

    Best wishes

    Damien

    • Ray_D1645's avatar
      Ray_D1645
      Copper Contributor

      Damien_Rosario 

      How about about a "quick" format option to add all the states at once vs having to add 50 options manually for common form data?

      • RobElliott's avatar
        RobElliott
        Silver Contributor

        Ray_D1645 you can add all the states at once from Excel. Copy the list in Excel, click in the first answer in Forms and ctrl+v. It might take a couple of goes but works well.

         

        Rob
        Los Gallardos
        Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources