Format MS Lists Column to navigate to record

I have a MS Lists column which navigate to SAP based on the value of another column. I am using the following format. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-fo...

developer

microsoft lists

SharePoint Online

grant_jenkins

Jun 26, 2025

DekkerNick1 The following JSON should get what you're after.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "txtContent": "[$SAPMeldingsnummer]",
  "attributes": {
    "href": {
      "operator": "+",
      "operands": [
        "https://erp.alfa.local/sap/bc/ui5_ui5/ui2/ushell/shells/abap/FioriLaunchpad.html?sap-language=nl#MaintenanceNotification-displayFactSheet&/C_ObjPgMaintNotification('",
        "[$SAPMeldingsnummer]",
        "')"
      ]
    },
    "target": "_blank"
  },
  "style": {
    "color": "blue",
    "text-decoration": "underline"
  }
}

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "txtContent": "[$SAPMeldingsnummer]", "attributes": { "href": { "operator": "+", "operands": [ "https://erp.alfa.local/sap/bc/ui5_ui5/ui2/ushell/shells/abap/FioriLaunchpad.html?sap-language=nl#MaintenanceNotification-displayFactSheet&/C_ObjPgMaintNotification('", "[$SAPMeldingsnummer]", "')" ] }, "target": "_blank" }, "style": { "color": "blue", "text-decoration": "underline" } }

Forum Discussion

Format MS Lists Column to navigate to record

Resources