JSON formatting lookup column with multiple values

%3CLINGO-SUB%20id%3D%22lingo-sub-2019474%22%20slang%3D%22en-US%22%3EJSON%20formatting%20lookup%20column%20with%20multiple%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019474%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20to%20JSON%20formatting%20a%20column.%20In%20a%20SharePoint%20online%20list%20I%20have%20a%20lookup%20column%20that%20permits%20multiple%20values%20from%20the%20Document%20ID%20column%20from%20a%20document%20library.%20Three%20other%20columns%20are%20also%20brought%20in%2C%20one%20of%20which%20is%20date.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20applying%20any%20JSON%20formatting%2C%20the%20lookup%20column%20itself%20listing%20the%20multiple%20Document%20IDs%20displays%20just%20fine%20with%20separate%20lines.%20However%2C%20each%20of%20the%20multiple%20values%20in%20he%20other%20three%20other%20columns%20that%20are%20brought%20in%20with%20the%20lookup%20column%20do%20no%20display%20on%20a%20new%20line.%20Rather%2C%20they%20displayed%20with%20a%20semi-colon%20between%20them.%20This%20is%20less%20than%20ideal.%20I%20would%20like%20to%20format%20each%20of%20the%20multiple%20values%20to%20display%20on%20a%20new%20line.%20I%20have%20attempted%20to%20use%20various%20JSON%20examples%20without%20any%20luck.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20help%20with%20an%20example%20for%20JSON%20formatting%20the%20lookup%20column%20and%20the%20three%20other%20columns%20brought%20in%20with%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2019474%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2026842%22%20slang%3D%22en-US%22%3ERe%3A%20JSON%20formatting%20lookup%20column%20with%20multiple%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026842%22%20slang%3D%22en-US%22%3E%3CP%3EBump%2C%20any%20idea%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F913288%22%20target%3D%22_blank%22%3E%40NanaBar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am new to JSON formatting a column. In a SharePoint online list I have a lookup column that permits multiple values from the Document ID column from a document library. Three other columns are also brought in, one of which is date. 

 

Without applying any JSON formatting, the lookup column itself listing the multiple Document IDs displays just fine with separate lines. However, each of the multiple values in he other three other columns that are brought in with the lookup column do no display on a new line. Rather, they displayed with a semi-colon between them. This is less than ideal. I would like to format each of the multiple values to display on a new line. I have attempted to use various JSON examples without any luck. 

 

Can someone please help with an example for JSON formatting the lookup column and the three other columns brought in with it?

 

Thank you

2 Replies

Bump, any idea? @NanaBar 

@NanaBar , look at this example:

Complex HTML elements formatting

 

You will need to define column formatting for each of your 3 multiple values columns. Basically you need to use the foreach attribute that can define, for example, a div for each value (using the children attribute).

 

Hope this help.