Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using a SharePoint Folder as a datasource

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 ...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    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.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

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.