Question: Does "read N files from Sharepoint-folder" work for N=1?

Question

Hello there,I want to load one file only(!) using the Read-(and combine)-Multiple-Files-From-Sharepoint-Folder"-Functionality.It seems that tis does not work for N=1, only for N&gt;1.Can you please comment on this?&nbsp;Reason why I am asking:on an unregularily base I receive 1 CSV-File that needs to be integrated into reporting.Unfortunately the file name contains a date, which needs to be handled with a workaround before loading to SP-Folder.I would like to get rid of this workaround and tried the Read-Multiple-Approach.Do you have any idea(s)?&nbsp;thx in advanceThomas

anonymous · Accepted Answer

Hi&nbsp;thomasreick&nbsp;,
&nbsp;
The "Read Multiple Files from SharePoint Folder" functionality is designed to read multiple files from a folder, and it may not work for a single file. However, you can still use the SharePoint connector to read a single file from a folder. Here is an example of how to read a single file from a SharePoint folder using the SharePoint connector:
&nbsp;
let
    Source = SharePoint.Files("https://yoursharepointsite.sharepoint.com/sites/yourfolder/"),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Name] = "yourfile.csv")),
    #"Content" = #"Filtered Rows"{0}[Content]
in
    #"Content"
&nbsp;
Replace "https://yoursharepointsite.sharepoint.com/sites/yourfolder/" with the URL of your SharePoint site and folder, and replace "yourfile.csv" with the name of your file. This code will read the content of the file into a table.
&nbsp;
Hope it helps.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Question: Does "read N files from Sharepoint-folder" work for N=1?

2 Replies

Related content

Sharepoint Folder Query "Error"

How to connect my Sharepoint folder "My Files" folder through PBI Desktop using SharePoint Folder?

Issue to get Data from "SharePoint Folder"

Get Data "From Folder" from Sharepoint Folder

Taking over Dataflow Gen2 but still "Read Only"