Column Formatting using JSON: Get value of the column “_ModerationStatus”

Question

I'm trying to check the value of the column _ModerationStatus in a document library with that has content approval.

I have the following JSON:

 {
      "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
      "elmType": "div",
      "debugMode": true,
      "txtContent": "[$_ModerationStatus]"
}

I get the following message in the console:

could not evaluate _ModerationStatus

The column is included in the view and the column displays Approved and so on. So the column seems to be working correctly.

What am I doing wrong? :)

Answer 1

As a workaround, we can create a text field "ApprovalStatus", then create a workflow to set the value from the "Approval Status" field to this new field.

Then using the JSON below:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "debugMode": true,
  "txtContent": "[$ApprovalStatus]"
}