Need to give alert in Enumlist

[Gunasuriya_Ravi]

I am having the column with Enumlist with Ref of employee table with key value of Email ID

I should not select my name in that column i need to give some alert as invalid

I tried with Email id <>USEREMAIL in if valid ,but its not working for me

Can you help me with this ?

[Marc_Dillon]

An Enumlist column will return a List type. So your valid_if probably needs to be something like this:

NOT( IN( USEREMAIL() , [_THIS] ) )

[Gunasuriya_Ravi]

I am getting an error with this.

[Marc_Dillon · Accepted solution]

Try:

FILTER( Employee , [Email ID] <> USEREMAIL() )

[Gunasuriya_Ravi]

Thanks,working.