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,931 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 46 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

Adrienne Laan 1 Reputation point

2021-04-09T09:45:07.783+00:00

HI, @Jerry Xu-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!
Please sign in to rate this answer.
Adrienne Laan 1 Reputation point

2021-04-19T06:24:34.497+00:00

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!
Sign in to comment
Christine Offner 1 Reputation point

2021-04-16T17:21:23.907+00:00

I have the same issue and am logged in as a global admin so permissions shouldn't be the issue.
Please sign in to rate this answer.
JFlores 1 Reputation point

2021-06-01T18:11:23.52+00:00

Have you found a solution to this by any chance? I'm having the same issue.
Sign in to comment
ErinKK 1 Reputation point

2022-02-04T22:45:20.397+00:00

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?
Please sign in to rate this answer.
Sebastian Fuss 1 Reputation point

2022-02-07T17:15:13.147+00:00

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

Scrace, Tom 1 Reputation point

2022-08-04T15:11:49.773+00:00

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.
Sign in to comment

Share via

Display list from another site collection

8 answers