Convert xls file to xlsx in One-drive

(1) Share

Report

Posted on by sgoyal0207

Hi ladies and gentlemen,

I am looking to build a flow to convert an "xls" file in One-drive to "xlsx" in One-drive.

Does anyone know to create a flow? Any leads will be helpful.

Kind regards,

Sahil Goyal

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

sgoyal0207 34 on at

Like (0)

Report
Copy link

Link copied!

Hi all,

Any suggestion on my request.

Kind regards,
Sahil Goyal

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @sgoyal0207 ,

I have made a test for your reference.

1. Here is my folder.

2. Here is my Flow.

replace(items('Apply_to_each')?['Name'],'.xls','.xlsx')

Result Screenshot:

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
sgoyal0207 34 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your solution. After trying this, I get the file in xlsx format but when I tried to open it. It shows an error.

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sgoyal0207 ,

Sorry, I realized that I provided the wrong answer.

I referenced this post and applied similar logic, now it seems like it may not work in every situation.

Here are some other links that might help you:

https://www.bigmountainanalytics.com/how-to-convert-xls-to-xlsx-with-power-automate-desktop/

https://powerautomate.microsoft.com/en-us/templates/details/8925727cb4f044e9b577f5ae111f2947/convert-xls-files-to-xlsx-using-ui-flows/

Sorry for any inconvenience.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
sgoyal0207 34 on at

Like (0)

Report
Copy link

Link copied!

Thanks!!
The first video in which using a power automate desktop - I have tried it but it is manually triggered.
The 2nd video - I will go through it.

Was this reply helpful? Yes No