Solved: Validate by repeated Serial Number - Page 2

Marcos1 · 08-22-2019 02:23 AM

Hello Comunity
It’s there a way to prevent a user from adding an item with a Serial Number that already exists in another row?
The idea is when adding a new item to an existing list, in a specified column, verified it that number or text or serial number already exists and show an Information that “It already exists, please edit that one”

Thank you so much

Suvrutt_Gurjar

Hi @Marcos,

Yes the expression needs to be put in the Valid_if section of the column that you do not wish to be duplicated.

In general, the expression should look like below

NOT(IN([_THIS], SELECT(Your Table Name[SERIAL NUMBER], NOT(IN([Key column name of your table], LIST([_THISROW].[Key column name of your table])))))),

View solution in original post