To localize the error message when the user enter the duplicated value to the key column

[Koichi_Tsuji]

On the localize pane, i could not locate the way to change the text to localize for the error message when the entry is duplicated by the user to the key column.

"There is already a row with the key xxxxx "

Can we change this text ? or need to raise the feature request?

[hcquadros]

Agreed

[Steve]

A workaround is to add a Valid If expression that can make the same determination. You can provide a customized message that way.

[Koichi_Tsuji]

Clever!

I put following expression into valid if

NOT(IN([_THIS], SELECT(user[Email], NOT(IN([Email], LIST([_THISROW].[Email]))))))

to check if the entry is duplicate or not, and it seems to be working. Testing by entering the exisitng value as new, but it returns original errors instead of custom error message which should have appear when failing valid if constrain.

What i m doing wrong?

[Fabian_Weller]

Even though this is a workaround, you would have to do this on every Key column in every table.