Hi,
I have a file saved on Sharepoint and updated daily with the filename ending with YYYYMMDD. For example:
= Excel.Workbook(Web.Contents("https://sharepoint.com/teams/Test Report 20220228.xlsx"), null, true)
I would like to be able to amend the above code so everyday when I open the file the source filename updates to the current date. I searched for DateTime.LocalNow() but unsure how to incorporate the code so it shows /Test Report YYYYMMDD.xlsx at the end. If the code can include the "space" after the word Report too that would be much appreciated.
Many Thanks,
Joey
I have a file saved on Sharepoint and updated daily with the filename ending with YYYYMMDD. For example:
= Excel.Workbook(Web.Contents("https://sharepoint.com/teams/Test Report 20220228.xlsx"), null, true)
I would like to be able to amend the above code so everyday when I open the file the source filename updates to the current date. I searched for DateTime.LocalNow() but unsure how to incorporate the code so it shows /Test Report YYYYMMDD.xlsx at the end. If the code can include the "space" after the word Report too that would be much appreciated.
Many Thanks,
Joey