All Excel Rows to Word Template with Repeating Control

[Mike44]

I have an Excel file and have created a Word template with repeating and non-repeating content controls.  I'm attempting or need to have all of my rows in Excel populate the repeating content control in the Word template.  When I run the flow only one row is populated.  Below are some pictures of my spreadsheet, word doc, and flow.  Any help would be greatly appreciated.

[v-LilyW-msft · Accepted solution]

Hi @Mike44 

According to your description you want all rows on the excel is moved to a word document.

You can try to add an array variable, then append the repeat content to this variable, and then fill the variable into the repeating content field.

I set up a simple flow, you can refer to below screenshots.

This is my test excel:

Flow in details:

After flow runs, a new document will be created.

Hope the content above may help you.

Best Regards

If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mike44]

Thanks for the help, your suggestion worked, however I was hoping you could help with one other thing.  Three of my columns in my Excel table are of currency type, however when populated in the Word doc. loose formatting.  For example, in Excel $41.50 is displayed as 41.5 in the output.  Those three columns are Mileage Cost, Hourly Rate Cost, and Total Combined Cost.  How can I get my the output to be displayed as currency.  I've searched high and low and have found several suggestions, but I just can't make them work.  I'm pretty much a novice here.  Below is a copy of the update I made based upon your suggestion.  Note I did not insert the entire flow as I was hoping you could go from the previous.

[v-LilyW-msft]

Hi @Mike44 

Please try to use Format Number action to format this currency in your required format.

float(items('Apply_to_each')?['Mileage Cost'])

Best Regards.

[Mike44]

Thank-you for your help.  When I try your suggestion -float(items('Apply_to_each')?['Mileage Cost']),

 it runs without errors, however it still does not output as currency.  See below.

When I try -formatNumber(float(items('Apply_to_each')?['Mileage Cost']), 'C2', 'en-US'), I get the desired output, see below, however neither your suggestion nor this work with any of the others- (Hourly Rate Cost, Total Cost, etc.), where I need currency formatting.  When either formula is applied to the other fields, I get the error below.  

[v-LilyW-msft · Accepted solution]

Hi @Mike44 

Do you have any null values in ‘Hourly Rate Cost’, ‘Total Cost’ columns?

If yes, please try the following formula, first determine whether the value is empty, if it is empty, return null, if not, return the value after format.

if(empty(items('Apply_to_each')?['Hourly Rate Cost']),null,formatNumber(float(items('Apply_to_each')?['Hourly Rate Cost']), 'C2', 'en-US'))

Best Regards.

[Mike44 · Accepted solution]

Very strange- when I applied your new formula: if(empty(items('Apply_to_each')?['Hourly Rate Cost']),null,formatNumber(float(items('Apply_to_each')?['Hourly Rate Cost']), 'C2', 'en-US')), every row under those columns was returning as 'null'.  I even went as far as disconnecting from power query and deleting and re-entering new numbers in those columns for testing purposes; still, all were returning as 'null'.  

The source is a table in another workbook, connected via power query, initially with very few changes.  I reconnected to the source and power query and instead of using the columns that were giving me issues, I re-created them by adding custom columns in power query.  I then applied your new formula to the new columns and SUCCESS!  I don't know why, but it's working.  THANKS!