We have a flow setup to do the follow...
- Automated email comes through with an XLSX file attached, at different times of the day
- The previous XLSX is deleted from SharePoint
- The attachment is the saved in the same location with the same name
What needs to happen next is the Excel Sheet name needs changing as the report comes through with a different one depending on the date. This is so Power BI can see the data as it expects it to.
I creased an OSTS file that renames the sheet and does work.
I created a manual flow to test this script being ran against the same spreadsheet and it works as expected.
When running on the production flow it fails 'The file format is not recognized. Please check that the selected workbook is valid
Why would the file type be working with a manual trigger but not a scheduled one? That is the only difference, everything else is the same.
Could the issue be with the action triggering a newly created file? I set a delay of 10 seconds but that did nothing.