JSON - Formatting a Person/Group Column

%3CLINGO-SUB%20id%3D%22lingo-sub-1483695%22%20slang%3D%22en-US%22%3EJSON%20-%20Formatting%20a%20Person%2FGroup%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483695%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20and%20thanks%20in%20advance%20for%20any%20help%20you%20may%20be%20able%20to%20provide!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20formatting%20a%20SharePoint%20On-Line%20List%20view%20with%20JSON.%26nbsp%3B%20I%20am%20trying%20to%20pull%20into%20the%20JSON%20formatting%20a%20Column%20titled%20'%3CEM%3ESALES%20(LEAD%20CONTACT)%3C%2FEM%3E'.%26nbsp%3B%20Looking%20at%20the%20URL%2C%20the%20natural%20name%20for%20this%20column%20is%20'%3CEM%3ESales_x0020__x0028_Lead_x0020_Co%3C%2FEM%3E'.%26nbsp%3B%20Below%20is%20an%20unformatted%20view%20with%20the%20column%20pulling%20in%20correction.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22All%20Items%20wSales%20Contact.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200526i808F3E68DF79B8D9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22All%20Items%20wSales%20Contact.jpg%22%20alt%3D%22All%20Items%20wSales%20Contact.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHowever%20when%20I%20try%20to%20bring%20in%20that%20column%20in%20my%20JSON%20formatted%20List%20view%2C%20it%20doesn't%20pull%20in%20this%20Sales%20Contact%20information%20but%20instead%20just%20shows%20'Object'%2C%20per%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22All%20Items%20wSales%20Contact%20JSON.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200527i461CF29A92527456%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22All%20Items%20wSales%20Contact%20JSON.jpg%22%20alt%3D%22All%20Items%20wSales%20Contact%20JSON.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83Code%20shown%20below.%26nbsp%3B%20It's%20hard%20to%20see%20my%20highlighting%2C%20but%20the%20applicable%20part%20is%20at%20the%20bottom%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22All%20Items%20wSales%20Contact%20JSON%20Code.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200529i112E182B26AA279A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22All%20Items%20wSales%20Contact%20JSON%20Code.jpg%22%20alt%3D%22All%20Items%20wSales%20Contact%20JSON%20Code.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83One%20point%20that%20may%20be%20important%3A%26nbsp%3B%20The%20data%20in%20this%20SharePoint%20On-Line%20List%20that%20I'm%20formatting%20is%20being%20placed%20their%20via%20a%20Power%20Automate%20Flow.%26nbsp%3B%20However%2C%20as%20can%20be%20seen%20in%20the%20first%20screenshot%2C%20it's%20definitely%20there.%26nbsp%3B%20Any%20ideas%20what%20may%20be%20going%20on%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1483695%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi everyone, and thanks in advance for any help you may be able to provide!

 

I'm formatting a SharePoint On-Line List view with JSON.  I am trying to pull into the JSON formatting a Column titled 'SALES (LEAD CONTACT)'.  Looking at the URL, the natural name for this column is 'Sales_x0020__x0028_Lead_x0020_Co'.  Below is an unformatted view with the column pulling in correction.

All Items wSales Contact.jpg

However when I try to bring in that column in my JSON formatted List view, it doesn't pull in this Sales Contact information but instead just shows 'Object', per below:

 

All Items wSales Contact JSON.jpg

 Code shown below.  It's hard to see my highlighting, but the applicable part is at the bottom:

 

All Items wSales Contact JSON Code.jpg

 One point that may be important:  The data in this SharePoint On-Line List that I'm formatting is being placed their via a Power Automate Flow.  However, as can be seen in the first screenshot, it's definitely there.  Any ideas what may be going on?

0 Replies