Answered

Cascading Combo Box Edit Form Issue

(0) Share

Report

Posted on by tagustin2020

Hello Warren,

I hope you are doing well. I'm having a cascading drop down issue on an Edit screen, I'm hoping you can help me out with. The form an employee fills out is on a separate screen in new mode. No issues at all with the cascading dropdowns there.

The edit screen is where I am running into issues. I want the app admins to be able to adjust the Category and Functional Area dropdowns in case the employee accidentally chose the wrong ones. The Category combobox seen below is editable, but the Functional Area dropdown is not. To be clear, they are both Combo Boxes as I want them to be Searchable. Multiple selections is turned off.

My primary list is called 'Oracle Help Desk Tickets'. A separate SharePoint list called 'Track Leads' holds the Category and Functional Area column data. The Category and Functional Area columns are single line of text type columns.

Edit Screen ComboBox SS.png

Category Data Card

Default: ThisItem.Category
Update: cbCategoryER.Selected.Result

Category Combo Box

Items: Sort(Distinct('Track Leads', Track), Result, SortOrder.Ascending)
DisplayFields: ["Result"]
SearchFields: ["Result"]
Default: {Value:ThisItem.Category}
DefaultSelectedItems: {Value:ThisItem.Category}
OnChange: Reset(cbFunctionalAreaER) - doesn't work to clear out Functional Area CB selection.

Functional Area Data Card

Default: ThisItem.'Functional Area'
Update: cbFunctionalAreaER.Selected.'Functional Area'

Functional Area Combo Box

Items: SortByColumns(Filter('Track Leads', Track = cbCategoryER.Selected.Result),"FunctionalArea")
DefaultSelectedItems: First(Table(LookUp('Track Leads', 'Functional Area'=Parent.Default)))
DisplayFields: ["FunctionalArea"]
SearchFields: ["FunctionalArea"]

Thank you,

Teresa

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

v-jefferni on at

Like (1)

Report
Hi @tagustin2020 ,

Please try below formulas (Distinct function will return a table with Value column now, released last weekend):

Category Data Card

Default: ThisItem.Category Update: cbCategoryER.Selected.Value

Category Combo Box

Items: Sort(Distinct('Track Leads', Track), Result, SortOrder.Ascending) DisplayFields: ["Value"] SearchFields: ["Value"] Default: {Value:ThisItem.Category} DefaultSelectedItems: {Value:ThisItem.Category} OnChange: Reset(cbFunctionalAreaER)

Functional Area Data Card

Default: ThisItem.'Functional Area' Update: cbFunctionalAreaER.Selected.'Functional Area'

Functional Area Combo Box

Items: SortByColumns(Filter('Track Leads', Track = cbCategoryER.Selected.Value),"FunctionalArea") //depending on what you want to populate in this combo box by default, below is the fist record with selected Category in the table. DefaultSelectedItems: LookUp('Track Leads', Category = cbCategory.Selected.Value) DisplayFields: ["FunctionalArea"] SearchFields: ["FunctionalArea"]

Best regards,

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report
@v-jefferni

Hello Jeffer,

Thank you for your help. I had to do a couple of adjustments to avoid red squigglies, but overall things are working better now. I am seeing options appearing in the Functional Area dropdown when the form is in edit mode. The only issue I am having is displaying what was chosen in the Functional combobox. During testing I changed my combobox selection and verified that the data was being written back to the SharePoint data source correctly. I just need to surface it in the form now.
Here is the latest version of the formulas:

Category Data Card
Default: ThisItem.Category Update: cbCategoryER.Selected.Value

Category Combo Box
I had to use Value in the Items or I got red squigglies - also, Track is the name of the "Category" column in the Track Leads SharePoint list which is why you see the adjustment there.
Items: Sort(Distinct('Track Leads', Track), Value, SortOrder.Ascending) Default: {Value:ThisItem.Category} DefaultSelectedItems: {Value:ThisItem.Category} DisplayFields: ["Value"] SearchFields: ["Value"] OnChange: Reset(cbFunctionalAreaER)

Functional Area Data Card
Default: ThisItem.'Functional Area' Update: cbFunctionalAreaER.Selected.'Functional Area'

Functional Area Combo Box
I had to use Result in the DSI or I got red squigglies.
Items: SortByColumns(Filter('Track Leads', Track=cbCategoryER.Selected.Value), "FunctionalArea") Default is currently empty - I tried entering Parent.Default and {ThisItem.'Functional Area'}, but got red squigglies. DefaultSelectedItems: LookUp('Track Leads', Track=cbCategory.Selected.Result) DisplayFields:["FunctionalArea"] SearchFields: ["FunctionalArea"]

Thank you again for your help! Teresa

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @tagustin2020 ,

For Combo box control, Default property mostly needs nothing. Do you have any other issues in the App for the cascading related problem?

Best regards,

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report

@v-jefferni

Hello Jeffer,

No other issues, just this one. Let me know if there are any other settings you want me to check.

Teresa

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (2)

Report
Hi @tagustin2020 ,

Could you please tell what are the types of the two columns in 'Oracle Help Desk Tickets' list? If they are both text columns as well, DefaultSelectedItems of Functional Combo box would be:

LookUp('Track Leads', Track = ThisItem.Track &&'Functional Area' = ThisItem.'Functional Area')

The criteria Track = ThisItem.Track is unnecessary if functional area column in Track list includes unique values. In this formula, ThisItem.Track and ThisItem.'Functional Area' refer to the values of selected item from 'Oracle Help Desk Tickets' list, without ThisItem, they are columns in Track list.

Best regards,

Was this reply helpful? Yes No
tagustin2020 on at

Like (1)

Report

@v-jefferni

Hello,

They are both Text columns and the formula you provided resolved the issue.

Thank you!
Teresa

Was this reply helpful? Yes No