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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / how to copy specific c...
Power Automate
Unanswered

how to copy specific columns from Excel sheet to new workbook

(0) ShareShare
ReportReport
Posted on by 2

We want to copy only specific columns from our private Excel workbook to a shared workbook and overwrite the entire destination file each night (and will use the recurrence action). We only care about the columns and not the content of the rows/cells--basically a copy and paste of only specific columns, overwritten each night. I know how to set up the recurrence but need help on how to choose the columns. Thank you for the assistance!

Categories:
I have the same question (0)
  • Srini007 Profile Picture
    3,463 Super User 2026 Season 1 on at

    Hi @lgattoni 

     

    Can you share as screenshot of the file where which need to be copied? and also let me know where these files are stored

     

    Thanks,

    Srini

  • lgattoni Profile Picture
    2 on at

    One excel file on sharepoint (File P) being copied to an excel file in another sharepoint folder (File S).
    File P: which contains columns A through AX. Copy only columns A through L to File S and overwrite content already contained in File S. 
    I can't share screenshots due to confidentiality issues. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard