How to prevent Sharepoint from truncating List values?

Michael Boudreau 20 Reputation points
2024-01-12T17:02:51.6533333+00:00

I have a Sharepoint List created from an Excel document. Except for the first column in the list (Title), all the other columns are defined as Multiple Lines of Text. Sharepoint is truncating the display of some values in these columns: Sharepoint truncates display

How can I stop this from happening? I want users to see the full content of every value in the list.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,173 questions
{count} votes

Accepted answer
  1. Ling Zhou_MSFT 21,240 Reputation points Microsoft Vendor
    2024-01-15T03:04:34.48+00:00

    Hi @Michael Boudreau,

    Thank you for posting in this community.

    Since the Multiline Text column can store up to 63,999 characters, SharePoint collapses the contents of the column by default. You can try using JSON to modify the style of the column display. It will display everything in the column adaptively based on the length of your column's content.

    Here are steps:

    1.Select one column > Column settings > Format this column.

    User's image

    2.Select Advanced mode and copy the following JSON code. Click Save when you are done.

    User's image

    {
      "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
      "elmType": "div",
      "txtContent": "@currentField",
      "style": {
        "white-space": "normal",
        "padding": "10px 0"
      }
    }
    

    enter image description here

    Here is the result:

    User's image


    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.