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
MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

If I understand your posts correctly, you only want to change the source from a local folder to a sharepoint folder, so basically, both folders have the same (type of) content.

 

If you go back to your working version (with the local folder), you need to adjust the source folder in 2 places:

1. In your main query (Toggl).

2. In query "Sample File".

 

That should solve your issue.

 

 

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?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    You need to find out what the errors exactly are in the error message. Then correct them. 

     

    Best Regards,

    Dale

  • 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))