Forum Discussion
SharePoint.Contents unable to combine current folder and sub folder files
Filter out the rows where Extension is null.
What made you choose SharePoint.Contents over SharePoint.Files ?
I am trying to consolidate all files in the parent folder and all files in sub folders. So filtering out is not what I want.
I heard .content speeds up consolidation, and I want to try it out since .files is taking 30 ish mins to refresh my large dataset atm.
.Contents does not give you the full inventory - you need to do the navigation yourself.
.Files usually works. What types of files are you processing?
.xlsx
This is the folder structure
x/ (Parent folder) ├── file1.xlsx ├── file2.xlsx ├── file3.xlsx │ └── historical/ (Subfolder of x) ├── 2019/ (Subfolder of historical) │ ├── January/ (Subfolder of 2019) │ │ ├── file.xlsx │ │ └── ... │ ├── February/ (Subfolder of 2019) │ │ ├── file.xlsx │ │ └── ... │ ├── ... │ └── December/ (Subfolder of 2019) │ ├── file.xlsx │ └── ... ├── 2020/ (Subfolder of historical) │ ├── January/ (Subfolder of 2020) │ │ ├── file.xlsx │ │ └── ... │ ├── February/ (Subfolder of 2020) │ │ ├── file.xlsx │ │ └── ... │ ├── ... │ └── December/ (Subfolder of 2020) │ ├── file.xlsx │ └── ... ├── 2021/ (Subfolder of historical) │ ├── January/ (Subfolder of 2021) │ │ ├── file.xlsx │ │ └── ... │ ├── February/ (Subfolder of 2021) │ │ ├── file.xlsx │ │ └── ... │ ├── ... │ └── December/ (Subfolder of 2021) │ ├── file.xlsx │ └── ... etc...
if I am in parent folder its files show as binary but historical shows as table and I can't combine like the image shown in OP. if I go in historical everything shows as table but I am able to combine without navigating to the specific sub folders (years and months). So my only two options are either combine the files in the parent folder, or all the files in the historical folder.Nothing wrong with running two separate queries and then appending them.