Multiline Text box limit number of words

Question

Hi All,

SharePoint Modern lists display takes lot of space when we have more data in Multiline text boxes.

Is there any way we can limit the number of Characters display in List view, so that we can overcome huge gaps between list item entries.

Appreciated if any suggestions.

Answer 1

Hi @Krishna Sandeep Sangani,

You can implement a visual indicator or validation to enforce a character limit using JSON formatting. Here’s an example JSON snippet to truncate a multiline text field to 100 characters:

{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
    "elmType": "div",
    "txtContent": "=substring(@currentField, 0, 100) + if(length(@currentField) > 100, '...', '')",
    "style": {
        "white-space": "nowrap",
        "overflow": "hidden",
        "text-overflow": "ellipsis"
    }
}

Please refer to the document

https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

---

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.

Answer 2

This is a rich text column, when we add above JSON in formatting it is showing <div class="Externalclass">.

Can we change formula to overcome those div tags?