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

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-to, blogs, articles, etc.

🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.