Populate a Word document with Excel table data (multiple rows to one output docx file)

(0) Share

Report

Posted on by kamoo

Hello,

Hope you are all well.

I'm attempting to create a flow that takes rows from an excel sheet and populates it into a word document. This is to generate a daily construction activity memo.

The trigger is manual.

The data in the Excel is structured (see image below) in a way that I need to return multiple rows from excel to populate a single table/generate a single document in word.

I have created a word template with the below fields (see below) and have nested Plain Text Content Controls within a Repeating Section Content Control.

The below images are from the flow that I created.

I understand that the "apply to each" is a loop, and I know I'd have to append but I'm not entirely sure how to as I'm new to this.

Any help would be greatly appreciated. Thank you.

Categories:

Building flows

I have the same question (0)

All responses (22)

Answers (2)

Alex_Rackwitz 9 on at

Like (0)

Report

@kamoo

Just to clarify, you have transposed the data. Each row in Excel will become a column in Word?

Or do you want multiple tables with 2 columns, each table representing a row in Excel, in a single Word file?

Was this reply helpful? Yes No
kamoo 34 on at

Like (0)

Report

Hello Alex, @Alex_Rackwitz

Yes, the latter as you described it.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report

You don't want to use an Apply to each loop for this as that would end up creating multiple documents.

I'm using the sample Excel Table below.

See full flow below. I'll go into each of the actions.

List rows present in a table retrieves the data from my table.

Select maps the fields we want to use in our Word Template. Note that the Headers you specify here need to match the names of the Controls you added in your Word Template. In my case, the Excel Table has a header called Job Title, but my control is named JobTitle (no spaces).

Populate a Microsoft Word template uses the output from the Select to build the repeating table. You'll see that my repeating table is called DetailsTable and I've changed it to array mode to add the Select output.

Create file uses the content from Populate a Microsoft Word template.

Was this reply helpful? Yes No
kamoo 34 on at

Like (0)

Report

@grantjenkins

Thank you for your help. I was able to populate a sheet with multiple rows. (I noticed that there were additional attempts made on the sheet blank fields).

The issue I'm running now is that two (2) of the fields are not populating, mainly for "Location" and "Building Services". (See Below).

I've rechecked "Select" step and can confirm that all fields are labeled and mapped correctly. These fields appeared in my initial flow creation.

Was this reply helpful? Yes No
kamoo 34 on at

Like (0)

Report

@grantjenkins

I was able to correct this issue. It was due to the extra rows in the table, and I failed to add the proper tag to the controls in question.

Was this reply helpful? Yes No
kamoo 34 on at

Like (0)

Report

@grantjenkins

Okay. I'm now attempting to filter my results before populating the word document. I would like the filter to include only the current day and the day after. I've added a "Filter Array" after the "List rows in table", but it has not filtered out the additional days. (See below). Would it be possible for me to filter and sort with ODATA only? I've attempted to do so but, my syntax is wrong.
The Flow
Screenshot 1
Screenshot 2

Should I be adding the "Filter Array" before populating the word document?

In addition, I'd like to format the "Date" to remove the time and as well as format the "Start Time" & End Time" to remove the date. Can I add this function into the "Select" operation? (See below for reference).

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

Are you sure the Filter array isn't working correctly? I think the issue might be because you are still using the output for your Select from List rows present in a table and not the output from the Filter array.

Was this reply helpful? Yes No
kamoo 34 on at

Like (0)

Report

@grantjenkins

Yes, I can confirm that I've chosen the correct output. But I'm having trouble figuring out the correct sintax.
Please see the below image for reference. My goal is to filter for only the current day and the day after based on the "Date" column. I understand that the greaterorequal function requires that both items be of the same type.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

I mean in your Screenshot 1 it looks like your Select is getting the output from List rows present in a table, but it should be using the filtered output from the Filter array instead.

Was this reply helpful? Yes No
kamoo 34 on at

Like (0)

Report

@grantjenkins
Please refer to the below image, I've made a change to the flow since posting that (Not sure if it is for the better). I have now placed the Filter Array after the Select.

(Select output highlighted in Yellow, Filter Array output highlighted in Blue)

In the Filter Array I've selected the option for greater than or equal as that would fit into my filter criteria. Not sure of the sintax.

Should I have just left the flow in the original format?

Thank you.

Was this reply helpful? Yes No