Forum Discussion

Peter_K's avatar
Peter_K
Copper Contributor
Apr 17, 2019
Solved

Conditional JSON formatting of button in SharePoint List

Hi everybody   I am looking for a solution for a formatting problem in one of my sharepoint columns.  In one column I have a button which triggers a flow.    I am aiming for a visability of the ...
Document Library
SharePoint Online
  • Maruthi Gadde's avatar
    Maruthi Gadde
    Apr 18, 2019

    Peter_K 

     

    {
    "elmType": "button",
    "txtContent": "Get Approved",
    "customRowAction": {
    "action": "executeFlow",
    "actionParams": "{\"id\":\"86dfdf10-8d99-4914-8e98-fe4b21ed7e34\"}"
    },
    "style": {
    "background-color": "purple",
    "color": "white",
    "visibility": "=if(([$ModerationStatus] == 'Pending') && ([$DocumentType] == 'Offer'),'visible','hidden')"
    }

    }

     

    check this sample .. I got rid of the Operator and used a simple if statement.  only change to visibility property.

Maruthi Gadde's avatar
Maruthi Gadde
Iron Contributor
Apr 18, 2019

Peter_K 

 

{
"elmType": "button",
"txtContent": "Get Approved",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\":\"86dfdf10-8d99-4914-8e98-fe4b21ed7e34\"}"
},
"style": {
"background-color": "purple",
"color": "white",
"visibility": "=if(([$ModerationStatus] == 'Pending') && ([$DocumentType] == 'Offer'),'visible','hidden')"
}

}

 

check this sample .. I got rid of the Operator and used a simple if statement.  only change to visibility property.

Peter_K's avatar
Peter_K
Copper Contributor
Apr 18, 2019

Maruthi Gadde 

Thank you, that is exactly what I was looking for. 

 

Only one more thing: can i put multiple values in my if condition?

I want the button to be visible if: 

 

ModerationStatus = pending

Documenttyp = Offer OR Schedule OR List...

 

  • MatsWarnolf's avatar
    MatsWarnolf
    Copper Contributor
    Aug 29, 2019

    Peter_K  

    @Maruthi Gadde 

     

    I have exactly that question. My problem is that my organization is multilingual. 

    I display the button only when _ModerationStatus is draft and I have a flow that takes care of the rest. 

    But the text content of _ModerationStatus is language specific. So for swedes, the draft status is called "Utkast". I also have other languages to check for. 

     

    I have been experimenting with that line above:

    "visibility": "=if(([$_ModerationStatus] == 'Draft')'visible','hidden')"

    But I cannot grasp how to make more values match for it to be visible. The obvious solution is that if the value was numeric, it would be language independent.. 

     

    • MatsWarnolf's avatar
      MatsWarnolf
      Copper Contributor
      Aug 29, 2019

      Peter K Maruthi Gadde

       

      I found the solution here https://sharepoint.stackexchange.com/questions/260974/column-formatting-and-or-conditions 

       

      So my line is this:

      "visibility": "=if([$_ModerationStatus] == 'Utkast','visible',if([$_ModerationStatus] == 'Draft','visible','hidden')"

      This seems to do the trick. 

       

      The basic syntax for if is this: (taken straight from Stack Exchange)

      if(Condition, ResultIfTrue,ResultIfFalse)

       

      //OR (like you have it)
if(
    condition1,
    resultIfTrue,
    if(
        condition2,
        result-If-c1-False-And-C2-True
        result-If-c1-False-And-C2-false
    )
)

//So, here's the AND:
if(
    condition1,
    if(
        condition2,
        result-If-c1-true-And-C2-True
        result-If-c1-true-And-C2-false
    ),
    result-if-c1-false

       

      So big thanks to Maruthi Gadde for giving me a BIG piece of the puzzle and to Stevish over at Stack Exchange for providing me with the last and final piece.  

       

       

      • evaristo1904's avatar
        evaristo1904
        Copper Contributor
        Mar 20, 2021

        Hi MatsWarnolf 

        not sure if I understood your solution... or at least with me it doesn't work:

         
        I want to show the Flow button only if the STATUS column is NOT OK and if the ELLEGIBLE FOR APPROVAL column is Yes.
         
        {
        "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
        "elmType": "button",
        "txtContent": "Get approval",
        "customRowAction": {
        "action": "executeFlow",
        "actionParams": "{\"id\": \"99934f4d-182a-4aad-8b78-08a6b3c9727e\"}"
        },
        "style": {
        "background-color": "green",
        "color": "white",
        "visibility": "if([$Status]=='NOT OK','visible',if([$Elegibleforapproval]=='Yes','visible','hidden'))"
        }
        }
        Can you help sort it out what am I doing wrong?? Thanks!
         

Resources