How to open Excel content of the first row in Advanced Editor

[jaliu1290]

Hello Power Query Community!

I have a data source where I am opening an Excel workbook stored in a Sharepoint.

An updated version of this data is added in a new Excel in the same folder each week, so I want Power Query to open the "Binary" under "Contents" for only the most recently updated version.

To do this I sorted the tables after the Navigation step by "Date modified" in descending order so that the file I want is always in the first row (which leads to step called Sorted Rows).

Currently the code as is this:

#"File Feb 24 2025 xlsx" = #"Sorted Rows"{[Name="File Feb 24 2025.xlsx"]}[Content],

How do I make it like this?

#"First File" = #"Sorted Rows"{[ ______________ ]}[Content],

Thanks in advance!

Jamie

[PwerQueryKees · Accepted solution]

#"First File" = #"Sorted Rows"{0}[Content],

[jaliu1290]

This community is incredible... Thank you Kees!!