I'm looking to get a list of all folders on a particular drive, whether or not they have contents. So far I've been using PowerShell, but it's clunky and takes a bit of time.

I tried PowerQuery on a folder, and I get a resulting list of files. I can remove duplicates on the folder path column, but as far as I can tell it won't yield any folders that don't already have files in them.

Am I missing a way?

Thanks,

Ann