Forum Discussion

DekkerNick1's avatar
DekkerNick1
Copper Contributor
Jun 23, 2025
Solved

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-formatting.schema.json",

"elmType": "a",

"txtContent": "[$SAPMeldingsnummer]",

"attributes": {

"href": "='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"

}

}

The URL that is giving me is almost correct, except that the single quotes are SAP Meldingsnummer are not shown in the URL. 

So I get https://erp.alfa.local/sap/bc/ui5_ui5/ui2/ushell/shells/abap/FioriLaunchpad.html?sap-language=nl#MaintenanceNotification-displayFactSheet&/C_ObjPgMaintNotification(41000041014)/?sap-iapp-state--history=TASFJ4EYT0MQFDVYB5KULQ8S7ITFZMCBXC1PNEAUN

Where is actually should be 
https://erp.alfa.local/sap/bc/ui5_ui5/ui2/ushell/shells/abap/FioriLaunchpad.html?sap-language=nl#MaintenanceNotification-displayFactSheet&/C_ObjPgMaintNotification('41000041014')/


developer
microsoft lists
SharePoint Online
  • grant_jenkins's avatar
    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"
  }
}

     

1 Reply

  • grant_jenkins's avatar
    grant_jenkins
    Iron Contributor
    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"
  }
}

     

Resources