web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : SS7uCHktTyqyRnKHmxWpo6
Power Automate - Building Flows
Answered

Copy Excel data to the word file

Like (0) ShareShare
ReportReport
Posted on 1 Apr 2020 08:09:25 by 133

Hi, guys! So, I have an excel file with table. In this table I have Name, Surname, Mail and Tel Columns. I want to add all this info into the word template file. It works great if i have only 1 row. If there are many rows, only the last row is present in the newly created word file.flow.PNG here is the screenshot of my flow. The question is, how should i modify all the fields in word document from developer mode, so that all the content from excel file is added to word file and not only the last one. I marked the fields in word file as repetitive content but it does not help.

I have the same question (0)
  • Verified answer
    v-litu-msft Profile Picture
    on 01 Apr 2020 at 10:13:45
    Re: Copy Excel data to the word file

    Hi @KotaroKo,

     

    You could have a try that initializes an array variable to store these columns, Create Append to the array variable, then put the array into the Populate A MS word template action:

    Annotation 2020-04-01 181252.png

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 783 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 515 Moderator

#3
trice602 Profile Picture

trice602 299 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete