Unanswered

Use multiple Tables in single Excel workbooks to populate Word Template

(0) Share

Report

Posted on by akashverma1

I have to automate a monthly word report that takes values from an excel workbook. My Word Template contains both Tables and Paragraphs which need to have dynamic content.

I went through some tutorials and completed the following:

1. Created a Word Template - Added Plain Text Content control for paragraphs and repeating section content for tables.

2. Created a Power Automate Flow as below:

This is letting me insert into a table in the word template.

However, I am unable to insert data into the paragraph. The paragraph data points are also in the form of a single-row table in the excel. I am not sure how I can insert - 1) Data from multiple Tables. 2) Data into the Paragraph.

One of the Plain Text Content control is Months, which I have also used here as "Mont" but when I add excel item, a foreach loop is created. My table has just one row for the paragraph content.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @akashverma1 ,

If you have two tables ,

1. This will be used to populate the table in the word file through repeating sections

2. For the second table which has only one row , you have to again use the list present in a table action (Now even though this has only one row , it will end up in an apply to each loop , but since your table has only one row of data the data will be populated only once or to avoid this you can use first(valuearray?['columnName']))

Hope this answers your question.

Do give this a thumps up if this answers your question.

Thanks,

Sanmesh

Was this reply helpful? Yes No
JE-26111337-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG,

I have a similar issue and I have created two separate 'List rows present in a table' actions, which does indeed force a second 'Apply to each' action, however I keep getting an error message: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Create_WORD_file' at line '1 and column '2318' 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.'.'.

I don't know how to get past this - can you please help?

Was this reply helpful? Yes No