How to get the latest file from a SharePoint folder

[GuinabaPBI]

Hi all,

I am trying to get the latest file from a SharePoint folder, using the path below:

= SharePoint.Files("https://XXXX.sharepoint.com/:f:/r/sites/SCOperatingSystem/PlanningSpace/Supply%20Planning/00%20-%20D...", [ApiVersion = 15])

However, I am getting the following Error Msg:

DataFormat.Error: The input URL is invalid. Please provide a URL to the root of a SharePoint site, or to the service document or entity of its OData feed (with no query or fragment part).
Details:
https://XXXX.sharepoint.com/:f:/r/sites/SCOperatingSystem/PlanningSpace/Supply%20Planning/00%20-%20D...

If I use this path: https://XXXX.sharepoint.com/:f:/r/sites/SCOperatingSystem/PlanningSpace there is no issue but not sure how I can select the next folder: Supply Planning 

Cheers

[amitchandak · Accepted solution]

@GuinabaPBI , refer to the code given for similar solution, if that can help

https://community.powerbi.com/t5/Power-Query/How-can-I-pick-the-latest-file-with-Power-Query/td-p/14...