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

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap