Filter/ Source newest Excel File

[joshua1990]

Hello everyone!

I have a Sharepoint-Folder that contains for every week an Excel File.

This files have specific name like "SalesEDT202001012200"

Now I would like to extract/ source data just from the newest file.

How is this possible if there is always a new file with a new name?

Best Regards

[amitchandak]

@joshua1990 , refer https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

[ziying35 · Accepted solution]

Hi, @joshua1990 

You can import from a folder, and then query the code like this:

let
    Source = Folder.Files("D:\temp"),
    splCol = Table.SplitColumn(
                 Source, 
                 "Name", 
                 each {_, DateTime.From(
                              Number.ToText(
                                  Number.From(Text.BetweenDelimiters(_,"SalesEDT",".xlsx")),
                                  "0000-00-00 00:00"
                              )
                          )
                       },
                {"Name", "DateTime"}
              ),
    filter = Table.SelectRows(splCol, let latest = List.Max(splCol[DateTime]) in each [DateTime] = latest)
in
    filter

I am following the example file name you provided to split the time text into real time values to form a new column, and finally by filtering the latest time to get the final file to be processed

If my code solves your problem, please mark it as a solution!

[Fowmy]

@joshua1990 

When you use GET DATA from Power Query, use Files From Folder. 
Apply the following filter to get the latest file like below.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn