Share via

SharePoint: Create email validation column in a list without code

  • Article

Introduction

This article will explain creating email validation list field without code.

Applies To

The examples demonstrated below are tested with and apply to the following versions of SharePoint:

  • SharePoint 2013
  • SharePoint 2016
  • SharePoint Online

Create Email validation field (mandatory field)

  • Go to Specific List Settings.
  • Click Create Column. Provide the column name. We have given field name StudentEmail.
  • Check the option "Require that this column contains information:" for mandatory field.
  • Provide the below formula for Custom Validation.
=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)))))
  • Enter custom validation message in User message: "Enter Valid Email Address."

Create Email validation field (optional field)

  • Go to Specific List Settings.
  • Click Create Column. Provide the column name. We have given filed name StudentEmail.
  • Uncheck the option "Require that this column contains information:" for an optional field.
  • Provide the below formula for Custom Validation.
=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))))))
  • Enter custom validation message in User message: "Enter Valid Email Address."