Answered

Converting Word Doc to PDF Creates a .pdf.pdf File

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Creates a filename.pdf.pdfI am creating a Flow that takes a Word doc from a SP site and converts it to a PDF using OneDrive, then saves it back to SP. It works, but it saves it as a .pdf.pdf and I don't know how to rectify it. If I remove ".pdf" from the last step in File Name, it fails because a file extension was not provided. I have been using Flow for several months now and appreciate any recommendations.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for sharing the detailed screenshot for the flow configuration.

Where do you get the dynamic content for the File Name filed of the last action?

Please take the following flow for a reference.

When a file is created in a folder, get file content, then create file in OneDrive for Business. Then convert the corresponding file to PDF file. In the last action Create file2, select both File name and File content from the previous action Convert file. There is no need to add an extension .pdf after the file name.

Best regards,

Mabel

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

Like (0)

Report
Copy link

Link copied!
Mabel - Thanks for the response. I removed the .pdf file extension from Create a File 3 step and it works now. I swear there have been some intermittent issues with it but it all seems to work now. I do have a few follow-up questions.

What is the max file size for using a Flow to convert a SP Word file to a PDF (using OneDrive) and then saving back to a SP site?
Since I am using a SP file's checkbox property as my trigger, a user can use the modern SP page, select multiple files, and change the checkbox property for all selected files in a single operation. As a result, this would send multiple files to my Flow for converting Word docs to PDF files. Is this problematic and if not, what is the max number of files (or file size) that such batch file operations should be limited to?
Are there any other best practices or reference articles regarding the Word to PDF Flow that I am working with?
Thanks again for your response.

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Thanks for updating. I am glad to hear that it is working for you now.

About #1, there is a current limitation that the max message size of flow is 100 MB, please check the doc at here:

https://docs.microsoft.com/en-us/flow/limits-and-config

About #2, though you have selected multiple files, flow will still deal with each file separately. So the max limit at here is 100 MB as well.

About #3, I have seen the following docs on converting doc to pdf file, hope it could be your reference:

Convert SharePoint documents to PDF automatically using Microsoft Flow

Two ways to convert SharePoint files to PDF via Flow

Best regards,

Mabel

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

Like (0)

Report
Copy link

Link copied!
Thanks, Mabel for the additional information.

So when MS says "message size", that is synonymous to file size in my Word to PDF conversion example?
After the Flow successfully runs, I have a Word doc in my OneDrive. Do I need to add a step to delete the Word doc after successful pdf conversion?

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

Like (0)

Report
Copy link

Link copied!

Hello @v-yamao-msft , you said that the limit has been changed to 100 MB, but it seems to me that you are talking about something else. Because the size limit to convert an HTML document to PDF is always 2 MB. But if not, can we change the limit manually?

Here is a PDF conversion error that I had today:

Thank you for helping me as soon as possible!

Was this reply helpful? Yes No
SteveCochrane 219 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Mabel!

We have been using the method above, however, we were told by Microsoft that "Preview" connectors are not to be used for production, are not supported by Microsoft and can be removed at any time. What risk is there in using the "Convert file (Preview)" connector?

Steve in Spain

Was this reply helpful? Yes No