SOLVED

Set max character limit in Lists multi-line column

Copper Contributor

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). Can anybody advise how I would do this? 

Thanks

5 Replies
best response confirmed by laser132217 (Copper Contributor)
Solution

@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

@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.

@RobElliott- hello! I was wondering if this can be applied to more than one column.

1 best response

Accepted Solutions
best response confirmed by laser132217 (Copper Contributor)
Solution

@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)

 

View solution in original post