When I turn on "Allow Searching" on my combobox, I don't have any available values. Turning it off shows all my options in the drop down.
I believe this has something to do with my [Items] having a non-delegable in the formula.
The formula is:
SortByColumns(Filter(Buildings, !IsBlank(SFCP)), "SFCP", Ascending)
The non-delegable part being the !IsBlank part. I don't know how else to write that though. I need to filter the list so that only when there's data in the SFCP column it shows the value in the combobox.
The really annoying part is that SHOULD be delegable!
Edit: Just to clarify, removing the SortByColumns does not affect anything. I still get a delegation warning on the ! part and it still returns no values when allow searching is enabled.
Solved! Go to Solution.
I tried to reproduce your issue using a nondelegatable filter and it worked for me. Did you check the fields to make sure they are correct? I have noticed that if you make a change to the items property of the Combobox, they revert back to a default.
It does. That works correctly. I did a ClearCollect with my exact formula(including the SortByColumns part) and then in my combobox I set the Items to just the collection name. I enabled searching and both work.
I'm going to call your post a solution, but this definitely seems like a bug.
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021