Link to a lookup a column by using json formatting

Question

I want to create a link to a lookup a column by using json formatting, but the coding is not accepted to be applied. What I expect is to select a link in the list “Invoice” and be transferred to the list “invoice items” and get the specific record by ID…I have created a column called “invoice” in the list “Invoice items” as vlookup to list “Invoice” column ID.&nbsp;Here are the lists that I have.List1: InvoiceFields: Invoice Number, due date, invoice date, invoice item.&nbsp;List2: Invoice ItemsFields: Quantity, Price, Total, Invoice.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Please let me know any feedback.

ashish_kohale · Answer

Walter Fuentes&nbsp;: Lookup field any way take you to the original list item from the current list item. It's by default gives link to the item in another list.&nbsp;Even though following is the code I tried and it worked:{"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json","elmType": "a","txtContent": "@currentField.lookupValue","attributes": {"href": {"operator": "+","operands": ["/sites/Test21/Lists/TestList/DispForm.aspx?ID=","@currentField.lookupId"]},"target": "_blank"},"style": {"color": "#796BB1","font-weight": "bold"}}

walter fuentes · Answer

HiAshish_Kohale&nbsp;Thanks for supporting me with this request, I still need your help, I am not familiar with this feature.1. By using the script the text or link in the column disappear.2.Not sure how use "@currentField.lookupId", if I put it exactly the same this will makes blank my text or link in the column, and I use "Invoice.lookupId" this will take me to an empty display form.&nbsp;Thanks my friend.

ashish_kohale · Answer

Walter Fuentes&nbsp;:&nbsp;@currentField.lookupId use as it is ... and check&nbsp;

Forum Discussion

Link to a lookup a column by using json formatting

3 Replies

Resources