SharePoint 2013 Only Allow .mil, .gov, or .edu email extension

JeanG1223 21 Reputation points

How can I use column validation (what is the validation/formula) to only allow email entered in a SharePoint list item to .gov, .mil, or .edu?

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,393 questions
{count} votes

Accepted answer
  1. Haoyan Xue_MSFT 14,531 Reputation points Microsoft Vendor

    Hi @JeanG1223 ,
    Here are steps:

    1. Create a single line of text column (Name email during testing)
    2. List setting-> Validation setting
    3. Enter the formula: =OR(RIGHT(email,LEN(email)-FIND(".",email))="edu",RIGHT(email,LEN(email)-FIND(".",email))="gov",RIGHT(email,LEN(email)-FIND(".",email))="mil")
      The demonstration results are as follows. When you create a new item, you can only enter the content with the suffix of .mil, .gov, and .edu. Otherwise, an error will be reported and the creation cannot be successful.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful