Data validation is the process of ensuring that user input is correct and useful information. Email validation is one of the most know validation format and there are too many regex or custom scripts available to validate the email value. But if we discuss about SharePoint list, its not the case.
In a SharePoint list, we can add column validation on text field but not all available Regex or custom formulas working as required. Today I am sharing a working email validation formula and steps to apply on your SharePoint list.
Steps to Apply Email validation in SharePoint List
- Create a text field in your SharePoint list and Name it Email.
- Click on Gear Icon from top right and click on List settings.
- Under Columns, click on Email, this will open the Email column edit page
- Scroll down on the page and expand the Column Validation, it will show you the validation formula section
- Copy below email validation formula in Formula Pane and also enter the User message.
=IF(LEN(Email)<=0,TRUE,AND(ISERROR(FIND(" ",Email,1)),IF(ISERROR(FIND("@",Email,2)),FALSE,AND(ISERROR(FIND("@",#NAME?,FIND("@",Email,2)+1)),IF(ISERROR(FIND(".",Email,FIND("@",Email,2)+2)),FALSE,FIND(".",Email,FIND("@",Email,2)+2)<LEN(Email))))))- Save the changes and test it by adding a new item to the list.
One important thing is that this email validation will only apply on new items added to the form, not on the existing items.
Adnan is six time Microsoft MVP (Since 2015) with over 16 years of extensive experience with major expertise on SharePoint, SharePoint based development, Microsoft 365, Microsoft Teams, .Net Platform and Microsoft BI. He is currently working Sr Microsoft Consultant at Olive + Goose. He is MCT Regional Lead for Pakistan Chapter since 2012. He is working on SharePoint for past 12 years and worked on different intranet/intranet solutions for private & govt. sector majorly in United states and Gulf region and have experience of working with multiple Fortune 500 companies. He is a trainer, technology evangelist and also speaks in community forums.
No Comments