web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : uhizdBQLn3+eYNR0MuiDVz
Power Apps - Building Power Apps
Answered

Dynamic Drop Down List in Form

Like (0) ShareShare
ReportReport
Posted on 28 Dec 2018 20:04:43 by

Hi.  I'm trying to create a dynamic drop down for a form in sharepoint.

 

I have three sharepoint lists:

  • Data: Contains the data regarding list items that include the fields State & County.
  • States: Contains the list of all US States
  • Counties: Contains the list of all US Counties and the second field is the corresponding state. 

I'd like the user to be able to enter an entry into the data list using the form and only the counties in that state displayed when entering data into the form.

 

Please help.

 

Thanks,

 

John

Categories:
I have the same question (0)
  • v-xida-msft Profile Picture
    on 31 Dec 2018 at 08:11:04
    Re: Dynamic Drop Down List in Form

    Hi @Anonymous,

    Could you please share a bit more about your scenario?

    Do you want to populate the Counties Drop down dynamically based on the selected state within the States Drop down?

    Based on the needs that you mentioned, I think you want to create a cascading Dropdowns in your app, is it true?

    If you want to populate the Counties Drop down dynamically based on the selected state within the States Drop down, I have made a test on my side, please take a try with the following workaround:

    Set the Items property of the States Dropdown box to following:

    'YourStatesList'.ColumnName /* <-- ColumnName represents the column you use to store your US States values in your list*/

    Set the Items proeprty of the Counties Dropdown box to following:

    Filter('YourCountiesList', StateColumn = StatesDropdown.Selected.Value).CountiesColumn

    Note: The StateColumn represents the column in your Counties list, which used to store the State value. The CountiesColumn represents the column in your Counties list, which used to store the Counties value

    More details about creating a cascading Dropdowns in PowerApps, please check the following video:

    https://youtu.be/pkZG2boN7jQ

     

    Best regards,

    Kris

  • Verified answer
    cwebb365 Profile Picture
    3,294 Most Valuable Professional on 28 Dec 2018 at 21:10:08
    Re: Dynamic Drop Down List in Form

    Have a drop down for State with Items set to : States list. 

     

    On the drop down control for County under items: do something like Filter('Counties', StateColumn = StateDropDown.Selected.Value) where statecolumn is the matching column in County. 

     

    Here is a good video covering cascading drop downs: https://www.youtube.com/watch?v=pkZG2boN7jQ&t=476s

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 892 Most Valuable Professional

#2
Power Apps 1919 Profile Picture

Power Apps 1919 356

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 310 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete