Power Query to get a list of folders (not files) in a location?

kilroyscarnival · #8 02-20-2023, 02:40 PM

Quote:

Originally Posted by p45cal

If you've done (or started) this with a powershell command, what was the command, because command you've shown only returns the top level of folders?
Are we talking only one level down of subfolders?

Otherwise I'll have an explore in the coming days.

Yes, for the most part they are usually just one level down. It'd be like \\Projects\\J1234G State Road 567 at Pine Street Intersection\Invoices\

You're right, I think I just grabbed the wrong Powershell command line that I keep in Outlook Notes. That's the one I used to get the names of all the PDFs of the invoices, which I have changed to doing by PQ. The Powershell command that yields literally everything in the main folder (recursive) is:

Code:

dir -n -r > dirlist.txt

And that yields a lot of rows of data, which I then filter in Excel for anything that ends in "Invoice" and end up concatenating the rest of the file path in.

I suppose the other thing I could do is search out the few ...\Invoices\ subfolders that are empty and place a small dummy file in them?

I think I'm like 90% there, so I'm not that worried about it.

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