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

p45cal · #7 02-20-2023, 08:43 AM

Quote:

Originally Posted by kilroyscarnival

My wrinkle is that I actually need the subfolders for invoices in each of the project folders. I am able to do that in Power Query, except for the few Invoices files that don't yet have invoices in them.
<snip>
I have tinkered around with the setup you shared, and I can only get it to list the main folders on the drive.

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.

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