While editing a record, check to see if an email is in another sheet

[Daryl_Zernick]

Hello,

While entering a new record or editing an old one, I want AppSheet to tell me if an email exists in another sheet. Below is what I thought would work, but it doesn't seem to be checking as emails I have entered are in the other sheet.

IN(UPPER(IDKey[Email]),LIST(UPPER(StateOfMichiganCompleted[Email Address])))

Your suggestions are very much appreciated!

Daryl

p.s. @Marc_Dillon something tells me you'll have the answer 🙂

[AleksiAlkio · Accepted solution]

Try something like..

IN([Email],StateOfMichiganCompleted[Email Address])

[Daryl_Zernick]

Thanks @AleksiAlkio!

[RedVox]

I believe that StateOfMichiganCompleted[Email Address] is already a list, so perhaps this will work if you just eliminate the List function.