Using a SharePoint Folder as a datasource

[TakedaBill]

I have a number of CSV files in a SharePoint folder that I would like to combine and use as a datasource much the same way you can use the Folder connector.  But, when I select SharePoint Folder, it only wants the root URL for the site not including subfolders.  The site contains a ton of other stuff that I dont want to combine and then filter out afterwards.

How can I acces the files in a particular subfolder?

[SimonAurizon]

I had the same issue.

In the end, I initially allowed it to load the whole SharePoint subsite and then went into the advanced editor and fixed it up in there:

Under the:

Source = SharePoint.Files("https://acme.sharepoint.com/sites/MySubsite", [ApiVersion = 15]),

line, I added an additional line:

#"Filtered Rows" = Table.SelectRows(Source, each ([Folder Path] = "https://acme.sharepoint.com/sites/MySubsite/Shared Documents/General/FolderName/")), including the comma at the end.

And changed the next line down, that was referencing Source, to reference #"Filtered Rows".

And that seemed to work.

[MFelix · Accepted solution]

Hi @TakedaBill ,

When using the Sharepoint folder you need to give the root folder (as you refer) the trick for this is then to select a file for the function that is on the folder you need to make the transformation, and when you go to the query where the implementation of the function is made, right after the first step (where you have all the information of the files/folders) you filter out by file location only the folder you need.

So you are not filtering at the first step but is still doable.

Believe this is a limitation of the connector.