Forum Discussion
AdministratorLoad multiple files across 2 sharepoint folders
I want to combine data from 10 workbooks from 2 different sharepoint/teams folders.
I currently have 2 queries which merge the files within each location (5 & 5) however given that all files have the same headers and can be combined i was wondering if it was possible to enable the power query to search within 2 sources, before loading and combining my selected files from both sharepoint folders
Below shows the first step of the query for each sharepoint, which loads all files in the sharepoint. I want to add the two "sharepoint folders" together. Is this possible?
= SharePoint.Files("https://testurl.com/teams/testurl_1585829620694", [ApiVersion = 15])
= SharePoint.Files("https://testurl.com/teams/testurl_1585584087000", [ApiVersion = 15])
Thanks for help. This did not work however by Appending the 2 queries together this worked
4 Replies
- mussaenda
Community Champion
Syndicate_Adminit is not the same sharepoint site so that's why i wasn't sure if it is possible
- mussaenda
Hi Syndicate_Admin ,
What I can suggest is, get the two sources separately and before combining the files, append them.
I am not sure if my suggestion will help you but that is the closest I can think of
- Syndicate_Admin
Thanks for help. This did not work however by Appending the 2 queries together this worked
