Issues with cascading combo box

[Ha-wold]

Hello guys, I am encountering an issue with the combo box on the app that I am currently developing using Share point as Data source.

Scenario: I have 2 combo boxes which the combo box 1 is showing the results from Column A correctly. Now with my combobox2, the results should be dependent based from the selected result in combobox1 and this is not happening.

Below is my code in Items Property for combobox2:

Sort(Filter(Distinct('SP Name', ThisItem.'Ticket Number' = DataCardValue24.Selected.Result),Not(IsBlank(Result))),Result)

However, if I use the following code below in my combobox2, it will return the results that I am expecting BUT it will not filter according to the selected value in combobox2:

Sort(Filter(Distinct('SP Name','Test ID'),Not(IsBlank(Result))),Result)

Please advise.

Thank you so much!

[RandyHayes]

@Ha-wold 

You second formula you presented is not basing itself on combobox 1 at all.  That needs to be added in.

So, based on your first formula, the formula would be:

Sort(
    Filter(
        Distinct(
            Filter('SP Name'
                'Ticket Number' = DataCardValue24.Selected.Result
            ),
            'Test ID'
        ),
        !IsBlank(Result)
    ),
    Result
)

As a general note, this formula is yet another trip to the datasource.  Cascading combo and dropdown controls is best done with the GroupBy function, but I am not seeing the Items property of your first combobox to be able to offer a suggestion for that.

I hope this is helpful for you.

[Ha-wold]

Hi @RandyHayes 

Thank you so much for your response. I actually tried the formula that you provided but it is still not showing the correct data based from the selection in combo box 1.

From my Sharepoint:

As for your question, below is the code in the combo box 1 property: 

Sort(Filter(Distinct('SP Name','Ticket Number'),Not(IsBlank(Result))),Result)

Please advise. Thank you!

[Ha-wold · Accepted solution]

This can be close. Updated my combo box2 formula to: 

Filter(Distinct(Filter('SP Name', 'Combo Box 1 ColumnName' = ComboBox2.Selected.Result),'ComboBox Two ColumnName'),Result)