how to make conditional format on data type:lookup for sharepoint list

Question

Hello,

Am using SharePoint 365 and I tried to make conditional format on 1 column (type: lookup) that reads from another list in the site called (dropdown list) , but am getting an error : [object Object] on this column

(on left side of the table is what I need , on the right side is the error am getting )

on the left side date type is (choice)

on the Right side date type is (lookup)

am using the code below on both column but it's only applied on one of them, anyone know why ?

{
	"elmType": "div",
	"txtContent": "@currentField",
	"style": {
		"color": "#000000",
		"padding-left": "14px",
                "font-weight": "bold",
		"background-color": {
			"operator": "?",
			"operands": [{
					"operator": "==",
					"operands": [
						"@currentField",
						"Highly Probable"
					]
				},
				"#C00000",
				{
					"operator": "?",
					"operands": [{
							"operator": "==",
							"operands": [
								"@currentField",
								"Probable"
							]
						},
						"#FF0000",
						{
							"operator": "?",
							"operands": [{
									"operator": "==",
									"operands": [
										"@currentField",
										"Possible"
									]
								},
								"#FFC000",
								{
									"operator": "?",
									"operands": [{
											"operator": "==",
											"operands": [
												"@currentField",
												"Improbable"
											]
										},
										"#D4D919",
										{
											"operator": "?",
											"operands": [{
													"operator": "==",
													"operands": [
														"@currentField",
														"Highly Improbable"
													]
												},
												"#00B050",
												""
											]
										}
									]
								}
							]
						}
					]
                }]
			}
		}}

Answer 1

Hi @Fahad Shaheen ,

Please use the following code (replace all occurrences of @currentField with @currentField.lookupValue):

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField.lookupValue",
  "style": {
    "color": "#000000",
    "padding-left": "14px",
    "font-weight": "bold",
    "background-color": {
      "operator": "?",
      "operands": [
        {
          "operator": "==",
          "operands": [
            "@currentField.lookupValue",
            "Highly Probable"
          ]
        },
        "#C00000",
        {
          "operator": "?",
          "operands": [
            {
              "operator": "==",
              "operands": [
                "@currentField.lookupValue",
                "Probable"
              ]
            },
            "#FF0000",
            {
              "operator": "?",
              "operands": [
                {
                  "operator": "==",
                  "operands": [
                    "@currentField.lookupValue",
                    "Possible"
                  ]
                },
                "#FFC000",
                {
                  "operator": "?",
                  "operands": [
                    {
                      "operator": "==",
                      "operands": [
                        "@currentField.lookupValue",
                        "Improbable"
                      ]
                    },
                    "#D4D919",
                    {
                      "operator": "?",
                      "operands": [
                        {
                          "operator": "==",
                          "operands": [
                            "@currentField.lookupValue",
                            "Highly Improbable"
                          ]
                        },
                        "#00B050",
                        ""
                      ]
                    }
                  ]
                }
              ]
            }
          ]
        }
      ]
    }
  }
}

The running result is as below：

---

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.

Answer 2

@Haoyan Xue_MSFT YES ! it's works with ZERO error

Thanks a lot, you save my Day