Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

What is the Transform File from Query doing?

After importing a Sharepoint Folder I got this new query showing on my queries list.   What is it doing? I guess it has been created automatically? Can I get rid of it?        
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

thanks MarcelBeug, that makes sense.

I was trying to do that on my other post but could not get it to work.

 

Any ideas on why do I get that error? and how to correct it?

Stachu's avatar
Stachu
Community Champion
8 years ago

I had similar issue recently, the problem is different syntax for connecting to local folder vs Sharepoint

 

Connecting to folder creates following syntax:

let

Source = Folder.Files(txtPath)

 

 

When you connect to Sharepoint it's a bit different:

let

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

 

Sharepoint gives the list of all documents in the site, so to get to proper subfolder you need this additional step

#"Filtered Rows" = Table.SelectRows(Source, each ([Folder Path] = "https://domain.sharepoint.com/sites/yoursite/" & txtSubFolderPath))