How to add a Projected Field to a List in SharePoint Online

%3CLINGO-SUB%20id%3D%22lingo-sub-392700%22%20slang%3D%22en-US%22%3EHow%20to%20add%20a%20Projected%20Field%20to%20a%20List%20in%20SharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392700%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20add%20the%20Title%20field%20(as%20a%20hyperlink)%20from%20List%20B%20as%20a%20column%20in%20List%20A%2C%20where%20List%20B%20has%20a%20Lookup%20column%20referencing%20one%20entry%20in%20List%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELists%20A%20and%20B%20are%20within%20the%20same%20Site%2C%20and%20the%20platform%20is%20SharePoint%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20understand%20this%20can%20be%20done%20with%20Joins%20and%20Projected%20Fields%20and%20I've%20found%20the%20documentation%20on%20the%20CAML%20that%20seems%20to%20be%20required%20(%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fschema%2Fprojectedfields-element-view%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fschema%2Fprojectedfields-element-view%3C%2FA%3E).%20It%20doesn't%20seem%20hard.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20is%2C%20where%20do%20I%20put%20that%20CAML%3F%20All%20the%20documentation%20talks%20about%20editing%20XML%20files%20in%20a%20certain%20folder%20on%20the%20server%2C%20but%20in%20this%20case%20it's%20SharePoint%20online...%20Is%20there%20a%20way%20to%20edit%20those%20CAML%20files%20on%20SharePoint%20online%3F%20What%20permissions%20are%20required%20to%20do%20this%20(I'm%20the%20site%20owner%2C%20but%20by%20no%20means%20an%20admin%20I%20think%20as%20I'm%20not%20even%20in%20IT)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20is%20there%20no%20easier%20way%20to%20achieve%20this%3F%20Surely%20this%20is%20such%20a%20common%20request%20it%20should%20be%20a%20point%20and%20click%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-432399%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20a%20Projected%20Field%20to%20a%20List%20in%20SharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-432399%22%20slang%3D%22en-US%22%3E%3CP%3EHere's%20a%20more%20concrete%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Customers%20and%20Sales.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Customers%20list%20I%20want%20to%20have%20hyperlinks%20to%20each%20Sale%20that%20relates%20to%20that%20Customer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anybody%20help%2C%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-550736%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20a%20Projected%20Field%20to%20a%20List%20in%20SharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550736%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20anybody%20out%20there%20who%20can%20help%20with%20this%2C%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need to add the Title field (as a hyperlink) from List B as a column in List A, where List B has a Lookup column referencing one entry in List A.

 

Lists A and B are within the same Site, and the platform is SharePoint Online.

 

I understand this can be done with Joins and Projected Fields and I've found the documentation on the CAML that seems to be required (https://docs.microsoft.com/en-us/sharepoint/dev/schema/projectedfields-element-view). It doesn't seem hard.

 

My question is, where do I put that CAML? All the documentation talks about editing XML files in a certain folder on the server, but in this case it's SharePoint online... Is there a way to edit those CAML files on SharePoint online? What permissions are required to do this (I'm the site owner, but by no means an admin I think as I'm not even in IT)?

 

Also, is there no easier way to achieve this? Surely this is such a common request it should be a point and click solution?

2 Replies

Here's a more concrete example:

 

I have Customers and Sales.

 

In the Customers list I want to have hyperlinks to each Sale that relates to that Customer.

 

Can anybody help, please?

Is there anybody out there who can help with this, please?