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, a distinguished professional, boasts an impressive track record as a Microsoft MVP, having achieved this prestigious recognition for the eighth consecutive year since 2015. With an extensive career spanning over 18 years, Adnan has honed his expertise in various domains, notably excelling in SharePoint, Microsoft 365, Microsoft Teams, the .Net Platform, and Microsoft BI. Presently, he holds the esteemed position of Senior Microsoft Consultant at Olive + Goose. Notably, Adnan served as the MCT Regional Lead for the Pakistan Chapter from 2012 to 2017, showcasing his leadership and commitment to fostering growth within the tech community. His journey in the realm of SharePoint spans 14 years, during which he has undertaken diverse projects involving both intranet and internet solutions for both private and government sectors. His impact has transcended geographical boundaries, leaving a mark on projects in the United States and the Gulf region, often collaborating with Fortune 500 companies. Beyond his roles, Adnan is a dedicated educator, sharing his insights and knowledge as a trainer. He also passionately advocates for technology, frequently engaging with the community through speaking engagements in various forums. His multifaceted contributions exemplify his dedication to the tech field and his role in driving its evolution.
No Comments