Group not Showing in SharePoint List

I recently had an issue working on a SharePoint list dealing with a User or Group column. When the list would initially load, the value for the column (i.e. the group name) was displayed but after a moment it would disappear. I found the solution by using JSON formatting to format the column values.

To format the column, visit the list and click on the column header. Then, click on Column settings > and in the slide out menu click on Format this column.

Microsoft provides a link to information on how to perform the formatting, and you can check that out here. And here’s my custom formatting that fixed the problem.

{
  "elmType": "a",
  "debugMode": true,
  "txtContent": "@currentField.title",
  "attributes": {
      "href": {
         "operator": "+",
         "operands": [
            "/teams/teamsite/_layouts/15/people.aspx?MembershipGroupId=",
            "@currentField.id"
         ]
      },
      "target": "_blank"
   }
}

I made the group name into a link to the group membership page. I could have also styled the column by adding a style object to the formatting JSON.

{
  "elmType": "a",
  "debugMode": true,
  "txtContent": "@currentField.title",
  "attributes": {
      "href": {
         "operator": "+",
         "operands": [
            "/teams/tpd/hawaii/_layouts/15/people.aspx?MembershipGroupId=",
            "@currentField.id"
         ]
      },
      "target": "_blank"
   },
   "style": {
      "font-weight": "bold"
   }
}

Leave a Reply

Your email address will not be published. Required fields are marked *