Hi! Iโm building an app where the last dependent dropdown should return error if the value has been already used before. Iโve seen a way to prevent duplicates with list expressions but since itโs a dependent dropdown, itโs already using the โValid_Ifโ field to reference another table. How can I accomplish setting a rule to invalidate values that have already been used?
The formula Iโm using in Valid_If is: Base[Clave Participaciรณn (CP)]
Where โBaseโ is the sheet refernced to filter this field (called simply โClaveโ) based on the election on the previous column. And โClave Participaciรณn (CP)โ is the unique value stored in the referenced table.
Thanks in advance
Have you tried to use Suggested_Values and then you can use the validation independently?
Is it using Suggested_Values for validation of duplicates or for referencing the filtered options?
Try to use Base[Clave Participaciรณn (CP)] in Suggested_Values and then write something like AND(TRUE,NOT(IN([_THIS],TableName[Clave Participaciรณn (CP)]))) in Valid_If.
User | Count |
---|---|
42 | |
28 | |
24 | |
22 | |
13 |