Fix - SharePoint Online List column JSON formatting for person group field displays [object, Object]


⛔️ PROBLEM - SharePoint List JSON formatting person/group name returns [object, Object]

For long truncating names for person/group fields, you would want to wrap the name from the people picker field. But when you use JSON to format the @currentField value, it returns [object, Object] as the value and not person name. This is because person filed is treated as a lookup.

Reference to wrap text - How to wrap text in SharePoint Online Modern List view using JSON formatting

JSON code used
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "white-space": "wrap"
  },
  "txtContent": "@currentField"
}

SharePoint List person column format JSON issue.PNG
SharePoint List person column format JSON issue

⛔️ SOLUTION - Use @currentField.title in the JSON formatting

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "white-space": "wrap"
  },
  "txtContent": "@currentField.title"
}
SharePoint List person column format JSON fix.PNG
SharePoint List person column format JSON fix

@currentField.title --> return display name

@currentField.email --> return email address

Advertisements
Try Out Code2care Dev Tools:

Advertisements



#Android #Java #Linux #Microsoft #Google #Python #MacOS #Notepad++ #Microsoft Teams #CSS #PHP #SharePoint #Html #Linux #C-Program #Bootstrap #jQuery #Sublime #Android-Studio #Facebook #Eclipse #WhatsApp #News #MySQL #Json #HowTos #JavaScript #FTP #S3


Advertisements


Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and Software Developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include Learnings, Tutorials, Trouble-Shooting steps, Video Tutorials, Code Snippets, How Tos, Blogs, Articles, etc.
🎉 We are celebrating the 10th years of Code2care! Thank you for all your support! We hope we made a difference.
We strong support Gender Equality & Diversity.

We stand in solidarity with Ukraine - Make a donation to UNHCR - https://donate.unhcr.org/in/en-in/ukraine-emergency