JSON formatting to show a minumum amount of words in SharePoint

Question

Hi

How do I apply json formatting to a large lookup column that contains many lookup items per row. The rows are growing because of the size of the lookup column.

Answer 1

Hi @Kalpana ,

I used below JSON code to display lookup items in one field up to 6.

{  
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
  "elmType": "div",  
  "style": {  
        "display": "block"  
  },  
  "children": [  
    {  
      "elmType":"div",  
      "forEach": "test in @currentField",  
      "txtContent": "=if(loopIndex('test') < 6, '[$test.lookupValue]', '')"  
    }  
  ]  
}  

Note that you will be not able to redirect to the lookup item by clicking on it after applying the JSON formatting, it can only show the values of lookup items.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.