Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
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.
User | Count |
---|---|
20 | |
10 | |
10 | |
9 | |
7 |