Forum Discussion

Jordaromera's avatar
Jordaromera
Copper Contributor
Nov 11, 2021
Solved

JSON format broken?

Hi,    Some days ago i have a incident with two differents lists, this problem probably due a Microsoft change in the SP Online. The first problem: in the attached screenshot a week ago i don't hav...
developer
SharePoint Online
WorkflowIQ's avatar
WorkflowIQ
Copper Contributor
Nov 16, 2021

Danie365 Thanks.

I agree. It looks like Microsoft added a feature that someone requested, and broke something that already worked. Changing [$_moderationStatus] with [$_moderationStatus.displayValue] didn't work for me for some reason. It may be something simple i have missed, as i have been staring at this code for days.... The column still is not showing for files where the Approval Status is "Pending".

 

Can you please take a quick look to see if you can see something i have done wrong? 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "button",
  "customRowAction": {
    "action": "executeFlow",
    "actionParams": "='{\"id\": \"' + if([$ReviewInProgress]=='','xxxxxxxx',if([$ReviewInProgress]=='No','xxxxxxxxx',' ')) + '\"}'"
  },
  "txtContent": "=if([$ReviewInProgress]=='Approval','Sent for Approval','Send for Approval')",
  "style": {
    "background-color": "=if([$ReviewInProgress]=='Approval','Orange','Green')",
    "color": "white",
    "border-radius": "20px",
    "border-style": "solid",
    "border-color": "white",
    "border-width": "4px",
    "visibility": {
      "operator": "?",
      "operands": [
        {
          "operator": "==",
          "operands": [
            "[$_moderationStatus.displayValue]",
            "Pending"
          ]
        },
        "visible",
        "hidden"
      ]
    }
    }
  }

 

Danie365's avatar
Danie365
Brass Contributor
Nov 16, 2021

Hey WorkflowIQ, try this...

 

{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "button",
    "customRowAction": {
      "action": "executeFlow",
      "actionParams": "='{\"id\": \"' + if([$ReviewInProgress]=='','xxxxxxxx',if([$ReviewInProgress]=='No','xxxxxxxxx',' ')) + '\"}'"
    },
    "txtContent": "=if([$ReviewInProgress]=='Approval','Sent for Approval','Send for Approval')",
    "style": {
      "background-color": "=if([$ReviewInProgress]=='Approval','Orange','Green')",
      "color": "white",
      "border-radius": "20px",
      "border-style": "solid",
      "border-color": "white",
      "border-width": "4px",
      "visibility": "=if(([$_moderationStatus.displayValue] == ‘Pending’),’visible’,’hidden’)"
      }
    }
  • WorkflowIQ's avatar
    WorkflowIQ
    Copper Contributor
    Nov 17, 2021

    Danie365 Thanks for the help, i really appreciate it. I still can't get it to work though. I pasted your code exactly, just adding my correct flow id, and replacing the single quotes (as they paste a different character if copying from here). Do you have any other suggections on what could be wrong? Thanks again, screenshot below.

     

    • Danie365's avatar
      Danie365
      Brass Contributor
      Nov 17, 2021

      WorkflowIQ are the "txtContent" and "background-color" missing a set or parenthesisssssssss (no idea how to spell the plural of that!)...

       

      I'm just brainstorming now as my lack of code knowledge is  going to become apparent...

       

      but maybe try this...

      {
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "button",
    "customRowAction": {
      "action": "executeFlow",
      "actionParams": "='{\"id\": \"' + if([$ReviewInProgress]=='','xxxxxxxx',if([$ReviewInProgress]=='No','xxxxxxxxx',' ')) + '\"}'"
    },
    "txtContent": "=if(([$ReviewInProgress]=='Approval'),'Sent for Approval','Send for Approval')",
    "style": {
      "background-color": "=if(([$ReviewInProgress]=='Approval'),'Orange','Green')",
      "color": "white",
      "border-radius": "20px",
      "border-style": "solid",
      "border-color": "white",
      "border-width": "4px",
      "visibility": "=if(([$_moderationStatus.displayValue] == ‘Pending’),’visible’,’hidden’)"
      }
    }

       

      • WorkflowIQ's avatar
        WorkflowIQ
        Copper Contributor
        Nov 17, 2021

        Danie365 LOL, I have no idea either about the plural, i usually give in and Google it 🙂

         

        The rest of the code is OK, i tested by just replacing 

        "visibility": "=if(([$_moderationStatus.displayValue] == ‘Pending’),’visible’,’hidden’)"

        with

        "visibility": "visible"

         

        and everything else works. (the button i am trying to conditionally hide always shows though of course)

         

        I also tried dropping one of the parenthesisss so that is is:

         

        "visibility": "=if([$_moderationStatus.displayValue]=='Pending','visible','hidden')"
         
        Still no luck....... I'll keep looking and post back here when I have something that works.
         
        Thanks again!!
         
         

Resources