JSON and conditional formatting help!

Copper Contributor

Hi all, 

 

I'm new to JSON but have managed to use the following to display a button to trigger a flow based on a condition in a choice field (where value is "Yes"), and to hide it when the condition is not met.  However, I want to add another condition that will either: 

 

a) display 'Not Applicable in the column if any of the other values have been chosen; or 

b) display some kind of icon if any of the other values have been chosen. 

 

Is this possible to do and if so, is anyone able to tell me what additional JSON is required to make this work? 

 

Many thanks, 

 

{

  "$schema": https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json,

  "elmType": "button",

  "txtContent": "Request Approval",

  "customRowAction": {

    "action": "executeFlow",

    "actionParams": "{\"id\": \"7ed8a8df-8b1c-4753-981a-5ee58bcd318e\"}"

  },

  "style": {

    "background-color": "#00747B",

    "color": "white",

    "visibility": "=if(([$Configuration_x0020_Controlled] == 'Yes'),'visible','hidden')"

  }

}

0 Replies