Difficulty with Combobox

[yyc_ryan]

So I just discovered Powerapps, I'm trying to do a combo box to look up a job number out of a table in an on-premises SQL server.

The data source connects nicely. It defaults to display the "AFE" field from my table, which isn't what I want, but at least it's pulling data. Here's what I don't understand:

There's a property here called "Value" under the "Items" property. What is this supposed to do? Changing this seems to have no effect on the behaviour of the combobox. I want to display the "ClientJobSAPCode" field, but selecting it here has no effect. Am I missing or misunderstanding something here?

When I set Displayfields to ["ClientJobSAPCode"], I get the items I want in the dropdown. However, search doesn't work properly. It seems to still be searching the AFE field. I reasoned that I should set ["ClientJobSAPCode"] in the "SearchFields" property as well. Problem is, right after I enter that, it changes itself back to ["AFE"]. 

I seem to be able to set the SearchFields property to ["AFE", "ClientJobSAPCode"], which causes the combobox to search both of those fields. If I try to again edit this to remove "AFE", leaving only "ClientJobSAPCode", the property changes itself back to just "AFE".

This seems like such an odd problem, I feel like I'm missing something fundamental. Any ideas?

Thanks,

Ryan

[PallaviCloud-12]

Hello,

I am facing same issue. Actually I am using People/person field and connect to Office365Users to get user name. So how can I use ClearCollect in this case.

Please help. Thanks