Forum Discussion

CDavies's avatar
CDavies
Resolver I
6 years ago
Solved

Aggregate lists from SharePoint sites

Hi This question does not seem tot have a decent answer for, either that or my google has broken 🙂   I need to return a list of sharepoint subsites from a root site that have a list with a standa...
Need Help
  • CDavies's avatar
    CDavies
    6 years ago

    To any one else who needs this I managed to get his working with a two stage approach:

     

    1.  Create a list in SharePoint with the names of the subsites that the users can manage

    2.  Used a function in Power Query to return all of the Lists from within the subsites from 1.

     

    Thanks

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi CDavies 

As tested with Sharepoint online list connector, i can't connect to all lists inside all subsites at one time.

It may need to connect to lists inside one subsite  and connect to lists inside another subsite.

 

Best Regards

Maggie

CDavies's avatar
CDavies
Resolver I
6 years ago

To any one else who needs this I managed to get his working with a two stage approach:

 

1.  Create a list in SharePoint with the names of the subsites that the users can manage

2.  Used a function in Power Query to return all of the Lists from within the subsites from 1.

 

Thanks