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
Solved! Go to Solution.
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
199 | |
97 | |
58 | |
51 | |
42 |
User | Count |
---|---|
262 | |
157 | |
84 | |
79 | |
57 |