Forum Discussion
Over 45+ folder structures to pull .txt/.csv file from via Power Query
INTRO: My mission is to pull the most recent file from various folders that are sent from the PAYOR and organize them by the most recent date per payor. Then I must pull the values for TOTALS PAID b...
Sure--I must connect to 48 folders to pull the latest .csv file
ex: Step 1 = add Folder
Step 2 = set up custom filter so it pulls after October (3 months prior from today)
- connect to the main share only, not to the subfolders
- have a list of all the subfolders
- iterate through them and fetch a list of all the files in these folders that match your criteria
- fetch the files as needed.