Error The file is corrupt and cannot be opened > Using flow sending outlook email with attachment of a excel macro file from SharePoint/folder

(0) Share

Report

Posted on by BPP_P

My requirement is - To send a macro file as outlook attachment with some dynamic data from SharePoint/folder/macro file.
I am reading a excel/macro file from a SharePoint/folder/macro file then adding some rows.
After that I kept 10Sec delay.
Now I am reading the file metadata (using the path, and this I am getting from power app) and file content. And apend that to a array. Then I am sending email to someone.
File is sent successful to the outlook. But while opening that email attachments of this file. An error comes and it says "The file is corrupt and cannot be opened" .
But if I will open same file in SharePoint, it gets open perfectly and I can see newly added data by this flow.

Could you help me here to fix this.

error on the excel file --

after clicking yes, it says below

All responses (1)

Answers (1)

Verified answer

BPP_P 12 on at

Like (0)

Report

Re: Error The file is corrupt and cannot be opened > Using flow sending outlook email with attachment of a excel macro file from SharePoint/folder

Now I have fixed this by removing double quotes around the contentbytes inside the Append to Array variable in my above steps.