I have a view published with
list-1 in rows
list-2 in columns
list-3 in pages
list-4 in pages.
The dropdown for list-4 is dependent on item selection from list-3 and vice versa.
Filters are created for that but when applied, I couldn't see the option of Current context.
List 3 has A,B items
List 4 has a,b,c items
When user selects 'A' from list 3 selector, then the list-4 selector should show 'a', 'b' for selection but not 'c'.
When user selects 'B' from list 3 selector, then the list-4 selector should show 'b', 'c' for selection but not 'a'.
Filter is the Boolean input for list 3 * list 4
There is no relationship between list3 and list4 except for the input filter.
Is there a way to achieve it without creating a hierarchy list between list3 and list4?
Go to Solution.
You will have to create Valid Combination List of (List 3 and List 4)
Once you have that list create a SYS Module based on Valid Combination list and map the items. It can be many to many mapping
Create two properties in Valid Combination list - one formatted as L3 and another L4. Write the formula and pull the data from SYS module into properties
Last step would be to enable dependent dropdown in the Filter line item
View solution in original post
I think List 4 has to be dependent on List 3 and then you can enable the option of Dependent dropdown in List 4. See if below video helps.
Dependent Dropdowns - Anaplan Community
Is there any way if list 3 and list 4 are independent?