Ignore string (date) at the end of file name when connecting Power Query

[nokoyman]

Is there a way to ignore a string at the end of a file name stored in a SharePoint folder when connecting Power Query? In this case the file name is "Construction Progress_yyyymmdd.xslx", a date is appended to the end every time it is updated. The is the only file in the folder, old files are moved to an Archive in the same main folder. Thank you for the help.

 

[ExcelToDAX]

What do you mean by ignore? You can split column by delimiter "_" so it will just say Construction Progress

 

[nokoyman]

I am referring to the source statement in Power Query like below. The last string is the date the file was updated, when this change the connection is broken. So my question is how to ignore the dates so the connection is not broken when date is changed.

= Excel.Workbook(Web.Contents("https://companycorp.sharepoint.com/...ion/Construction Progress (20230530 7AM).xlsx"), null, true)

Thank you very much