Forum Discussion
Accessing multiple files in our organizational SharePoint site
Hi latingraduate07 - you could consider starting with the following:
Source = SharePoint.Files( "https://ORGNAME.sharepoint.com/sites/TEAM'S GRP NAME" , [ApiVersion=15])
You will be represented with Table contain all the files in SharePoint. You can now apply filters to the FolderPath and FileName columns to select the individual file. Note this approach remove any Credential issues because access will be based on the SharePoint site rather than individual Excel file.
Filter = Table.SelectRows(Source, each Text.Contains( [FolderPath] , "ABC" ) and [FileName] = "xyx")
Use the Excel Workbook to open the Binary Filter.
OpenFile = Excel.Workbook(Filter)
It sounds like you need to find the relevant tables or sheets from each file rather than combinse. But you should be able to use the Power Query to create a Reference or Duplicate query from the above steps.
Once you are happy, you may consider changing these into functions, so that you can combined multiples file across several months by removing the folder filter or use a parameter to change the month.
Thank you so much for your response, however, I am a new Power Query user and have pretty much self taught via youtube videos. I am not familiar with your solution ( I apologize). If you are able to provide a step by step process, It would be greatly appreciated!