Problem on JSON formating with a connected field of a lookup Column

Question

Problem on JSON formating with a connected field of a lookup Column

Patgat 0

In my List A I have a lookup column "CODE PROJET" and one connected lookup column "FIN RECONDCT" both coming from an other SharePoint list B.

[ enter image description here

](https://i.stack.imgur.com/1CJ3Q.png)

On a field of the A List I try to do a JSON column formating with a test on "FIN RECONDCT" coming from B.

I get fine the value of "CODE PROJET" doing [$CODE_x0020_PROJET.lookupValue] but I never get the value of the connected field "FIN RECONDCT"

I tried different solutions. But whatever name I use to get the value, I get no error (in debug mode) and no value. I tried all these =>

[$FIN_x0020_RECONDCT.lookupValue] [$CODE_x0020_PROJET:FIN_x0020_RECONDCT.lookupValue] [$CODE_x0020_PROJET.FIN_x0020_RECONDCT.lookupValue] [$CODE_x0020_PROJET:$FIN_x0020_RECONDCT.lookupValue] [$CODE_x0020_PROJET.$FIN_x0020_RECONDCT.lookupValue]

Please can somebody help me?

israr ahmed 0

In the context of SharePoint or other databases, a JSON format with a connected field of a lookup column typically refers to how data is structured in JSON (JavaScript Object Notation) when dealing with fields that are connected or linked through a lookup column.

A lookup column in a database allows you to associate data from one list or library with another. When working with JSON data that involves a connected field from a lookup column, you need to represent these relationships within the JSON structure.

Here's a simple example to illustrate:

Let's say you have two lists in SharePoint: "Employees" and "Departments." The "Employees" list has a lookup column named "Department" that connects each employee to a department.

JSON representation might look like this:

```json
{
  "employees": [
    {
      "id": 1,
      "name": "John Doe",
      "department": {
        "id": 101,
        "name": "Human Resources"
      }
    },
    {
      "id": 2,
      "name": "Jane Smith",
      "department": {
        "id": 102,
        "name": "Finance"
      }
    }
    // Additional employee entries...
  ],
  "departments": [
    {
      "id": 101,
      "name": "Human Resources",
      "location": "Building A"
    },
    {
      "id": 102,
      "name": "Finance",
      "location": "Building B"
    }
    // Additional department entries...
  ]
}

In this example, the "employees" array includes objects with a "department" field. This "department" field is an object itself, containing information about the department, which is connected through the lookup column.

When working with JSON data and lookup columns, it's important to structure your JSON to reflect the relationships between the connected data. The specifics can vary based on the platform or system you're working with, so you may need to refer to the documentation of the specific database or service you're using for more detailed guidance. CHECK BOX:

2 answers

Your answer

israr ahmed 0 Reputation points

2024-01-08T02:49:18.33+00:00

In the context of SharePoint or other databases, a JSON format with a connected field of a lookup column typically refers to how data is structured in JSON (JavaScript Object Notation) when dealing with fields that are connected or linked through a lookup column. A lookup column in a database allows you to associate data from one list or library with another. When working with JSON data that involves a connected field from a lookup column, you need to represent these relationships within the JSON structure. Here's a simple example to illustrate: Let's say you have two lists in SharePoint: "Employees" and "Departments." The "Employees" list has a lookup column named "Department" that connects each employee to a department. JSON representation might look like this: ```json { "employees": [ { "id": 1, "name": "John Doe", "department": { "id": 101, "name": "Human Resources" } }, { "id": 2, "name": "Jane Smith", "department": { "id": 102, "name": "Finance" } } // Additional employee entries... ], "departments": [ { "id": 101, "name": "Human Resources", "location": "Building A" }, { "id": 102, "name": "Finance", "location": "Building B" } // Additional department entries... ] }

In this example, the "employees" array includes objects with a "department" field. This "department" field is an object itself, containing information about the department, which is connected through the lookup column.

When working with JSON data and lookup columns, it's important to structure your JSON to reflect the relationships between the connected data. The specifics can vary based on the platform or system you're working with, so you may need to refer to the documentation of the specific database or service you're using for more detailed guidance. CHECK BOX:

Answer 1

Hi @Patgat,

As per my knowledge, I'm afraid that we cannot get value of a lookup field which connects to another lookup field using JSON column formatting. And as said in this thread: How to create a lookup field from another lookup column, I cannot create a lookup field which connects to another lookup field. This is by design in SharePoint Online.

In this case, I would suggest you connect the lookup field to the source list B if possible and use

[$CODE_x0020_PROJET.lookupValue] in the JSON code.

Hope my answer helps. Have a good day:)

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

Patgat 0

Thanks for you contrubution. I did succeed to get [$CODE_x0020_PROJET.lookupValue] coming from the B List but my problem is getting the vaue of its connected field "FIN RECONDCT" (also coming from B List).

Share via

Problem on JSON formating with a connected field of a lookup Column

2 answers

Your answer