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

4 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.

@Martin Coupal 

 

I'm trying this same thing.  I'm concerned the "forEach" function doesn't work on additional columns that are imported along with a Lookup column.

 

Interested to hear if anyone has a solution.

Okay, so it looks like the additional columns that pull from the other list treat their contents as a single string with semicolons distributed throughout. It does not treat them as an array.

So how do you take a string with semicolons and turn it into an iterable array?

That's not a feature yet.  Go upvote this feature recommendation if you want it to be added.

https://sharepoint.uservoice.com/forums/329220-sharepoint-dev-platform/suggestions/35436979-json-for...