Share
ReportHello,
I'm hoping one you fine individuals may be able to help with an issue I'm experiencing with one piece of my app's functionality.
I have a series of cascading dropdowns connected to 2 SharePoint Lists and a Dataverse Table.
Sharepoint List 1 - The main list for the app. Information is populated or edited on this list from the app.
Sharepoint List 2 - A list containing information I populate List 1 with based on a dropdown selection within the app.
Dataverse Table 1 - A table containing a list of our products and product hierarchy.
The way the app works, my users select an account number from ComboBox1 (items are populated from a column in Sharepoint List 1 containing lookup values from Sharepoint List 2). This feeds a vendor number to a TextLabel1. ComboBox2 filters "Brand Names" from Dataverse Table 1 based on the vendor number in the text label. Then ComboBox3 filters "Family Names" from Dataverse Table 1 based on the selected value(s) in Dropdown 2 unless it's empty, in which case it filters the "Family Names" from Dataverse Table 1 based on the vendor number in Text Label 1.
So - User selects account number in ComboBox1. User selects desired brand(s) from ComboBox2 (available items filtered on VendorNumber). User selects family(s) from ComboBox3 (available items filtered on ComboBox2 selected items.
Everything works fine when the user starts with new inputs, in both a new form or in the edit form. The problem comes when the user selects an item to edit, then tries to click into ComboBox3 to change the selections. The original selections remain in the box, but the item property does not seem to populate the other available options for them to select from. If they delete the original selections in ComboBox3 and in ComboBox2, the user can reselect everything and go down the selection list as normal, but adding items to the existing selection in ComboBox3 does not work.
Anyone have any ideas?
ComboBox Properties below:
ComboBox2 -
DefaultSelectedItems: Parent.Default
Items: SortByColumns(Distinct(Filter(DataverseTable1,VendorID=TextLabel1),BrandName),"Value")
ComboBox3 -
DefaultSelectedItems: Parent.Default
Items: SortByColumns(If(IsBlank(ComboBox2.Selected.Value),Distinct(Filter(DataverseTable1,VendorID=TextLabel1),FamilyName),Distinct(Filter(DataverseTable1,BrandName in ComboBox2.SelectedItems),FamilyName),"Value")
My cascading dropdowns go a few fields deeper, but I think if I can get this piece figured out I'll be able to get the rest as well since they are built with very similar logic.
All responses (
Answers (
356
