Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |