Cascading Combobox - Not possible?

[skylitedave]

Hi All

I am following the guidance to move away from Dropdowns and to Comboboxes...

I am trying to create cascaded comboboxes like we can with Dropdowns

I am getting the dreaded "blue dot of death" when I invoke a filter in the items in a combobox

Can you filter items in a combobox or no?

Here are 2 variations on the formula I am trying to use - both produce the "blue dot of death"

This formula is in the Items Property of a ComboBox 

• Filter(Opportunities, AccountId = Value(Proj_Detail_Account_ID_Value.Text))
• Filter(Opportunities, AccountId = 3)

I can use this same formula in the items in a dropdown - no problem

Anyone have any experience with this?

[leyburn19]

The blue dot of death is simply telling your list is not deleagable over the 500 (but can be set to 200).  It is not an error

The way I do dropdowns and combos is to actually create seperate small SP lists that combos use,  not the parent list.  I actually do not have any combos or dropdowns in the master SP lists as they prove to be problematic for new data etc.  I just keep them as a simple text field.  On a form that I want to use for that list and in teh datacard I add a control like a combo or a dropdown. 

I set its defaults to be ased on the Parent.default so it gets the foems field value if it exists.  In the items I create the dropdown based an a collection that is based on the list that has the dropdown data.  This make load time of the view fast asthe list are not trying to get distinct data from the the parent list any more

Finally in teh datacard I then set the actual  list field default to equal teh dropdown value.  So if already had data it would still be the same.  When you change the dropdown it changes the field.  I make that field invisible to the user.

No that you use controls that are not bound to the master list,  cascading is so much easier

[skylitedave]

Not workable since I have thousands of items in the lists

Cascade dropdowns are fine...   no blue dot of death with the exact same function

Seems like Comboboxes dont have the same scalability as dropdowns when it comes to filtering values presented to a user

I will log an idea if I dont hear anything from anyone else...  

We need this scalability in many situations - I have a customer with over 250,000 entries in a list and filtering is lightning fast using a dropdown in Powerapps.  Not good if we cant do the same with Combobox controls... especially given the guidance that we should be moving away from Dropdowns using a lookup to ComboBox controls as described in the powerapps team blog

https://powerapps.microsoft.com/en-us/blog/powerapps-update/