Help with UserEmail

[Quality_Assuran]

Hi,

I tried to use this as the Valid IF for my useremail field in my User table.

not(in(USEREMAIL(), select(Users[User_Login_Email], [UserID] <> [_thisrow].[UserID])))

And this as my invalid error message

ifs(in(USEREMAIL(), select(Users[User_Login_Email], [UserID] <> [_thisrow].[UserID])),
concatenate(
"(",
[User_Login_Email],
") is already in the system"
)
)

I thought this would work but it throws up the error for all new submissions even though they are not on the list.

Can someone please help?

[Koichi_Tsuji · Accepted solution]

If you are on the new desktop UX mode (bunch of bugs still), then the workaround is 

ifs(in(USEREMAIL(), select(Users[User_Login_Email], [UserID] <> [_thisrow].[UserID])-list([_thisrow])),
concatenate(
"(",
[User_Login_Email],
") is already in the system"
)
)

but not funcy enough.