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?
