Unite SharePoint Lists from Project Online Sites

[barakb32]

Hello,

Project Online generates a new SharePoint Online site for each project based on a template.

We have modified the template to include a list called "Action Items".

I would like Power Query to unite all the "Action Items" lists from all the project site.

Ideally, it would identify automatically when a new site is created.

Alternatively, the new site will be added to a master list, but Power Query still needs to know to read the master list and coonect to each URL in the master list.

Can this be done?

Thanks,

Barak 

[Greg_Deckler]

Appending all of the lists together, yes, but automated, I do not believe so at present without some custom programming. I believe that the only query type that does what you are referring to is Folder, you point it to a folder and it processes all files in that folder automatically.