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.