We are trying to get around the problem of having lists in different Sharepoint Online sites which have the same information.
So I was wondering, is it possible to create a list which has a lookup column which connects to another SharePoint list in a different Sharepoint site but still under the same tenant? I can only see a way of doing this with lists in the same SharePoint site.
For example, we have a HR site and and IT site and would like to create a list in one site which has a lookup column which points to a list in the other site.
