40 - Get Files Names from a Folder Based on User Selection in Excel using Power Query

Video Description

In this video, I will show you how you can get all the file names based on what folder you have selected. Suppose you have multiple folders that keep getting updated with new files, you can create a drop-down with the names of the folders and use the technique shown in this video to get all the file names when you make a selection from the drop-down ✅ Power Query Course Download files: https://trumpexcel.com/course-download-files/ ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 ------------------------------------------------------------------------------ 0:00 Introduction 0:50 Create Drop-down in Excel 2:59 Fetch Data from Folder in Power Query 4:23 Change Privacy Settings to Fix Firewall Error 6:30 Alternative Solution: Modifying M Code 10:26 Make it Dynamic with VBA ------------------------------------------------------------------------------ #Excel #ExcelTips #ExcelTutorial