Hi
I'd like to know if I can display a list from another site collection on a page, in another SPO site?
Thanks
Hi
I'd like to know if I can display a list from another site collection on a page, in another SPO site?
Thanks
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
Hi @JerryXu-9587 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.
Hi @JerryXu-9587 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.
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.
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
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. 
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?
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
Would you like to show us the web part settings with a screenshot? Have you tried to recreate a new web part?
Hi
Yes I have tried a few times, but same issue, please see attached

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)
HI, @JerryXu-MSFT - I have the same issues (as G99) - list content not showing. Could this be because I have enabled the rating function on the list and the site on which I want to show the list is on a communication site? Thanks!
My issue is solved as our admin has enabled 'rating' function on my communication site, so I just create the list on that site and it's solved. Thanks!
I have the same issue and am logged in as a global admin so permissions shouldn't be the issue.
Have you found a solution to this by any chance? I'm having the same issue.
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.

Embedding works for me to bring the full list into my subsite, but is it possible for me to display only 1 item from the list on my parent site into my subsite?
Using a URL to a filtered list and putting that into the Embed component works:
https://{org}.sharepoint.com/sites/{sitename}/Lists/{ListName}/AllItems.aspx?FilterField1=LinkTitle&FilterValue1={FilterValue}&FilterType1=Computed
Using this method you can also use the View ULR in the embed code.
Go to List Settings > Views > Edit View > Copy the Web address of this view: e.g. https://{org}.sharepoint.com/sites/{sitename}/Lists/{listname}/{viewname}.aspx > paste in to embed.
9 people are following this question.