Fill Word Document Template, Convert To PDF And Send Via E-mail

Like (1) Share

Report

Posted on 9 May 2023 18:06:56 by fabiofa

Hello All,

I'm having trouble with a flow and was not able to find a solution online.

Summary of what I have:

Power Apps forms which triggers a flow when a new item is created in an SP list.
Power automate flow runs and fills a word document template which I have stored somewhere in a SP site.
Power automate then creates a new file with the populated information and dumps it into another folder in SP
Using the convert doc to pdf connector I try and convert the new doc to pdf
Flow should end by sending an e-mail to the original form submitter with the filled document converted into pdf.

I am currently getting stuck on step 4 (in green the steps that work and in red the ones that fail), I get the error message "There was an error accessing the file. Please try again or select a different file."

The file is not open and even with a 2-minute delay between file creation and conversion the flow still fails.

Below is how the flow is setup

And a screenshot of where it fails

Any help is much appreciated

All responses (5)

Answers (2)

Verified answer

AlexEncodian 4,409 Moderator on 12 May 2023 at 21:50:36

Like (1)

Report

Re: Fill Word Document Template, Convert To PDF And Send Via E-mail

@fabiofa

I believe you can avoid the OneDrive step if you put a "Get File Properties" action before the convert step and then use the Folder Path dynamic value in the *File field of the convert function.

The *File field takes the folder path relative to the site and full file name with extension, not an ID.
fabiofa 86 on 11 May 2023 at 22:51:24

Like (0)

Report

Re: Fill Word Document Template, Convert To PDF And Send Via E-mail

This works, a little extra work to move back to SP but I guess beggars can't be choosers
Verified answer

Nived_Nambiar 17,949 Super User 2025 Season 2 on 10 May 2023 at 02:16:10

Like (1)

Report

Re: Fill Word Document Template, Convert To PDF And Send Via E-mail

Hi @fabiofa

Could you store the files in onedrive and once bot creates it , move to sharepoint ?

something like below

This would work 🙂
fabiofa 86 on 09 May 2023 at 19:38:11

Like (0)

Report

Re: Fill Word Document Template, Convert To PDF And Send Via E-mail

Hey Nived, I tried with Id but I'm getting the following error "The selected file doesn't exist, please select a valid file and drive."

Will attempt again with a delay and see if that helps

Attempted with a 3-minute delay but was unsuccessful
Nived_Nambiar 17,949 Super User 2025 Season 2 on 09 May 2023 at 18:26:47

Like (0)

Report

Re: Fill Word Document Template, Convert To PDF And Send Via E-mail

Hi @fabiofa

Try to see if it works with below parameter 🙂