How to make SharePoint List Multiline column only show the first few lines

Question

I don't want all text to display on the SharePoint List multiline column but I don't know how to make it show less text as a preview. I want the text form to be rich text and I found that if I added a scroll, it did not fit with rich text.

Answer 1

If you want to display a preview of text in a SharePoint List multiline column without showing the entire content, you can use a calculated column to achieve this. Here's a general approach:

Create a Calculated Column: Create a new calculated column in your SharePoint List.

Use a Formula to Extract Preview: In the formula for the calculated column, you can use a combination of functions to extract a portion of the text as a preview. For example, you can use the LEFT function to extract the first few characters of the text.Here's a sample formula:

=LEFT([YourMultilineColumn], 100)

This formula will extract the first 100 characters from your multiline column. You can adjust the number "100" to fit your desired preview length.

Set the Calculated Column to Display as Rich Text: Make sure to configure the calculated column to display as rich text if you want to maintain the rich text formatting.

Hide the Original Multiline Column: Optionally, you can hide the original multiline column from the list view if you don't want it to be displayed alongside the preview.

By using this approach, you can display a preview of the text in your multiline column while still maintaining the rich text formatting. Users can then click on the preview to view the full content if needed. Adjust the formula and preview length as necessary to fit your requirements.

Answer 2

By default, multiple line of text column with enhanced rich text is not supported with JSON formatting. JSON formatting is only available with multiple line of text column with plain text.

As a workaround, add a scroll for multiple line of text column with plain text by using below JSON codes.

{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column formatting.schema.json",
    "debugMode": true,
    "elmType": "div",
    "children": [
      {
     "elmType": "div",
        "txtContent": "@currentField",
        "style": {
                 "padding":"11px 8px",
                 "max-height":"64px",
                "overflow-y":"auto",
                "align-items":"flex-start"
         }
      }
    ]
 }

---

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.