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 example, I only show the column value, if the user permission is higher than 'read' permission:

 

 

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

 

 

In a real life use case, I use this to show a "Run flow" button to only those users, who have at least an edit permission for the specific list item.

I hope this helps somebody 🙂

Permissions
SharePoint Online
  • kmayne's avatar
    kmayne
    Copper Contributor
    May 11, 2023
    Another option is to create separate views, just show/hide the views for specific users.
  • Ivan_Volkov's avatar
    Ivan_Volkov
    Copper Contributor
    Sep 03, 2022
    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