How do I use multple IF statements using JSON Code

Question

I have been working for sometime on this JSON but am stuck.
Here is the code and it's not working as I hoped it would.

I have two fields that I am evaluating and based on what those two fields are set to determine if I should show a button or not within a SharePoint field using JSON.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
 
"elmType": "button",
"txtContent": "Launch DI Exit",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{"id": "86***78-e4*c-4*6d-9**7-08**9f6***"}"
  },
  "style": {
    "background-color": "#0080ff",
    "color": "white",
    "border-radius": "0 15px",
    "visibility": "=if(([$DIExitApprovalStatus] == 'Pending'&& [$WorkflowRequired]=='DI Exit','visible','hidden')"
  }
 
"elmType": "button",
"txtContent": "Launch OA Exit",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{"id": "e78***07-2**d-4**e-9**3-9aa4fc67***"}"
  },
  "style": {
    "background-color": "#008082",
    "color": "white",
"border-radius": "0 15px",
"visibility": "=if(([$OAExitApprovalStatus] == 'Pending'&& [$WorkflowRequired]=='OA Exit','visible','hidden')"
  }
 
"elmType": "button",
"txtContent": "Launch CD_CV Exit",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{"id": "52**e98-e**b-4**7-a**1-d5e8e72***"}"
  },
  "style": {
    "background-color": "#008082",
    "color": "white",
    "border-radius": "0 15px",
"visibility": "=if(([$CD_CVExitApprovalStatus] == 'Pending'&& [$WorkflowRequired]=='CD_CV Exit','visible','hidden')"

  }
} Thanks for your help!
Been searching all over the internet and can't find anything regarding this.

Answer 1

Dear Christopher,

After my test, you can use the following code to see the result.

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json","elmType": "span","children": [{"elmType": "button","txtContent": "Launch Flow for DI Exit","customRowAction": {"action": "executeFlow","actionParams": "{"id": "b6**80-f**2-4**d-a**1-0524a6***"}"},"style": {"background-color": "#0080ff","color": "white","border-radius": "0 15px","visibility": "=if(([$DIExitApprovalStatus] == 'Pending')&&([$WorkflowRequired]=='Flow for DI Exit'),'visible','hidden')"}},{"elmType": "button","txtContent": "Launch Flow for OA Exit","customRowAction": {"action": "executeFlow","actionParams": "{"id": "20***dad-a**a-4**4-a**4-d7b0a4***"}"},"style": {"background-color": "#008082","color": "white","border-radius": "0 15px","visibility": "=if(([$OAExitApprovalStatus] == 'Pending')&&([$WorkflowRequired]=='Flow for OA Exit'),'visible','hidden')"}},{"elmType": "button","txtContent": "Launch Flow for CD_CV Exit","customRowAction": {"action": "executeFlow","actionParams": "{"id": "4b***c13-0**0-4**2-9**9-748865***"}"},"style": {"background-color": "#008082","color": "white","border-radius": "0 15px","visibility": "=if(([$CD_CVExitApprovalStatus] == 'Pending')&&([$WorkflowRequired]=='Flow for CD_CV Exit'),'visible','hidden')"}}]} I create the list as follows.

Best Regards,

Cliff

Answer 2

Outstanding!
I will study the difference in what I had and what you gave me.
Learning JSON is awesome!

So, appreciate your assistance and providing me a learning opportunity!

Best Regards,

Chris

Answer 3

Hi Cliff,
I really appreciate your time.

Answer 4

Dear Christopher,

I need some time to do a test and I'll update here as soon as possible.

Best Regards,

Cliff