Dynamic Drop Down List in Form

(0) Share

Report

Posted on by Community Power Pla...

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

cwebb365 3,294 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No
v-xida-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No