Show list row on SharePoint sub site

[ymmas]

Hello!

I am wondering if there is any way to show rows from a list on multiple different SharePoint subsites.

We have a list with customers and in that list there is also columns with values (different values on different customers).

We would like to show a specific row of values on the customers subsite, based on a unique id in one of the columns in the list. 

Thank you in advance!

[#2]

Hello @ymmas

not sure if I understand you correctly, but for that you can use PnP Modern Search Web Parts: https://microsoft-search.github.io/pnp-modern-search/

With search you can show items, or columns, across sites or sub webs, also possible with dynamic values as search query parameter.

Best, Dave

[#3]

Hi @David Mehr - thank you for the reply!

Sorry for that weak description of my problem. I will try to make it more clear.

We have SharePoint List with multiple customers in i.
One customer for ever row in the list, with the same columns but different values in those columns.

I try to show it in this table below:

Customer	Customer SharePointsite URL	Sales contact	Use Teams
Contoso	www.ourdomain.sharepoint.com/sites/customers/contoso	Jim	Yes
Microsoft	www.ourdomain.sharepoint.com/sites/customers/microsoft	Kim	No

The thing I want to achive is to present the values in the list at every separate customer sharepoint site.

For example on SharePoint site www.ourdomain.sharepoint.com/sites/customers/microsoft I want the info below to be seen:

Customer	Customer SharePointsite URL	Sales contact	Use Teams
Microsoft	www.ourdomain.sharepoint.com/sites/customers/microsoft	Kim	No

[#4]

Hello @ymmas 

yes sure, with search you can show every element with columns on the site you like.  

From a list you can show with the PnP Modern Search Results Web Part the elements you want on an other site. The columns are also customizable, but not on the screen below:

It's a simple query like this:

{searchTerms} path:https://<TENANT>/sites/SPOMarketing/Lists/CustomerList/ contentclass:STS_Listitem Title:Contoso

You can find different scenarios with PnP Modern Search Web Parts here: https://microsoft-search.github.io/pnp-modern-search/scenarios/

Best, Dave