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:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kazanskyi ,

What type of field is CAT_TYPE ? If a Choice or Lookup column

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

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

Was this reply helpful? Yes No
Kazanskyi 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz,

In SharepointList settings CAT_Type is a regular string.

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kazanskyi ,

Assuming the drop-down selection exactly matches the CAT_Type Text field, the issue is that there is potential for a Delegation issue on Searching (Power Apps does not know how big the list will get) - If the filtered outcome is never going to be bigger than your Delegation limit, you can do this

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

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

Was this reply helpful? Yes No
Kazanskyi 19 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Kazanskyi 19 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Kazanskyi ,

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

Was this reply helpful? Yes No
Kazanskyi 19 on at

Like
a
(0)

Report
Copy link

Link copied!

All seems correct. Here is a screenshot.

Please correct me if that's not what you mentioned.

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

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

Was this reply helpful? Yes No
Kazanskyi 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, CAT_NAME is a text field.
Unfortunately, it did not help.

Was this reply helpful? Yes No