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




Recent Posts:




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, Video Tutorials, Code Snippets, How Tos, Blogs, Articles, etc.