How to prevent duplicate entries? I have set...

[Christian_Farle]

How to prevent duplicate entries?

I have setup a valid_if clause to prevent duplicate entries as follows: =NOT(IN([_THIS],SELECT(Users[User Mail],TRUE)))

This works great. Except that if I come back to this row later for further edits and then Save, the rule kicks in and blocks the save.

Any hints?

[Aleksi_Alkio]

https://plus.google.com/114351284024459899049/posts/7eb2gCsnb27 plus.google.com - TIP OF THE WEEK - Validation Many of you have asked how to add a validation … TIP OF THE WEEK - Validation Many of you have asked how to add a validation … plus.google.com

[Kanha_PM_Office]

Hi Aleksi,
Sadly, this link is invalid as Google+ is no longer available.

“Google+ is no longer available for the consumer (personal) and brand accounts”

https://plus.google.com/114351284024459899049/posts/7eb2gCsnb27

Thank you.

[Lynn]

Hi @Kanha_PM_Office Check out this Thread

Valid if expression Questions

I am using a Valid If expression to flag up a duplicate entry which works great. NOT(IN([PONumber], SELECT(Customer Orders[PONumber], [CustName]=[_THISROW].[CustName]))) The problem I have is if I go back and need to edit the row, the duplicate warning flags up and prevents me from saving any changes. What am I missing?

[Kanha_PM_Office]

Thank you Lynn!

[Christian_Farle]

HA! Proof that I am definitely A.D.D : I had done +1 on the initial post… Thanks Aleksi!