Filtering dependent Enumlist Dropdown list

[Francois1]

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.

[AleksiAlkio]

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?

[Francois1]

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. 

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

Regards 

Francois

[Francois1]

Hi there

Can anyone please assist?