Forum Discussion

Kevin_Bullit_Bryan's avatar
Kevin_Bullit_Bryan
Copper Contributor
May 13, 2024

Column Validation Single Line Text with blank or multiple email addresses separated by semicolon

I have a SharePoint Online list with a single line text column named Cc... Email (i didn't create that one) that I have been trying to formulate the validation to only allow valid email addresses. The address field can be empty, single entry or multiple entries separated by a semicolon. I've tried everything including chatgpt and copilot to find a formula that will work correctly. Nothing seems to work and it seems like this should be fairly simple. What am I missing?


=OR(
ISBLANK([Cc... Email]),
AND(
NOT(ISERROR(FIND(" ", [Cc... Email]))),
ISERROR(FIND(";;", [Cc... Email])),
ISERROR(FIND(";", [Cc... Email], LEN([Cc... Email])-1)),
ISERROR(FIND("@", [Cc... Email])),
ISERROR(FIND("@", [Cc... Email], FIND("@", [Cc... Email])+1)),
ISERROR(FIND(".", MID([Cc... Email], FIND("@", [Cc... Email])+1, LEN([Cc... Email])))) = FALSE,
ISERROR(FIND(" ", MID([Cc... Email], FIND("@", [Cc... Email])+1, LEN([Cc... Email]))))
)
)

No RepliesBe the first to reply

Resources