Hi Everyone,
My first Power App, so I have a basic question. I have two combo boxes on a form:
Both are searchable, single selection, currently display a list of Program names and Program Subtype names, and save the corresponding selected key/id to a Referrals table.
I'm trying to get Program Subtype combobox (crdProgramSubtypeKey_r / cboProgramSubtypeKey_r) to:
I'm having trouble figuring out the syntax and which properties to change. The current settings for the two combo boxes is pasted below.
Thanks,
J
Solved! Go to Solution.
I finally figured it out. Here's the solution:
ComboBox Items property =
Distinct(SortByColumns(Filter('bpn.ProgramSubtypes', ProgramKey = cboProgramKey_r.Selected.ProgramKey), "ProgramSubtypeName"), ProgramSubtypeName)
Card Update property:
LookUp('bpn.ProgramSubtypes', ProgramSubtypeName = cboProgramSubtypeKey_r.Selected.Result).ProgramSubtypeKey
ComboBox IsSearchable property =
true
Thank you to @v-albai-msft for providing the syntax for this property:
Combo Box DefaultSelectedItems property =
{Result:LookUp('bpn.ProgramSubtypes', ProgramSubtypeKey=Parent.Default).ProgramSubtypeName}
I finally figured it out. Here's the solution:
ComboBox Items property =
Distinct(SortByColumns(Filter('bpn.ProgramSubtypes', ProgramKey = cboProgramKey_r.Selected.ProgramKey), "ProgramSubtypeName"), ProgramSubtypeName)
Card Update property:
LookUp('bpn.ProgramSubtypes', ProgramSubtypeName = cboProgramSubtypeKey_r.Selected.Result).ProgramSubtypeKey
ComboBox IsSearchable property =
true
Thank you to @v-albai-msft for providing the syntax for this property:
Combo Box DefaultSelectedItems property =
{Result:LookUp('bpn.ProgramSubtypes', ProgramSubtypeKey=Parent.Default).ProgramSubtypeName}
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
166 | |
94 | |
64 | |
63 | |
60 |
User | Count |
---|---|
238 | |
162 | |
95 | |
85 | |
81 |