Forum Discussion

MichaelBoehnke's avatar
MichaelBoehnke
Copper Contributor
Nov 30, 2021

Column formatting / Show or hide columns based on user permission

Hi guys,   I just wanted to let you know that by pure chance 🙂 I managed to show/hide list columns based on the permission of the current user. For this, I use the PermMask attribute. In this...
Permissions
SharePoint Online
Ivan_Volkov's avatar
Ivan_Volkov
Copper Contributor
An elegant solution.
Unfortunately, it does not work in sharepoint 2019.
Is it possible to modify it for sharepoint 2019?
ganeshsanap's avatar
ganeshsanap
MVP
Sep 03, 2022

Ivan_Volkov For SharePoint 2019, you have to use the Abstract Syntax Tree (AST) expressions using operator and operands. Try this: 

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v1/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "visibility": {
      "operator": "?",
      "operands": [
        {
          "operator": ">=",
          "operands": [
            "[$PermMask]",
            "0xb00"
          ]
        },
        "hidden",
        "visible"
      ]
    }
  },
  "txtContent": {
    "operator": "?",
    "operands": [
      {
        "operator": ">=",
        "operands": [
          "[$PermMask]",
          "0xb00"
        ]
      },
      "read-only",
      "more than read"
    ]
  }
}

 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources