Convert Word Document to PDF

[Mike44]

I've created a form where responses populate a word doc template and create a file in SharePoint.  This all works fine.  The next step should convert the document to a pdf, but I get an error that says --The selected file doesn't exist, please select a valid file and drive.  clientRequestId: 0b8924ab-4efe-47c3-991e-a8672fc6386e-- at the 'Convert Word Document to PDF step', However, it does exist.  I'm not sure what I'm doing wrong.  Below are some pictures of my flow up to that step.  Note: in the 'Convert to PDF' step, I've tried, from the 'Create File' step: ID, Name, and DisplayName.

[Shujaath_Khan]

Hi @Mike44 

after you create the file and before you start conversion can you add delay action ( may be a min) between  so file is ready for conversion

extra, and also instead of utcNow() can you change it to utcNow('yyyy-MM-dd') ignore if not needed

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

[MarconettiMarco]

Hello @Mike44 ,

in the “Convert to Word Document to PDF” you’ve to search for the file identifier instead of the name.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[Mike44]

Added the delay and still the same results.  Below are the input and output, as well as evidence the file exists:

Input
{
"host": {
"connectionReferenceName": "shared_wordonlinebusiness",
"operationId": "GetFilePDF"
},
"parameters": {
"source": "groups/87b0142a-9021-4b6b-971d-4c9dc1c1a289",
"drive": "b!rfdGDOykRkOwSCfz6SzRuj1KuB7dnSZDuOxaMS6mOhQjwK5hxGOxSYKvS7ggoiln",
"file": "Maintenance request 231 Sullivan 2022-07-14T18_07_37.9182508Z.docx"
}

Output
{
"statusCode": 400,
"headers": {
"Pragma": "no-cache",
"x-ms-request-id": "bd76c020-9413-4183-b422-5535a4f49f58",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Cache-Control": "no-store, no-cache",
"Set-Cookie": "ARRAffinity=430fde32acf620e94447c7e2e59908644804523c09f9a09b2273e2becc212387;Path=/;HttpOnly;Secure;Domain=wordonlinebusiness-usgv.azconn-gcc-usgv.p.azurewebsites.us,ARRAffinitySameSite=430fde32acf620e94447c7e2e59908644804523c09f9a09b2273e2becc212387;Path=/;HttpOnly;SameSite=None;Secure;Domain=wordonlinebusiness-usgv.azconn-gcc-usgv.p.azurewebsites.us",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "true",
"Date": "Thu, 14 Jul 2022 18:08:41 GMT",
"Content-Length": "350",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"status": 400,
"message": "The selected file doesn't exist, please select a valid file and drive.\r\nclientRequestId: bd76c020-9413-4183-b422-5535a4f49f58",
"error": {
"message": "The selected file doesn't exist, please select a valid file and drive."
},
"source": "wordonlinebusiness-usgv.azconn-gcc-usgv.p.azurewebsites.us"
}
}

[Shujaath_Khan]

Also try @MarconettiMarco inputs 

[Mike44]

I don't have an option to select 'file identifier' or 'identifier' in the dynamic content.  I've tried 'ID' and get the same results.

[Mike44 · Accepted solution]

I finally have this working, however I could not get it to work using the 'Convert Word Doc to PDF' premium- Word Online (Business), which I do have an account for.  I had to use the OneDrive for Business - Convert file (Preview) in order to get it working.  Below is a screen shot of my flow.  More steps, but it works.

[kevinlowe]

I realize this was a long time ago, but I faced similar issues and really needed to avoid One Drive. My process worked, finally, and here was the solve: In the Convert Word step, in File it should be / then the Name output from the create file in sharepoint step (it wants a path to the file relative to the document library root). I also needed to be sure the filename when I then saved the converted document back to SharePoint wasn't just the Name output, because I just get a word doc because that is the filename when I created the first Word doc. So I needed to ensure the filename is just recreated and instead of .docx on the end of it, place .pdf. Works great. Thanks, Kev

[Nena10]

Hey Mike44,

can you unfold this actions?

Thanks a lot

Regards

Nicole

[Anonymous]

Your solution works! Basically, I compress the file under 100 MB and add .pdf to the file name at the create a file.

Thank you so much. I really appreciate it!

[cjnunn]

THANK YOU! This worked perfectly!

[Frank67]

How did you attach the converted pdf file to email? I am more specifically asking the step before "Add request to sharepoint list". I could not see which pdf file to choose to attach to the email. Did you use the path of folder or the location? I would appreciate if you could share it. Thanks!

[Mike44]

From the Convert File.  body('Convert_file')

[cjnunn]

Mine is a little different from @Mike44's, because I am storing the PDF files. 

First, I populate the template and create the word file in sharepoint. Then I convert it to PDF, save it, attach that to the email, and delete the Word file.

[Anonymous]

Hello! I'm in the same boat. Can you please share a screenshot of the details of these triggers?

[axskifree]

Finally got mine working... Had to remove the leading "/".

[Melimel981]

I spent so much time on this one and all it took was a /

Bless you! We do not have one drive and I was losing my patience!

[nerfherder]

You're not missing anything - the "Convert file" OneDrive (preview) action just bit the big one a month or two ago and now this Convert to Word Document is the only option unless you want to pay Adobe $25,000 a year OR are okay with setting up new Adobe API user accounts every 500 PDFs lol