Cascading dropdown

(0) Share

Report

Posted on by Memtiger

I have drop downs using 2 different tables connected by a key in each table. For simple problem say

Table1 has these columns

Officename, City, Countyid

Table2 has these columns

Countyid, Countyname, State

Countyid is a unique value

So I need the default in dropdown2 to show the Countyname based on the officename selected in dropdown1.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Memtiger,

You would have to filter the datasource mentioned in DropDown2's Items property. The code will look similar to:

Filter( Table2, IsBlank(Dropdown1.Selected) || Dropdown1.Selected.Countryid = Countryid ) //If you only want the Countyname, you could append the filter with .Countyname

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
Memtiger 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, that does the cascading when I put the filter in the items like you described. So that is a step in the right direction for me. When I change dropdown1 it does put the proper value in dropdown2 but what if I still wanted all the items available from table2 to be listed but only the default changed.

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Memtiger,

In that case you could leave the Items property simply as:

Table2

To change the default selection, we will need to add the following code to the Default property of your second dropdown:

LookUp( Table2, Dropdown1.Selected.Countryid = Countryid ).Countyname

In order for this to work, make sure that Countyname is the field being displayed within your second dropdown.

I hope this helps!

Was this reply helpful? Yes No
Memtiger 46 on at

Like
a
(0)

Report
Copy link

Link copied!

That is perfect thank you very much.

Was this reply helpful? Yes No