Forum Discussion
Importing Specific csv files from a folder.
I want to import specific .csv files from a folder and need it to be dynamic so i dont have to move any files or change the name file. I also need the dates to dyamically move on each month so once w...
Hi Mikey575 - Yes there is. If you connect to the excel file using the File.Contents - PowerQuery M | Microsoft Learn or SharePoint.Files - PowerQuery M | Microsoft Learn you will be provided with all the Excel files in the selected folder path. This is presented in a standard table, so you can apply transformations to filename. This will allow you to find add a column with Date of the file. You can then apply any filters to select files.
Anonymous Thank you for your respose Daryl. I could get what you suggested to work but i can see its on the right lines. Please could you give me some more detail?