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

(1) Share

Report

Posted on 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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @fabiofa

Try to see if it works with below parameter 🙂

Was this reply helpful? Yes No
fabiofa 86 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @fabiofa

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

something like below

This would work 🙂

Was this reply helpful? Yes No
fabiofa 86 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

AlexEncodian 4,409 Moderator on at

Like (1)

Report

@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.

Was this reply helpful? Yes No