Search disables combobox

[amangrum]

After lots of troubleshooting, I got a combobox to almost work the way I want it - all blank entries filtered out and the entries are sorted alphabetically using the function below. However, this only works when search property for the combobox is disabled (IsSearchable=false), when search property is enabled (IsSearchable = true) nothing shows in the combobox and any text entered does not pull any item results. (images below) 

The end goal is to have the list filter out blank entries, sort non-blank entries alphabetically, and be searchable.

Items = Filter(Sort('Sample Data for signout',Teacher),Teacher)

Sample Data for signout --> SP list name

Teacher --> column title for entries in the combobox

Fields are set correctly - although for some reason the SearchField is called "field_3" which is the actual URL name given by SP and matches with "Teacher" field for Primary text.

With search turned off:

With search turned on:

[LuisArellano]

If "field_3" matches the field you are using to display data and that is what you want to use for searching. What happens if you select "Teacher" in the SearchFiled, do you get the same or a different issue?

[v-hanytian-msft]

Hi @amangrum ,

Based on your description, we reproduce your problem.

There is an explain from the Document.

Combo box control in Power Apps - Power Apps | Microsoft Learn

To solve this problem, you can use the ClearCollect() formula to collect the data you want and put the collection into the items of the Combo Box.

We create data source like this.

OnStart:

ClearCollect(Col,Filter(Sort(Combo,!IsBlank(Teacher)),Teacher))

Cilck “Run OnStart”

Set Combo Box as you offered.

The Items of Combo Box:

Col

After fill the formula into the correct place, we suggest you save the app and refresh the website.

After testing, it worked.

Hope this will help you.

Best Regard,

Tina

[amangrum]

I appreciate that suggestion, but for some reason there is something in the function that causes the SearchField to have a different list of dropdown options compared to the Primary text. Not sure why or what the trigger is for changing (I'm pretty new to Powerapps and "coding" in general), but different functions would cause different options for the fields - sometimes no options, sometimes only option is "value", and sometimes the options have a long list with "teacher" and other times a short list with "field_3". 

[amangrum]

Thank you for the suggestions. I have set everything exactly as you have described and the filter is working, the search is working; however, the list is not sorting in alphabetical order. Any thoughts?