found a field in the sub list

Question

Hi,

i have 2 lists and joint on ID and DemandId

<Demande EDI> with the field ( Title, ID, ....)

<Cahier de test> list with field (DemandeId, Title...)

i would like to display Title from <Demande EDI> in the field Title from <cahier de test>

i use this json on the Title column format from the list <Cahier de test>

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "div",

"txtContent": "=lookup([$DemandeId], 'Demande EDI', 'ID', 'Title')",

"style": {

"color": "#0078d4",

"font-weight": "bold" }

}

i have this information in the column

Answer 1

Hi @Pierre BUDE,

I apologize for my late reply as this took me a little while to test.

I checked the information and then realized that we can't use SharePoint JSON formatting to get the values of different columns, we know we can get the values of different columns in the same list.

That means in <Cahier de test> we can't get the value of Title in <Demande EDI>****.

Also, JSON formatting doesn't populate the values of the columns, it just controls the display formatting of the columns, the actual column values are empty.

I'm sorry, but SharePoint doesn't have an out-of-the-box solution to your problem right now. Perhaps you could try using Power Apps to modify the data source for your Tilte columns in the way it was designed.

Please accept my sincerely apologize for any in convenience this may cause. Thank you for your kind understanding.

---

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.