Solved: Enum list result depend on the previous Enum list - Page 2

Hossam_Khalil · 08-21-2020 06:31 AM

Hi all,

Can someone please support me if i want to make Enum list where it’s results are dependent on a previous Enum list, i have tried many things but it won’t work with me.

for example, if we have products where each product has many suppliers and the user can select multiple products in his request and also can select the suppliers, so i have enum list for products and when the user select his products, i need the second enum list which is for suppliers to be dependent on the products which were selected by the user.

when i try below expression in Data Validation the supplier enum list disappears and i don’t understand why?.

FILTER(Supplier, List([Product]) = Supplier[Product])

I would really appreciate your support or advice regarding above scenario.

Marc_Dillon

I think this will work:

FILTER( Supplier, COUNT( INTERSECT( [Products] , [_THISROW].[Products] ) ) = COUNT( [_THISROW].[Products] ) )

In other words, return the supplier if the number of common items between the selected list of products, and a suppliers list of products (count of intersect), is the same as the count of selected products.

View solution in original post