Forum Discussion
Solved
When the file name changes depending on the date
Hello, from Japan If the file name changes depending on the date, can I fix it by modifying the code? For example, in the case of today, an expression describing yesterday's date is placed. G...
let
partDate=DateTime.ToText(Date.AddDays( DateTime.LocalNow(),-1), "yyyy-MM-dd"),
Origine = Excel.Workbook(Web.Contents("https://www.aaa.com/files/documents/worldwide-"& partDate & ".xlsx"), null, true)
in Origine
Is there any thing you can do when the new date to the file is unknown? I.e. the file is named with the date it was updated however you don't know when the data source will be updated each time.