View Single Post
 
Old 02-17-2023, 10:20 AM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 346
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
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
Code:
dir -n > dirlist.txt
, 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).
Reply With Quote