Combo Box that filters to the selection in another Combo Box with lookup/filter/sort

[BPNJMC1]

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.

• bpn.Referrals table = ReferralKey, ProgramNameKey, ProgramSubtypeKey, ... [other fields]
• bpn.Programs table = ProgramKey, ProgramName, ProgramIsActive, ... [other fields]
• bpn.ProgramSubTypes table = ProgramSubTypeKey, ProgramSubtypeName, ProgramSubtypeIsActive, ...[other fields]

I'm trying to get Program Subtype combobox (crdProgramSubtypeKey_r / cboProgramSubtypeKey_r) to:

• continue to display the ProgramSubtypeName and save the ProgramSubTypeKey
• filter to the subtypes for the selected program (crdProgramKey_r / cboProgramKey_r)
• search the ProgramSubtypeName using StartsWith
• sort alphabetically on the ProgramSubTypeName

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

[BPNJMC1 · Accepted 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}

[v-albai-msft]

Hi @BPNJMC1 ,

Glad that I can help you. And also thanks for your sharing here😁

Best regards,

Allen