Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Create an excel worboo...
Power Automate - Building Flows
Unanswered

Create an excel worbook and copy rows into table- question about triggers

(2) ShareShare
ReportReport
Posted on by rutledgeam 28
I have been following these steps to copy data from one spreadsheet into another spreadsheet. 
 
 
The automation I am trying to create is when someone uploads a file into a specific Share point folder two things happen: a new workbook is created with a table using a template, and then the data is copied from the uploaded file to the new workbook. 
 
I can get both actions to happen separately but I can't figure out how to connect them.  Right now both are triggered manually in two separate automations, but I want the whole action to complete automatically. 
 
I tried to run the copy data steps in the post above after creating a new workbook but it was unable to find the uploaded file. 
 
I have been staring at this thing for days and I am stuck! Suggestions on how to make this happen? 
 
Categories:
Business Process Flows
  • AnthonyAmador Profile Picture
    AnthonyAmador 2,553 Super User 2025 Season 1 on at
    Create an excel worbook and copy rows into table- question about triggers
    @rutledgeam you need to redesign your flow. Why do you have two branches?

    Check this video, may can help you https://www.youtube.com/watch?v=un0Po1jxfn4

    Anthony.
  • rutledgeam Profile Picture
    rutledgeam 28 on at
    Create an excel worbook and copy rows into table- question about triggers
    They are both excel spreadsheets. 
    The uploaded file is 16 columns and the amount of rows will vary. It is basically an exported file that needs to be customized. The data is not in a table- so it needs to be created. 
    The template is an excel file with an image and then a table. The column headers are already done so I just need to move the rows after the header from the uploaded file. 
  • AlexEncodian Profile Picture
    AlexEncodian 4,409 Super User 2025 Season 1 on at
    Create an excel worbook and copy rows into table- question about triggers
    Can you share more detail about what the uploaded file looks like and what the template looks like? Is it structured tabular data? 
  • rutledgeam Profile Picture
    rutledgeam 28 on at
    Create an excel worbook and copy rows into table- question about triggers
    So I am probably doing this all wrong (especially since it is failing) but this is what I currently have set up. 
     
    So the input is the uploaded file and then having the data copied into a new excel workbook that is created using a template. I keep running into issues with the file ID- that the file can not be found due to a 404 status code. 
    The file being uploaded will have the same workbook and sheet name. 
    I tried to do the same automation in one flow- but ran into the same issues. 
     
     
     
     
     
     
     
  • AnthonyAmador Profile Picture
    AnthonyAmador 2,553 Super User 2025 Season 1 on at
    Create an excel worbook and copy rows into table- question about triggers
    Hi,
     
    You need to extract the information from the uploaded file and then paste it into a new workbook. For that, you need to use the Excel actions.
     
    To extract the information, you have to use the “List rows present in a table” action. However, you need to know the name of the table inside the Excel file. So first, you have to use the “Get tables” action to get the name of the table you want to extract the information from. If the name of the table will always be the same, you can skip this step.
     
    Then, in the “File” input for “List rows present in a table,” you have to use the dynamic content from the trigger, which I suppose will be “When a file is created,” to select the correct file.
     
    Can you elaborate on where exactly you are having issues?
     
    Best,
    Anthony
     
     
     
     

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans