Answered

Issues with cascading combo box

(0) Share

Report

Posted on by 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!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Ha-wold 32 on at

Like (0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Verified answer

Ha-wold 32 on at

Like (1)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No