Forum Discussion

campelliann's avatar
campelliann
Post Patron
4 years ago
Solved

How to Extract First File from Folder if the file name changes.

Hi there,


So I am basically extracting the first file from a folder with power query. I use Sharepoint.Contents, and then sort by descending the modified date and keep the first row.

The issue is when I grab the content, the M Query retains the file name (Oldfile.xlsx). But Imagine the user changes the name to NewFile.xlsx the code will still have:

#"Sorted Rows"{[Name="Oldfile.xlx"]}[Content]


Thanks

2 Replies