Im creating a form and I want a column to be valid only if the value input matches a list in another table, but I donยดt want the user to select from a dropdown or have any list of valid inputsโฆ
Use case: I have a list of customer with national IDs and if a person fills the form and his national ID does not match the list, I want to show a Not valid message.
Thanks!
You could try an expression something like below in the valid_if
IF(IN([_THIS], TableName[National ID]), TRUE, FALSE)
Or like AND(TRUE,IN([_THIS],Table[National ID]))
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |