Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2021, 08:16 AM
kilroyscarnival kilroyscarnival is offline PowerQuery to get Folder File Contents listing Windows 10 PowerQuery to get Folder File Contents listing Office 2019
Expert
PowerQuery to get Folder File Contents listing
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default PowerQuery to get Folder File Contents listing

Hello,



I've been reviewing files of hard copies in order to purge old reports for which we have a PDF version on our shared drive. Because they're in separate rooms, I was trying to find a workaround so I wouldn't have to lug a file drawer of papers to my desk and back.

I found the option of using PowerQuery in Excel (we have 365) to list all the files in a folder. Since I know the start and end of the drawer, I used a temp folder to house only those digital files, and ran the query. It works pretty well for my purposes; I just have to whittle it down by filtering to the .pdf file types and then try to pick out the full reports.

The columns it gives me by default are Content, Name, Extension, Date Accessed, Date Modified, Date Created, Attributes, and Folder Path. Is there a way to get it to add File Size? That's not essential to what I'm doing but it would be very helpful.

Thanks,

Ann
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 365 delete reminder you can’t make change to contents of this-read only folder zillah Outlook 0 01-04-2021 01:54 PM
Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option Ismailc@parmalat.co.za Excel 0 09-16-2018 06:39 AM
PowerQuery to get Folder File Contents listing How capture a folder's file names to a file? BobKnepper Word 2 05-22-2016 07:30 AM
PowerQuery to get Folder File Contents listing printing contents of folder urkson Office 2 02-17-2012 07:45 PM
PowerQuery to get Folder File Contents listing Unsaved file contents retrieval Muthukrishnan V Word 1 09-17-2011 10:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft