Sharepoint multiple Folders read data

Question

Hi,&nbsp;I am looking for connecting the Share Point folder and getting the high-level data but the Sharepoint online list does not give me exact folder data inside the folders. Please Help!&nbsp;From the below SharePoint folder- I need to read data from 3 folders which has columns with data (2nd page) -&nbsp;&nbsp;

kt_bsmart2gethe · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
As per the screenshot, the list only contains Microsoft Word documents not supported in PQ. You can only be able to import documents type as per your second screentshot.
&nbsp;
To combine files, you must apply the filter for the same document type (e.g. xlsx / xls).
&nbsp;
Regards
KT

anonymous · Answer

I followed the&nbsp;https://docs.microsoft.com/en-us/power-query/connectors/sharepointonlinelist&nbsp;but getting below error as I have Docx in my folder it's unable to read that data&nbsp;

kt_bsmart2gethe · Answer

Hi Anonymous&nbsp;,
&nbsp;
Use Sharepoint folder connector and apply filter to get the list you need.&nbsp;
&nbsp;
Regards
KT
&nbsp;

anonymous · Answer

I used and I get above error. As my folder has too many files.&nbsp;structure looks like -&nbsp;Shared Document &gt; folder1 &gt; folder-2 &gt; files(has docx, xls), folder3, archives

mussaenda · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
you may need to filter also the data types that you only need to resolve the issue&nbsp;

Forum Discussion

Sharepoint multiple Folders read data

8 Replies

Related content

Merge data from multiple excel files from multiple sharepoint folders

Sharepoint Folder

Navigating Sharepoint Folders Containing Apostrophes

Connecting Sharepoint Folder to PowerBI

Sharepoint Folder Connection – Access Required