Display list from another site collection

G99 31

I'd like to know if I can display a list from another site collection on a page, in another SPO site?

Thanks

Jerry Xu-MSFT 7,926 Reputation points

2020-08-07T08:32:36.237+00:00

Hi, have you tried any option I provide? Do any of them work for you?
Andrew Bitely 41 Reputation points

2021-02-25T12:51:03.817+00:00

I have the same issue and find the answers below hard to follow and I am a fairly advanced sharepoint user.

I find it very frustrating that you cannot do a look-up column from one site to another. Instead of a diverse and organized site collection with hubs and sub-sites like MS advocates you do, this forces you to put everything into one site. As an example, when making invoices, it would be great to have a look-up to our product list. Problem is, the master product list does not reside on the accounting site! Very frustrating that the only solutions to this question seem to involve custom code
Chan, Chiho 6 Reputation points

2021-05-20T20:43:57.527+00:00

Hi @Jerry Xu I am very close. For the custom KQL i Used https://org.sharepoint.com/sites/sitename/Lists/Fun%20Reporting/AllItems.aspx

It just gives me a LINK to the list, but does not actually itemize the listing.
Chan, Chiho 6 Reputation points

2021-05-20T20:44:04.217+00:00

Hi @Jerry Xu I am very close. For the custom KQL i Used https://org.sharepoint.com/sites/sitename/Lists/Fun%20Reporting/AllItems.aspx

It just gives me a LINK to the list, but does not actually itemize the listing.
Elizabeth 6 Reputation points

2022-09-16T15:58:43.073+00:00

Agree with AndewBitely-4032 that not being able to use look-up columns from another site makes no-sense. Having the lists on one site and then being able to use them across multiple sites for look-ups makes so much sense. Suppliers for example can be used across multiple sites for different things but currently you have to add them to all sites rather than a master list. Doesnt seem very logical.
Carl Williams 236 Reputation points

2023-04-25T15:02:38.29+00:00

I'm currently searching for the same thing. It's now 2023 and this IS STILL AN ISSUE???????????????????????

8 answers

Zollo, Nick 11 Reputation points

2021-05-24T18:57:49.72+00:00

For anyone still wondering about this, I just found a way that works for me. I just added an embed and within the settings for it I put the URL of where my list is located. It allows me to see the list and add new entries to it.
Please sign in to rate this answer.

2 people found this answer helpful.
Chan, Chiho 6 Reputation points

2021-05-24T19:32:18.217+00:00

this actually works. it's so simple i'm glad i know of it now.
Sign in to comment
Jerry Xu 256 Reputation points

2020-08-04T03:14:39.47+00:00

As you are using SharePoint Online, it depends whether you want to use a classic page or modern page.

For classic page, you may need to use a page viewer to display the list page, which is not a perfect solution. Or try to use SharePoint designer to do some hard coding for this.

In modern pages, as a admin, I will suggest you to use Highlight content web part to display contents from other site collections. You may need to create a custom CAML or KQL query for filtering.

For developers, have a try with SPFx ListView control.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
G99 31 Reputation points

2020-08-07T15:52:48.673+00:00

HI @Jerry Xu

Thanks I did not get an email to notify me of a response.
I am using the modern pages in the SPO sites.
Using Highlighted content webpart , firstly does not prompt me to select a list from another SPO site collection.
Secondly it does not appear I can display the entire list (or x amount of items) from another SPO site
Please sign in to rate this answer.
Jerry Xu-MSFT 7,926 Reputation points

2020-08-10T08:12:11.037+00:00

You will need to use custom Query for getting the list in a different site collection. We cannot do it out of the box. Just like the sample I made below. First select the site collection by URL. As I am using KQL, so I simply make the query as path: <URL of the list>, and configure the web part layout to be list. Change the number of items to be showed at a time if you have many list items.

Jan Pintelon 1 Reputation point

2021-02-18T19:05:46.687+00:00

Hi, using the Highlighted content webpart with the path: works perfectly -- now, I was just wondering whether it is also possible to select a specific view that's available in that list? Or if one could influence the columns to be shown in the query results?
Sign in to comment
G99 31 Reputation points

2020-08-10T12:12:14.357+00:00

Hmmm something is not working this is what I have done
On new page inserted Highlighted content webpart > Custom query > Select sites > entered sites URL > in query text (KQL):
path:
https://org.sharepoint.com/sites/SiteName/Lists/ListName

Clicked apply
I get the Most recent document list appear, which appears to be the default from my site.... and not the list from another site I want to display, what have i not done please
Please sign in to rate this answer.
Jerry Xu-MSFT 7,926 Reputation points

2020-08-11T02:37:10.923+00:00

Would you like to show us the web part settings with a screenshot? Have you tried to recreate a new web part?

Petter Warns 1 Reputation point

2022-09-17T20:38:17.75+00:00

Could be that patth: and the URL should be on the same line. No line break.
eg. path: https://org.sharepoint.com/sites/SiteName/Lists/ListName
Sign in to comment
G99 31 Reputation points

2020-08-11T10:23:06.763+00:00

Hi
Yes I have tried a few times, but same issue, please see attached
Please sign in to rate this answer.
Jerry Xu-MSFT 7,926 Reputation points

2020-08-12T09:29:39.337+00:00

Thanks for your patience and update. Have you tried other lists in that site collection? Do you have similar results returned? Have a try to search for the list. The reason I can think of will be :

The account you are using have no permission on that list

The list has not been crawled.

So please have a test with other lists you can access. Here is a new query which will only return list items: (path: https://org.sharepoint.com/sites/michael/Lists/listName) (contentclass:STS_ListItem)
Sign in to comment