Forum Discussion
Get Excel data from several sharepoint folders
So I finally managed to get all the data from the different folders in Sharepoint.
What ended up being the solution was setting up individual queries for each of the sharepoint folders, then appending them all as one new query.
From there I used jennratten's tip on text filters, and was left with only the files I wanted.
I'm glad this info was helpful. To answer your question, when you query the organization's root, you only get the files that are shared at the organization level, not any underlying Team sites. In the example below, first I have queried the org root and see only 24 files and then query for a Team site and see over 1000 files which include all files for the Team (less files within private channels).
Org Files (unfortunately no hierarchy is included that can be expanded)
Team Files
If you create a table with a column containing the Team site names, I can help you use one query to connect to each.
Thanks for further clarifying, very useful information!
Appreciate the offer of a single query, but it works allright the way its set up now 🙂
Again, thanks for the great help!