How to format a SharePoint Library column based on a metadata column

Question

I have a SharePoint library with multiple choice columns and a Text column. The Text column has JSON formatting to show a button when the choice columns contain data (are not empty). This button kicks off a Power Automate Flow.

The following code for this works as intended :

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "button",
  "txtContent": "Publish",
  "customRowAction": {
    "action": "executeFlow",
    "actionParams": "{\"id\": \"v1/Default-9a24dbda-f3be-443b-910d-2793d0525bdd/4eb3006f-3071-4de4-823a-0a6bb2e2bd18\"}"
  },
  "style": {
    "background-color": "#0078d4",
    "color": "white",
    "border": "none",
    "cursor": "pointer",
    "padding": "6px 12px",
    "display": "=if([$Solutions] == '', || [$Phase] == '', || [$DocumentType] == '', 'none', 'inline-block')"
  }
}

However, I have realised I need to utilise metadata columns for this instead of choice columns, as I need these tags to be available across multiple libraries and sites. I'm not seeing much out there for understanding how to reference metadata columns or fix this, so any help or advice would be appreciated.

Answer 1

See if the answer to this other post helps.

https://learn.microsoft.com/en-us/answers/questions/491742/is-there-a-way-to-reference-columns-in-sharepoint

Answer 2

Hi @Ben Huxtable ，

Per my research, I am afraid Managed metadata column is not supported column formatting customRowAction executeFlow for managed metadata columns at this moment. Here is an document about Supported column types

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.