Forum Discussion
Solved
Set max character limit in Lists multi-line column
Hello, I have a multi-line column in a Microsoft Lists list and users are putting too much text in it. I would like to set a maximum character limit to prevent this (for example 500 characters)....
laser132217 the only out-of-the-box way to do this that I know of is to:
- create the column as a single line of text column
- set the validation settings to =LEN(yourcolumn)<500
- change the column type to multiple lines of text
The validation will still be applied even though it is now a multiple lines of text column.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Hi Rob,
Thank you for your help. Can I clarify whether the validation is a column validation or a list validation?
Thanks
Tom
Thank you for your help. Can I clarify whether the validation is a column validation or a list validation?
Thanks
Tom
laser132217 you do this in list settings -> validation settings
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- That’s great and works. Thanks so much.