Does this help?:


Get the List of FOLDERS only in Power BI using Power Query - RADACAD
Get the List of FOLDERS only in Power BI using Power Query - RADACAD

Thanks, p45cal, I can see that would work, but since I have no other current use for Power BI, I would be installing it for a single use.

What I'd been using thus far is a Powershell command , which works for my purpose, except for having to import the resulting text into Excel and then do a separate parsing to get only the Project number in a separate column next to the full name. Thought maybe PQ could do that more readily, and also be refreshed. All things being equal, I will probably just do the PQ and know I'll have a few missing \Invoices\ subfolders when the first invoices come out (due to their being empty).