Populate a Word Template from a list in excel Cloud

[justicedst]

Hello,

I am know I am over thinking this but I need a flow that populate a word template with the entire row of a cell in the dropped excel sheet in sharepoint into a word template when the a file is dropped. Example below:

Excel sheet example. Here is the Excel Sheet. 

Then want all those numbers in the one file into 1 word Template like the pic below with Comma after each one:

Your help is greatly appreciated. 

[Nived_Nambiar · Accepted solution]

Hi @justicedst 

One thing we have to assume 

1. Excel data should present in table - just like below

Let's dive into the flow 

1. Use trigger when file is created trigger so that flow triggers on when the excel file is dropped in folder.

Also set the following trigger condition in the trigger itself so that it triggers for excel file

I have created a folder App1 where excel files would be placed.

2.  Use list tables to list all tables in the excel workbook

3. Use list rows to list all rows in table like below

Expression used in table field- 

first(outputs('Get_tables')?['body/value'])?['id']

This is captured from get tables output.

Also Identifier is the dynamic content used same in Get tables action.

4. Use select action to select the Prime Numbers column value 

Expression - 

replace(item()?['Prime Numbers'],'CR-','')

The above expression removes the CR part from the numbers before inserting in word document.

Also the column assumed in Prime Numbers , i.e why we have used item()?['Prime Numbers'] , else change the column name accordingly.

5. Next use populate word document to populate the data in word document,

I have created a sample word document template like below

Now use populate word document expression - 

Expression - 

concat('These are out Prime Numbers:',join(body('Select'),','))

6. Use create file to create file using content from populate word document action.

I have used the file name of word document to be guid().docx to be unique, u can change it as per your requirement.

for content- i have used the following content

Hope it helps !

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[justicedst]

Thank you. You are amazing. 

[justicedst]

The solution you provided worked but has issues because I left out some key factors.

I have multiple templates so I am using a switch and there will be different Prime Numbers (example CR-, BR-, ) I have provided screenshots of the flow hope you can help. 

This is what in the template: 

This is in the Apply for  Each

Did I choose the right select action,, Mine didn't come up like yours and the code you provide for replace gave an error. 

[Nived_Nambiar]

Hi @justicedst 

There is no need to apply to each loop actually in your case, After List rows present in table action, use select action to get required values from the excel in correct format. Also to see the select action exactly as i did, select this option before writing the expression

Also write this expression if you need to handle the BR- as well (replace the expression used in step 4 of my flow)

replace(replace(item()?['Prime Numbers'],'CR-',''),'BR-','')

Hope it helps !

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌