Forum Discussion

Regular Visitor

5 years ago

Solved

How to import sharepoint deeping folder?

I can enter Sharepoint:

let
    Source = SharePoint.Files("https://CompanyName-my.sharepoint.com/personal/Name_company_com/", [ApiVersion = 15])
in
    Source

But actual my file in more deeper folder , how to do？

Fowmy
5 years ago
luzwales

This link will be of help: https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder#:~:text=If%20you're%20connecting%20from%20Power%20Query%20Online%3A,an%20on%2Dpremises%20data%20gateway.

4 Replies

Fowmy
Super User
5 years ago
luzwales

This link will be of help: https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder#:~:text=If%20you're%20connecting%20from%20Power%20Query%20Online%3A,an%20on%2Dpremises%20data%20gateway.
- luzwales
  Regular Visitor
  5 years ago
  Why the URL address is wrong?
Anonymous
Not applicable
5 years ago
Hi,

You can specify the folder path /name

#"Filtered Rows" = Table.SelectRows(Source, each ([Folder Path] = " ")),

Thanks,
Shanthakumar.
- luzwales
  Regular Visitor
  5 years ago
  Source = SharePoint.Files("https://CompanyName-my.sharepoint.com/personal/Name_company_com/", [ApiVersion = 15])
  This URL only enter personal file folder, how to enter team folder?