Hello,
I am trying to create a excel file using a template and script. The file is saved in sharepoint and then sent out in an email.
I create a flow to perform these tasks. and the flow works and the file and emails are processed. However I am not able to open the .xlsx attachment.
The error opening on the attached .xlsx file in the email is "Excel cannot open the file ******.xlsx because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. "
The error opening through sharepoint is " This workbook couldnt be opened because the file format may not be matching the file extension"
These are the flow steps:
Associate enters results in a form.
Flow
Step 1 Get responses
Step 2 Add rows to table ( not using table currently - will be at a later date)
Step 3 Get file metadata from a template I created ( have tried both; getting the file from one drive and from Sharepoint)
Step 4 Create a file into SharePoint folder
Step 5 Run Script
Step 6 Get File Content
Step 7 Send Email
Whichever way I create this Flow. Get data from sharepoint template, excel template, or one drive. I keep getting the same error message when trying to open the .xlsx file attached on the email and opening through sharepoint .
I have checked the file extension. I have checked the access to the files were granted correctly, I have read response in the forum and outside the forum for days and have tried everything suggested that I could understand. Help
