Answered

Combo Box Search Function Not Working Properly

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm using the below formula in a Combo Box. Data source is an SP Library. The folder names appear in the CB and I can scroll down and see all of them. Problem I'm having is that when I set the CB to Allow Searching = On. I get a blank search box in the CB, folder names are no longer visible and the search function doesn't work.

ComboBox.Items = Sort(Filter('SP Library','Folder path' = "Folder/Sub Folder/",IsFolder = true),Name,Ascending)

Primary Text = Name

SeachField = Name

I have a delegation warning but the number of folders in the library is < 200...

Any help with this matter would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

It seems that it's a limitation.

https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-combo-box#key-properties

As a workaround, we can create a collection when the app loads and use it in items of combo box.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you Wearsky,

I'm new to PowerApps. How would I go about making a Collection when the app loads?

Thanks,
Joseph

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @Anonymous ,

You could use the ClearCollect function on OnStart attribute so that the the collection will be created when the app loads.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, thank you. I was able to figure it out. This is what I used to create the workaround.

Was this reply helpful? Yes No