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.
Solved! Go to Solution.
Hi @JBankston ,
It seems that it's a limitation.
As a workaround, we can create a collection when the app loads and use it in items of combo box.
Best Regards,
Wearsky
Hi @JBankston ,
You could use the ClearCollect function on OnStart attribute so that the the collection will be created when the app loads.
Best Regards,
Wearsky
Hi @JBankston ,
It seems that it's a limitation.
As a workaround, we can create a collection when the app loads and use it in items of combo box.
Best Regards,
Wearsky
Thank you Wearsky,
I'm new to PowerApps. How would I go about making a Collection when the app loads?
Thanks,
Joseph
Hi @JBankston ,
You could use the ClearCollect function on OnStart attribute so that the the collection will be created when the app loads.
Best Regards,
Wearsky
Yes, thank you. I was able to figure it out. This is what I used to create the workaround.
User | Count |
---|---|
253 | |
125 | |
106 | |
50 | |
49 |