We would need more screenshots from you to know how you are setting it up.
Normally, if I want to check if a value is duplicated or not, I use a custom form, then create a relation from the input field to the list of existing values. If the relation is not empty, that means there’s a duplicate and we should not allow a form submission.