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 / Copying excel row tabl...
Power Automate - Building Flows
Unanswered

Copying excel row table data from one excel to anther excel sheet

(1) ShareShare
ReportReport
Posted on by Mahipundir 68

Dear all, 

I am wondering if someone has done it and can share their knowledge. ?

I'm trying to copy excel row data from one excel sheet1 to excel sheet2 once a column changes the status in excel sheet1, I have done it with macros in past locally and now trying to achieve this via the power automate. 

I can create and update rows using power automate excel online action but can't see a way to copy/cut to excel sheet2 

I hope this time I will get answer from power automate community. 

Categories:
Business Process Flows
  • mathiaskjeldsen Profile Picture
    mathiaskjeldsen 222 on at
    Copying excel row table data from one excel to anther excel sheet
    Hey
     
    Should be doable. You need to implement a variable logic that captures the change, but from there you can use the send keys actions to send ALT E + M, to get the copy worksheet window up. Then from there send a few more keys to click create copy and choose the new workbook. If you don't know how to use Send Keys functions and work with Excel using Power Automate, I covered it in this video: https://youtu.be/qdcUYE3swxU
     
    Let me know if you still got issues. 
     
    Best regards
    Mathias Kjeldsen
     
    ---
    If this has helped solve your problem, please mark it as Solution. 

    Connect with me on social platforms by using the links below.
    YouTube: https://www.youtube.com/@matkjeldsen 
    LinkedIn: https://www.linkedin.com/in/mathiaskjeldsen/
  • ChristianAbata Profile Picture
    ChristianAbata 8,947 Most Valuable Professional on at
    Re: Copying excel row table data from one excel to anther excel sheet

    hi @Mahipundir I think you can use Run Script

     

    Solved: Excel (Business) Email Cell Value Not In a Table - Power Platform Community (microsoft.com)

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 >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans