Skip to main content
Community site session details

Community site session details

Session Id : Z1z7QF2djOy5oeGb5hbWGT
Power Apps - Building Power Apps
Answered

Cascading dropdown

Like (0) ShareShare
ReportReport
Posted on 4 May 2023 16:04:08 by 46

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:
  • Memtiger Profile Picture
    46 on 04 May 2023 at 20:33:40
    Re: Cascading dropdown

    That is perfect thank you very much.

  • Verified answer
    LaurensM Profile Picture
    12,510 Super User 2025 Season 1 on 04 May 2023 at 20:22:26
    Re: Cascading dropdown

    @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!

  • Memtiger Profile Picture
    46 on 04 May 2023 at 20:12:09
    Re: Cascading dropdown

    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. 

  • LaurensM Profile Picture
    12,510 Super User 2025 Season 1 on 04 May 2023 at 16:38:55
    Re: Cascading dropdown

    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!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1