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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Cascading dropdown wit...
Power Apps
Answered

Cascading dropdown with 4 levels deep

(0) ShareShare
ReportReport
Posted on by 67

Hi all,

 

I just made an nice app with three levels deep cascading dropdown. 

 

https://www.youtube.com/watch?v=Qzpjq008cBY&t=861s&ab_channel=RezaDorrani i used this as an example.

 

This works fine! I would like to add an 4 field, is that possible?

 

When i try to use the filter or distict option i get an error for the fouth column.

Have anyone experienced with 4 levels of cascading? 

 

Categories:
I have the same question (0)
  • BCBuizer Profile Picture
    22,563 Super User 2026 Season 1 on at

    Hi @robdegekste,

     

    Can you please share the formula that is not working and the error message you get?

  • robdegekste Profile Picture
    67 on at

    Sure! Here are my formule

    Column 1 : 

     

    Distinct(Sort(Filter(SoftwareList;true).Title;Title;Ascending);Title)

     

    Column 2   :

     

    Distinct(
     Filter(
     SoftwareList;
     Title = DrpName.Selected.Result
     );
     Name
    )

     

    Column 3:

     

    Filter(
     SoftwareList;
     Manager = DrpSoftwareName.Selected.Result
    )

     

     

    Column 4: this one is not working...

     

    Filter(
     SoftwareList;
     Code = DrpSoftware.Selected.Result
    )

     

     

  • BCBuizer Profile Picture
    22,563 Super User 2026 Season 1 on at

    Hi @robdegekste ,

     

    Please try:

    Filter(
     SoftwareList;
     Code = DrpSoftware.Selected.Value
    )

     

    The reason this may work is because in the first two dropdowns you have used the Distinct function which returns a column called Result. The third does not, so a different column needs to be selected, where Value is the default for dropdowns.

     

    If this doesn't work, please share the error message your receive.

  • robdegekste Profile Picture
    67 on at

    Normally after 

    DrpSoftware.Selected

    I can only select Result or sometimes Value.

    After the dot (.) i see now the internal names of the SharePoint list. Results or Value doens't work.

     

     

  • Verified answer
    BCBuizer Profile Picture
    22,563 Super User 2026 Season 1 on at

    Hi @robdegekste ,

     

    Could it be you are using a combobox instead of a dropdown (as per the video)? In that case, select the name of the column you wish to filter for, for instance .Code .

  • robdegekste Profile Picture
    67 on at

    Normally i use three single dropdown box for the cascading. Now with 4 levels deep i use 2 dropdown box and two combo box, and i works fine! Thnx for your help!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard