ComboBox Search Doesn't Work while Selection Works Ok

(0) Share

Report

Posted on by Kazanskyi

My data sources are Sharepoint Lists.

Here is a formula I use:

Filter([@SECurity_CATegories_PBI], CAT_TYPE = ComboBox2_1.Selected.Value)

It works perfectly with "Allow Searching" turned off, but once it's on, I can only see an empty field.

I thought it might be some delegation errors so I changed it to

Filter([@SECurity_CATegories_PBI], StartsWith(CAT_TYPE , ComboBox2_1.Selected.Value))

But nothing changed.

Help!

Categories:

General Questions

Using Apps Using Formulas

All responses (13)

Answers (1)

WarrenBelz 146,645 Most Valuable Professional on at

Like (0)

Report

Re: ComboBox Search Doesn't Work while Selection Works Ok

@Kazanskyi ,

As you have not mentioned IDK in any of your code, marking that as a solution is not really helpful.
Verified answer

Kazanskyi 19 on at

Like (0)

Report

Re: ComboBox Search Doesn't Work while Selection Works Ok

I removed the combo box and created a new one.
It solved the issue.
IDK what was the problem but maybe it will help anyone a swell
WarrenBelz 146,645 Most Valuable Professional on at

Like (0)

Report

Re: ComboBox Search Doesn't Work while Selection Works Ok

@Kazanskyi ,

Something else is wrong here as based on what you have posted, it simply should work.
Kazanskyi 19 on at

Like (0)

Report

Re: ComboBox Search Doesn't Work while Selection Works Ok

Yes, CAT_NAME is a text field.
Unfortunately, it did not help.
WarrenBelz 146,645 Most Valuable Professional on at

Like (0)

Report
Re: ComboBox Search Doesn't Work while Selection Works Ok

@Kazanskyi ,

Probably my last shot as based on what you posted, it simply should work - I assume CAT_NAME is a Text field.

With( { _Data: Filter( SECurity_CATegories_PBI, CAT_TYPE = ComboBox2_1.Selected.Value ) }, Sort( _Data, CAT_NAME ).CAT_NAME )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Kazanskyi 19 on at

Like (0)

Report

Re: ComboBox Search Doesn't Work while Selection Works Ok

All seems correct. Here is a screenshot.

Please correct me if that's not what you mentioned.
WarrenBelz 146,645 Most Valuable Professional on at

Like (0)

Report

Re: ComboBox Search Doesn't Work while Selection Works Ok

@Kazanskyi ,

Have you displayed the correct field in your combo Box (Edit icon at right)
Kazanskyi 19 on at

Like (0)

Report

Re: ComboBox Search Doesn't Work while Selection Works Ok

Hi @WarrenBelz,

Ok, I got it. Distinct values are unnecessary as all the values in the column CAT_NAME are unique. I am testing all the options with no clever ideas.
Do you have anything else on your mind as to why the search doesn't work?
WarrenBelz 146,645 Most Valuable Professional on at

Like (0)

Report

Re: ComboBox Search Doesn't Work while Selection Works Ok

@Kazanskyi ,

If you want Distinct values, you might try the process from this blog of mine.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Kazanskyi 19 on at

Like (0)

Report

Re: ComboBox Search Doesn't Work while Selection Works Ok

Thank you for the idea.
The search field is still empty, unfortunately.

I tried to change the formula to distinct values, but it did not help as well.
Distinct(Filter([@SECurity_CATegories_PBI], CAT_TYPE = ComboBox2_1.Selected.Value),CAT_NAME)

With isSearchable turned off, both options work great.