Filtering dependent Enumlist Dropdown list

Hi there
I would appreciate some help or advise.
I have a Dependent Dropdown that should only display the relevant items as per previous selection.
I require an appropriate constraint to exclude items that are already issued from the Enumlist.
Thanks Francois.

Would you please elabotare your case a little. For example which column is an EnumList, what are other column types, do you have 3 different tables, etc?

1 Like

Hi @AleksiAlkio

Thank you for the reply!

Table 1 : Stock / inventory is received. (Normal Text, no Valid If)

Table 2: All have Valid If contraints. (=Table1[Tool Group]) ; (=Table1[Part Number]) ; (=Table1[Serial Number]) to create Dynamic conditional Dropdowns.

Once a Serial number (Which is unique) is issued, it should no longer be availbe on the list. I have tried a few constraints, but then the dependent Dropdowns don’t work.

Francois1_4-1718348190461.png

Table 3: To List all the Serial numbers in seperate rows. (Looping with actions)

Regards

Francois

1 Like

Hi there

Can anyone please assist?