Populate a Microsoft Word template - dynamic file

(0) Share

Report

Posted on by NickF10

Hi,

I'm working on a small project that automatically populates a specific Word document depending on the user's input.

When I manually select the file path in the action, it works fine. However, when I try to dynamically select the file, the action does not show any advanced parameters to fill my Word document, and when I run the flow, I get the following error:

Action 'Populate_a_Microsoft_Word_template' failed: The selected file doesn't contain template elements.

When I take a look at the input parameters, I do see that the correct file was selected:

"file": "/Verslagen/Bevestiging intake.docx"

What am I missing?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @NickF10 ,

If you open the peek code you will see that it uses the file id instead of the file path.

So if you want to populate a dynamic file, please provide the file id rather than the file path.

Best Regards,

Wearsky

Was this reply helpful? Yes No
NickF10 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft,

Thank you for your reply.

Unfortunately /verslagen/{id} also does not work. Neither does only {id}. I receive the unique file ID from the previous step (find files in folder). The same error message is shown, and I can't fill in the advanced parameters.

Attached you can see the code view when I change 'file' to the dynamic ID from the previous step.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @NickF10 ,

It should be

split(item()?['Id'],'.')?[1]

Best Regards,

Wearsky

Was this reply helpful? Yes No
NickF10 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

Thanks for the quick reply. Unfortunately, it still doesn't work. Receiving the same error and can't fill in the parameters. It seems it can't find the file. Attached is a screenshot of the code.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @NickF10 ,

It worked for me. Please share your flow run history screenshot.

Best Regards,

Wearsky

Was this reply helpful? Yes No
NickF10 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

When I add the file manually, I can enter the values I've defined in the Word template. However, with your code, it doesn't display that. I only see 'dynamicFileSchema'. I might be missing something obvious here, so I'm sorry in advance.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @NickF10 ,

You are using wrong parameter. In your screenshot it is path.

In my screenshot, it's id. Please check it.

Best Regards,

Wearsky

Was this reply helpful? Yes No
NickF10 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

Thanks for getting back to me again. Hope you had a great weekend.

I'm not sure why it went wrong with the ID. But now it goes correctly. However, it still giving me the parameter error. Do I need to fill in the parameters manually as a key, value pair? Because if I selected the file manually, it will give me the parameters and I just fill in the values.

Was this reply helpful? Yes No