Create a Word Template - Nested Dataverse Tables - Error

[Anonymous]

Hello All!

I'm looking for, help/point in right direction for the problem I have.

This is how the flow works with two tables.

1. When row is selected table1.
2. Get by Row ID for selected.
3. List related Rows in table2 based on filter.
4. Word Online Connector to use the data in a letter.
5. Create a Word Document in SharePoint.
   
   

---------------------------------------------------------------------------------
When I add a list rows for a table3 I get the following error. Have I hit a limitation or do I need to change the way my Flow is setup

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Create_file' at line '1 and column '3132' cannot reference action 'Populate_a_Microsoft_Word_template'. The action 'Populate_a_Microsoft_Word_template' is nested in a foreach scope of multiple levels. Referencing repetition actions from outside the scope is supported only when there are no multiple levels of nesting.'.'.

[v-xiaochen-msft · Accepted solution]

Hi @Anonymous ,

It seems that you invoke the parameter in the loop outside the loop.

If there are no detailed screenshots, it is difficult to find the problem accurately.

Best Regards,

Wearsky

[Anonymous]

Thank you for the response. I'll add the detailed screen shots today.

[Anonymous]

@v-xiaochen-msft  This a detailed breakdown of the steps in the flow. I can't seem to get data from the 3rd table into the Word template.
Adding data from 3rd table I get error.Create docx using two tables. Works.Get rows in 3rd tableGet rows in 2nd table.On select get row ID

[Anonymous]

If I don't use the word template connector I can create a text file with data from all three tables.

[v-xiaochen-msft]

Hi @Anonymous ,

The key is that the 'populate a word template' action is in the loop but 'create file' acionis not in it.

In other words, If loop 5 times, the flow will create 5 word templates.

But the 'create file' action is not in the loop, it will only be executed once.

So it doesn’t know which word template to use in the loop.

You just need to put  'create file ' action in the loop.

Best Regards,

Wearsky

[Anonymous]

Good news first. You are correct having create file in the same loop that contains the Word Template works. It creates the letter. But it does throw this error. Any thoughts on that? error but flow runs correctly