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 columns fr...
Power Automate
Answered

How to copy columns from Excel sheet and past in new Excel sheet

(0) ShareShare
ReportReport
Posted on by 39

Hello,

 

Kindly guide me in below task.

 

Book1: having 1 column values are below

1

2

3

4

5

6

 

Book2: having 1 column values are below

10

10

10

10

10

10

 

I want above both columns in New worksheet (i.e. Book3).

 

Then I have to Avg. of that both the columns and create a New Column with results.

 

1  10  > 5.5

2  10  > 6

.

.

.

Kindly help me .

Bhavin

 

 

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    on at

    Hi 

     

    Yes i would love it please 

     

    thx

  • ahmadbutt Profile Picture
    255 on at

    Can you maybe post images of your solution? And if not can you tell me what sort of trigger did you used in the beginning?

  • Verified answer
    bhavinrshah Profile Picture
    39 on at

    Hello @v-alzhan-msft 

     

    Below is the solution of how to copy column and past in different excel sheet.

     

    Step 1: Create/Manage an existing sheet with a TABLE structure.

    Step 2: Choose 'List rows present in a Sheet' - Choose a specific sheet.

    Step 3: If you choose the right sheet then Table will be populated automatically.

    Step 4: you need to start your looping on that specific column.

    Step 5: 'Apply Each' you need to add 'Add a row into table'

    Step 6: Run/Trigger your Flow.

    Step 7: Once done you can see your column will be copy and paste in a new sheet.

     

    Bhavin

  • v-alzhan-msft Profile Picture
    on at

    Hi @bhavinrshah ,

     

    Could you please share more details about your solution?

    And if your problem has been solved,please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • bhavinrshah Profile Picture
    39 on at

    Hello @v-alzhan-msft 

     

    Thanks for your Reply.

     

    I have done with my task and find the solution which can copy multiple columns from different Excel sheet and past in Different sheet as a result.

     

    Kindly let me know if you want any help in this direction.

     

    Thanks 

    Bhavin Shah

    Skype: bhavinshah50

     

  • v-alzhan-msft Profile Picture
    on at

    Hi @bhavinrshah ,

     

    Sorry for I'm afraid that there is no any easy way to achieve your requirement with microsoft flow.

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard