Show Custom list in its Parent Site home page

Question

Hi,

I have created a new site collection ( Team Site modren ) under this it has below hierarchy

Root Site (Country) (level 1 )>Sub Site 1 (State)(level 2) > City1_Site1 (level 3) , City2_Site2 (level 3)

it has more sites to go.

1. At level 1 Site i created a custom list example: Products
2. At Level 3 Sites i created custom list Sales and it has lookup column ( Product ID ) based on this column i am showing Product name also in this Sales list.

Here

1. At Level 1 Root site in Country Home page how can i show Sales from all Cities sites
2. When User belongs to City1_Site1 user login he can only create Sales items in Sales List based on his product only

Answer 1

Hi @adil，

Per my test, currently one webpart could only display one list. If you have several lists, you will need to create multiple embed webparts. You will just need to paste the URL of the list inside the Embed window

Here is the document for more details

https://support.microsoft.com/en-us/office/add-content-to-your-page-using-the-embed-web-part-721f3b2f-437f-45ef-ac4e-df29dba74de8

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.