Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 02-23-2023, 06:32 AM
kilroyscarnival kilroyscarnival is offline Power Query to get a list of folders (not files) in a location? Windows 10 Power Query to get a list of folders (not files) in a location? Office 2021
Expert
Power Query to get a list of folders (not files) in a location?
 
Join Date: May 2019
Posts: 361
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by p45cal View Post
How extensive are the folders below FPath?
Are we talking urls, sharepoint, or just the local hard drive?
It's a rather large shared drive (1.99 TB) with lots of sub-folders and sub-sub folders. The funny thing is that the regular Power Query search from which I filtered for the folder paths that have *Invoices\ in them doesn't take nearly that long, so I guess your method is more complex. Appreciated, but I think it's just not going to be practical. I don't think it's a credentials issue, though.

Quote:
Originally Posted by p45cal View Post
The path in the named range FPath is used as a top, starting folder, but it doesn't have to be; the query could use it differently, but I don't think it would necessarily speed things up. The query I showed doesn't try to process further the results - I wpould expect the query to be added to for that. It was only meant as a starting point.
Yup, last night I pulled it back up before I left and I attempted to add a filter to the results. It had all night to run, but I must have done something wrong as it came up empty. I'm tending to think I'll go with what I have, and if I need to look up a few file paths manually that were empty folders, I'll just keep those results in a file so I won't need to do too much in any month.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel power query help ganesang Excel Programming 0 09-20-2021 01:50 AM
Browse, search and copy files from one location to another based on the list given in excel sheet us nmkhan3010 Excel Programming 2 09-07-2020 10:27 AM
Do I need a power query for this one? shabbaranks Excel 5 04-10-2019 03:29 AM
Query and Power Query not working Excel 2016 bl10 Excel 0 07-22-2016 06:25 PM
list folders and files using .vbs file josianne Excel Programming 3 08-18-2014 03:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft