Unanswered

Change file extension in Power Automate

Like (0) Share

Report

Posted on 16 Aug 2023 06:26:08 by Community Power Pla...

Hi All,

I have to change the File Extension in the Power Automate flow, For example, if the User is uploading a file with a .doc extension then it should change into a .docx extension with the file content presented inside the file. Finally, upload it into the SharePoint Documents. Also, I shouldn't generate the Prebuild templates, because by default it is generated in .docx format. Similarly, if the user uploads a file with .ppt it should change to .pptx and for .xls to .xlsx Is there any way to achieve it?

Appreciate your suggestion.

Any ideas?

Thanks.

All responses (7)

Answers (0)

e.evseychik 42 on 23 Dec 2024 at 08:17:39

Like (0)

Report
Change file extension in Power Automate

A small addition to SamLed's reply. Plumsail Documents is not a premium connector but a third-party tool with separate pricing. You can use it with any plan in Power Automate if your Plumsail account has a paid plan. Also, after registering, you will have a free 30-day trial without providing any payment information so you can test it first and decide whether and how effectively it solves the issue.

As regards the problem itself, this article describes how to convert files in bulk to the modern Office formats. Basing on it, I suggest the following flow:

Trigger the flow on file creation in a SharePoint library.

Add a switch control. Its input is an expression that splits the file name with extension by period and takes the last part. Cases are possible old formats.
last(split(triggerOutputs()?['body/{FilenameWithExtension}'], '.'))

In each case, get the file content using the trigger output, convert it to DOCX, and save the converted file.
SamLed 2,332 Moderator on 17 Aug 2023 at 07:57:03

Like (2)

Report

Re: Change file extension in Power Automate

Hi,
This method can't work. Every old office formats (doc, xls, ppt) are binary content file formats while new ones (docx, xlsx, pptx) are XML content file format. What you are doing is a file copy to a file with a different extension but you need conversion. As far as I know, there is no standard action to do such conversion, have a look to premium ones from "Plumsail" or "Encodian".
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.
Community Power Pla... on 17 Aug 2023 at 07:06:28

Like (0)

Report

Re: Change file extension in Power Automate

Hi Tina,
Here I have shared my complete flow in a zip format, Mine is not working as expected. Please check and help me to solve it.
Thanks,
4rose

Changefileextensi...
Community Power Pla... on 16 Aug 2023 at 10:14:16

Like (0)

Report

Re: Change file extension in Power Automate

Hi Tina,
Yeah Sure, Here I have attached my complete flow. Please check it.
Thanks
4rose

Change File Exten...
v-hanytian-msft Microsoft Employee on 16 Aug 2023 at 09:28:20

Like (0)

Report

Re: Change file extension in Power Automate

Hi @Anonymous ,

After Testing of mine, it is worked.
Therefore, could you please offer some screenshots about your Flow?
We can solve it together.

Best Regards,
Tina
Community Power Pla... on 16 Aug 2023 at 09:24:07

Like (0)

Report

Re: Change file extension in Power Automate

Hi Tina,
Thanks for your help. The file is Generating as expected. But it is not reading file content values. When I try to open the file it is not opening. I have attached screenshots for your reference. Please help me out.
Thanks
4rose

2023-08-16 14_51_...

2023-08-16 14_52_...

2023-08-16 14_51_...
v-hanytian-msft Microsoft Employee on 16 Aug 2023 at 07:01:30

Like (0)

Report
Re: Change file extension in Power Automate

Hi @Anonymous ,
We made a sample for you.
slice(triggerOutputs()?['body/{FilenameWithExtension}'],lastIndexOf(triggerOutputs()?['body/{FilenameWithExtension}'],'.'),length(triggerOutputs()?['body/{FilenameWithExtension}']))
concat(triggerOutputs()?['body/{FilenameWithExtension}'],'x')

Hope this will help you,
Best Regards,
Tina