Unanswered

Save .xls email attachment as .xlsx to File System

(1) Share

Report

Posted on by Community Power Pla...

Hi everyone,

My use case is -- I get an email twice a day that has an attached file (in .xls format) that I need to download and save to file system in a .xlsx format. I built a flow that downloads the attachment and it runs correctly when I simply save the attachment as an xls.

However, when I try to save the attachment as .xlsx by hardcoding the extension towards the end of file name ( like FileName = file1.xlsx) then it saves the file but the file itself gets corrupted, cannot open it. Is there any other way, any action I can use within flow to change the file format?

Thanks!

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

rsaikrishna

3,703 on at

Like (0)

Report

@Anonymous

There is no action readily available to convert the files from .xls to .xlsx.

You can use Power Automate template https://us.flow.microsoft.com/en-us/galleries/public/templates/8925727cb4f044e9b577f5ae111f2947/conv...

There is request for having an action for this conversion:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Convert-XLS-to-XLSX/idc-p/389466

To use Excel files with Power Automate:

a. The file should have .xlsx file extension.

b. The excel file should have a excel table as well to read the content of it.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

RobFischer 119 on at

Like (4)

Report

Saying this isn't possible is not a solution to the problem. Microsoft needs to address this!

Was this reply helpful? Yes No
hillpouner 4 on at

Like (0)

Report

Has this been resolved since your last post above?

Was this reply helpful? Yes No