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). Can anybody advise how I would do this?
Thanks
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)
RobElliott- hello! I was wondering if this can be applied to more than one column.
RobElliott I too would like to do this, I've tried adding the other columns to this formula, adding additional formulae, but can't get it to work - Riza24 did you find out how?
found out how:
=AND(LEN([March Update])<500,(LEN([Jan Update])<500),(LEN([May Update])<500),(LEN([July Update])<500),(LEN([Sept Update])<500),(LEN([Nov Update])<500))
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
Tomlaser132217 you do this in list settings -> validation settings
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
