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
