question

Spawn10-0581 avatar image
0 Votes"
Spawn10-0581 asked AllenXu-MSFT answered

How do I prevent a user from entering an email address in a SharePoint list column?

I have a multi line text column in a SharePoint list and I want to prevent users from entering email addresses into that column. Is there a way to use column validation to prevent the entry of an email address? I do not want to use any customization.
Thanks for the help.

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenXu-MSFT avatar image
0 Votes"
AllenXu-MSFT answered

Hi @Spawn10-0581,

No, it is impossible. Column Validation feature is not supported in a multiple line of text column. Only the following field types can be validated with the Column Validation feature: Single Line of Text, Choice, Number, Currency, Date & Time. If a single line of text column is an alternative for you, you can use the formula =IF(ISERROR(FIND("@",[ColumnName])),TRUE) to restrict user not to type in strings contains "@" in that field.

If you persist on a multiple line of text column, currently you have to inject JS code into SharePoint Online using SPFX. Or you can share your user voice here: Share. Vote. Discuss. It is a place for customers provide feedback about Microsoft SharePoint products. What's more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.


If an Answer is helpful, please click "Accept Answer" and upvote it.
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.