Cascading Dropdown Woes!

[Matt_G]

Hi All,

Newbie here...I've seen a number of threads regarding cascading dropdowns, but unable to see my specific issue replicated, hence the new thread (apologies if i have missed it!)...

I have attached my data set of which i have imported into a SharePoint list. 

My 1st dropdown, appears fine using the following: 

Sort(Distinct('EMC-Hall-Zone-Operation Mappings',Hall),Result)

And my 2nd level looks fine using the following: 

Distinct(Filter('EMC-Hall-Zone-Operation Mappings', Hall = drp_hall.Selected.Result),ZONE)

Where my issue is coming is in my 3rd dropdown. From what i can see, using the below, it doesn't appear to take into account the 1st drop down result:

Distinct(Filter('EMC-Hall-Zone-Operation Mappings', ZONE = drp_zone.Selected.Result),Operation)

I'm wondering if that because for example Zone 1 (2nd dropdown) is referenced in multiple Halls (1st Dropdown), that the Operation dropdown (3rd dropdown) is showing ALL entries in the data source referring to Zone 1 (across all halls!)...

This may sound a bit mental, well, my eyes are stinging...Just hoping it makes sense to someone else!

Many thanks in advance.

[stephielapugh]

Hi Matt,

I had a similar use case (frustration), and this is a generic snippet of what worked for me.

This is the code for the third ddl. Edit per your tables, fields, etc. Can be extended beyond by adding additional "&&" statements.

Sort(
    Distinct(
    Filter(
        source_table_name, 
        first_ddl_id=ddl_name1.SelectedText.Value &&
        second_ddl_id=ddl_name2.SelectedText.Value
    ), 
    display_field_name
    ),
    Result
)

Good luck! Let us know what works! 

[stephielapugh]

This is the source that helped me: Power Apps - Cascade Drop Down List Using Distinct - YouTube

Be sure to listen to his warning/caveat at the end about maximum records!

[RandyHayes]

@Matt_G 

Actually...it is showing data (are you surprised?). 

The reason I say that is because you have a dropdown list with a scroll bar.  That means it has records, but that you are not displaying a field in it that has any values.

So, click on the Edit fields in the properties for that control and set the display field to be the one you want to display.

[Matt_G]

Well, what more can i say apart from a massive heart felt thank you for your guidance and persistence! We are officially working! I can't thank you enough, my 1st time in the community, and you've smashed it!! 

Thank you as well @SagarVIS96 @stephielapugh for your inputs, i'm sure ill be back again soon!! 🙂

[RandyHayes]

@Matt_G 

Very good!!  Glad all is working for you now and that your first posting in the forum has been a good one.  We are a pretty responsive community here, so you can always post questions as you have them.  We all love PowerApps!! 😁

[iamjoydeepaec]

content remove