cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FlowUser110
New Member

Save .xls email attachment as .xlsx to File System

saveEmailAtt.PNGHi 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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
rsaikrishna
Community Champion
Community Champion

@FlowUser110 

 

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 SolutionMarking 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.

View solution in original post

3 REPLIES 3
rsaikrishna
Community Champion
Community Champion

@FlowUser110 

 

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 SolutionMarking 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.
RobFischer
Advocate II
Advocate II

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

Has this been resolved since your last post above?  

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,110)