JSON - Formatting a Person/Group Column

Copper 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