Forum Discussion
SharePoint.Contents unable to combine current folder and sub folder files
When I navigate to a folder using the navigation step, I am unable to combine files in the content column because sub folders are showing as "table" instead of "binary" unless I drill down to a speci...
.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.