Unanswered

Excel file corrupted when changing name

(0) Share

Report

Posted on by Community Power Pla...

Hello guys,

The idea of process that I want to build is: Get file via outlook -> save to sharepoint -> while saving change to custom name -> use the file to update Power BI report.

Where I have an issue is in changing files name. If for "File Name" I use "Attachments Name" everything is fine, but when I enter something custom file gets corrupted. The original file's name is "IE96 Stock Report_28Sep2022_000426.xls" when in this part I try to change to save as Excel.xls:

The file gets corrupted:

When I open it the data is all messed up. The idea here why I want to rename it because everyday the name of attachment will change so for power bi to use the correct file I want to have a basic naming for it.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-chengfen-msft on at

Like (0)

Report

Hi @Anonymous ,

The reason for the Excel file corrupted is caused by the file extension and file content is not valid

Maybe you could try:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello, I tried both .xls and .xlsx extentions, both give the same result

Was this reply helpful? Yes No
v-chengfen-msft on at

Like (0)

Report

Hi @Anonymous ,
Could you please try changing the include attachments option on the trigger to YES and on the create file action in the file content instead of directly passing the attachment content pass it in a binary format. For that you can use the expression base64tobinary("AttachmentContent").

Best Regards
Cheng Feng

Was this reply helpful? Yes No