Hi @farhandsome
There are a couple of ways to do this depending on when the Excel file is been generated (schedule wise)
If SAP is producing the report at a similar time that you want to update Sharepoint, instead of using a scheduled flow you could consider triggering the flow when a new file is created. This way you wouldn't need to worry about selecting the correct file as the details for the file would come through in the trigger
However if you want run it based on a schedule then it gets a little bit trickier. It looks like the max function requires integers / numbers to find the highest value. So the date would need to be converted to a number first using the ticks expression and then once the maximum tick is found you can filter the list of files to select the correct one
You should then be able to use the delete item action and delete all the items
You can then loop through the rows of the table and insert them into the Sharepoint list
If you want to look a having the trigger run when the file is created let me know and I can provide some help with that option instead
