question

ChristopherDavis-5497 avatar image
0 Votes"
ChristopherDavis-5497 asked ChristopherDavis-5497 commented

SharePoint List - Multi Line Column - Change formatting to show lookup values in a row rather than one after the other.

Hello,

I am trying to format a lookup column in SharePoint to show the values in rows of four rather than one underneath the other. For example:

Current View

3456

4365

3453

2652

Desired View

3456; 4365; 3453, 2652

Can anyone tell me what JSON code to use to make this happen? Thanks.

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EmilyDu-MSFT avatar image
0 Votes"
EmilyDu-MSFT answered ChristopherDavis-5497 commented

You could use below JSON code.

Note: When you use JSON formatting in the Multi-Lookup column, values in the Multi-Lookup column will change from URL form to text form.

 {
   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
   "elmType": "div",
   "children": [
     {
       "elmType": "div",
       "style": {
       "display": "block",
       "width": "100%"
       },
       "txtContent": "=@currentField.lookupValue"
     }
   ]
 }

Result:
106049-1.png





1.png (5.1 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

Thank you for the answer. Is there a way to put it back to a link?

0 Votes 0 ·
EmilyDu-MSFT avatar image EmilyDu-MSFT ChristopherDavis-5497 ·

@ChristopherDavis-5497

Once you use JSON formatting in the Multi-Lookup column, there is no option to bring it back to link.

0 Votes 0 ·

Thanks so much for your help. Much appreciated.

0 Votes 0 ·