Answered

Building flow to autofill form and convert to PDF

(0) Share

Report

Posted on by Wintermere

Hi i have some issue with my flow in progress.

When a new item entry is created in sharepoint, this trigger and populate a predefined template. The words file will need to be converted to PDF and this is the part where i have problem.

Below is the error message;

I am very confused this flow is not working despite it worked as 2 standalone flow (auto fill + convert PDF)

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (2)

Sort by

Pstork1 69,543 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What Word extension are you using on the file when you create it in OneDrive and try to convert it to PDF?

Was this reply helpful? Yes No
Wintermere 50 on at

Like (0)

Report
Copy link

Link copied!

.docx

Was this reply helpful? Yes No
ccc333ab 1,144 on at

Like (1)

Report
Copy link

Link copied!

As a test, can you make sure the WORD document itself is getting generated correctly (i.e., from your first Create File action). Just see if it opens up properly in Word.

Was this reply helpful? Yes No
Wintermere 50 on at

Like (0)

Report
Copy link

Link copied!

Yes i have verified that proper file .docx is created in my designated folder path. The doc is readable

Was this reply helpful? Yes No
ccc333ab 1,144 on at

Like (0)

Report
Copy link

Link copied!

Sorry, hate to be redundant but how about the Word file on OneDrive (Create file2). I should have said that in my first message as well.

Was this reply helpful? Yes No
Wintermere 50 on at

Like (0)

Report
Copy link

Link copied!

Hi, you are right. The file cannot be opened. This is the error;

Error from flow:
Error from Office Service. Url=https://wordcs.officeapps.live.com/document/export/pdf HttpCode=BadRequest cert=subject:;thumbprint: ResponseHeaders=X-ErrorCode: WordCantOpenDocument
X-ClientCorrelationId: 095829fa-eb5f-475e-a574-2e0473ed8c32
X-ServiceCorrelationId: 095829fa-eb5f-475e-a574-2e0473ed8c32
X-ErrorCategory: BadRequest
X-IsRetriable: False
X-ConversionTimeInMs: 93.7406
X-FileDownloadTimeInMs: 312.4988
Cache-Control: private
Date: Sun, 06 Jun 2021 03:25:13 GMT
Server: Microsoft-IIS/10.0
X-AspNet-Version: 4.0.30319
X-Powered-By: ASP.NET

Was this reply helpful? Yes No
Verified answer

ccc333ab 1,144 on at

Like (0)

Report
Copy link

Link copied!

Can you provide screenshot of the after run data for the Create File 2 action?

Was this reply helpful? Yes No
Wintermere 50 on at

Like (0)

Report
Copy link

Link copied!

Based on your questions, i somehow manage to run the flow with some minor amendment to the create file 2 (i renamed it as "Create Temporary File in Onedrive". Screenshot below

Ill consider this as solved. Thanks for pointing out the problem area for me to review

Was this reply helpful? Yes No
Verified answer

Pstork1 69,543 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you look at the url in the error I think you may be using the wrong filename. You listed the folder in the step as /documents but the url is trying to open /documents/export/pdf/ Either the filename is mising and the folder is actually /documents/export or the file name should be export.pdf not export/pdf.

Was this reply helpful? Yes No
Wintermere 50 on at

Like (0)

Report
Copy link

Link copied!

Yes, the problems are two fold after further checking. having initially set the temporary file to be created in document folder is confusing because i have multiple onedrive with the same document folder name. Hence i created a specific folder "Words to PDF" and managed to connect to the right folder.
In addition, i also picked the wrong content and have corrected in the latest flow. It is finally working. Thanks.

Was this reply helpful? Yes No