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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copy Excel file and ad...
Power Automate
Unanswered

Copy Excel file and add rows in new file

(0) ShareShare
ReportReport
Posted on by 27

I want to Copy an Excel file containing a table to a new excel file and add rows to the new file with data from MS Forms.

 

Just cant seem to get the flow right. Any solutions?

 

Thank you!!!

Categories:
I have the same question (0)
  • harshdeol Profile Picture
    441 Moderator on at

    Hi @JensaM ,

    Could you please provide more clarification regarding your statement, 'add rows to the new file with data from MS Forms'?

    Did you want that for each form submission, a new copied Excel file should be created? or all submissions data in one file (one submission add one new row)?

  • JensaM Profile Picture
    27 on at

    Hi @harshdeol !

     

    Thanks for yor reply.

     

    I will try to explain the flow better 🙂 

     

    1) The user will start by filling out an MS Forms, where they will be able to enter data for up to three new rows in the excel sheet.

    2) When the form is submitted  I will use the "add row in table"-command three times in a row to add all new rows in the Excel table. The table in the Excel file allready has severeal prewritten rows.

    3) When this is done I will populate a word tempate, convert it to a pdf, and email it to the user.

     

    Everything works just fine except that this flow should be able to run several times with the same prewritten rows as the first time. Therefore the original Excel file must be restored (or not edited) somehow. It should be as a template more or less that is alwys the same. I have tried to make a copy of the Excel file that I can run the flow on, but I just cant get the connections right to the newly created copy. I have also tried other varianbts with scripts in Excel without luck.

     

    So, to sum it up. I need to have the original excel file intact when the flow is done.

     

    Please ask again if should clearify something!

     

    TY!!!

  • JensaM Profile Picture
    27 on at

    And also I need to sort the rows in order before populating the word document and thats why I have to go via Excel, but that part works fine.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard