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 / 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,327 Super User 2025 Season 2 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

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