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

[Anonymous]

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. 

[v-yamao-msft]

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

[Anonymous]

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.

1. 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?
2. 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?
3. 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.

[v-yamao-msft · Accepted solution]

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

[Anonymous]

Thanks, Mabel for the additional information. 

1. So when MS says "message size", that is synonymous to file size in my Word to PDF conversion example?
2. 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? 

[Anonymous]

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!

[SteveCochrane]

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