Create Email validation field (optional field)

Question

Hello,

I wanted to validate a simple text column with email in the SharePoint online list and found a formula but it does not work. I get an error: the syntax is not correct. I tried to change the language setting on the SharePoint website, but it still does not work.

formula:

=IF(LEN(StudentEmail)<=0,TRUE,AND(ISERROR(FIND(" ",StudentEmail,1)),IF(ISERROR(FIND("@",StudentEmail,2)),FALSE,AND(ISERROR(FIND("@",StudentEmail,FIND("@",StudentEmail,2)+1)),IF(ISERROR(FIND(".",StudentEmail,FIND("@",StudentEmail,2)+2)),FALSE,FIND(".",StudentEmail,FIND("@",StudentEmail,2)+2)<LEN(StudentEmail))))))

site from where I found the formula:

SharePoint: Create email validation column in a list without code - TechNet Articles - United States (English) - TechNet Wiki (microsoft.com)

Answer 1

Hi,

The column is of plain text type and its name is Email, in the formula the name was StudentEmail, I changed the name to email and in the formula too, but even using the original name it doesn't work (StudentEmail)

I know there is a column of type Person/Group but as they are external emails this field does not serve us. That's why I'm using the plain text field, and I'm trying to do this validation to prevent other things from being informed in this field.

Best Regards

Peterson

Answer 2

HPeterson Henrique B. dos Santos(kate.wilson),

Your screenshot shows Email. May I ask if your column is named Email? At the same time, please give us some time to test. Thank you for your understanding.

Tin

Answer 3

Hi, Tin,

This error is in the formula field in the sharepoint lists, this error is not related to Power Automate follows a print of the error, this formula was taken from an official microsofit website, I sent the reference in my previous question.

Best Regards

Peterson

Answer 4

HPeterson Henrique B. dos Santos(kate.wilson),

Thank you for posting in this Answer Community.

Sorry that I don’t find any related information about this issue.

To avoid sharing any incorrect information, it’s recommended to post your question in the Technet forums (microsoft.com)for a

better help.

Thank you for your understanding and efforts.

Best Regards,

Tin