Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
barakb32
Advocate I
Advocate I

Unite SharePoint Lists from Project Online Sites

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 

1 REPLY 1
Greg_Deckler
Super User
Super User

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors