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

Question

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?

Answer 1

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.