cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Copying and Pasting Excel Files

Hello Flow,

 

How do I copy and paste excel files that content everything in the first excel file? The File is stored in sharepoint and I want to copy it into a different folder.

 

 

Thanks,

AskQuestions

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Copying and Pasting Excel Files

Hi @Anonymous,

I have tested your Flow on my side in two ways: 1 is copy file after update the Excel file, 2 is creating file according to the Excel file.

Annotation 2019-08-28 153740.png

I found the created file will not get the lasted Excel file, but the copied file will. So I suggest you can use the Copy file action instead of creating the file. (Please notice to set the if another file is already here relace it.)

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

View solution in original post

14 REPLIES 14
Highlighted
Super User III
Super User III

Re: Copying and Pasting Excel Files

@Anonymous 

Can you proivde some additional explanation of what you are trying to accomplish?  That will make it much easier to assist.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Anonymous
Not applicable

Re: Copying and Pasting Excel Files

Flow is not copying all of my data.

 

Original File Has 21 rows of data:Screenshot (43).png

 

 

copyed file has 18 rows of data:

Screenshot (47).png

 

 

Flow Connection:

 

Capture2.PNGCapture3.PNG

 

Capture1.PNG

 

 

Thanks For replaying,

 

AskQuestions

Highlighted
Anonymous
Not applicable

Re: Copying and Pasting Excel Files

HI @ScottShearer ,

 

The Flow is not copying everything and I do not know why this is happening.

Can you reply back to me in the next 2-3 hours?

 

Thanks,

AskQuesitons

Highlighted
Super User III
Super User III

Re: Copying and Pasting Excel Files

@Anonymous 

How many times is the Flow looping when adding rows to the table?  18 or 21?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Anonymous
Not applicable

Re: Copying and Pasting Excel Files

As Many rows that are in the original excel file (Should be 21).

Highlighted
Super User III
Super User III

Re: Copying and Pasting Excel Files

@Anonymous 

Is it possible that you need to enlarge the table in the destination file?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Anonymous
Not applicable

Re: Copying and Pasting Excel Files

Highlighted
Super User III
Super User III

Re: Copying and Pasting Excel Files

@Anonymous 

Can you go into the destination file and manually add more rows to the table.  Then, run the Flow again.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Anonymous
Not applicable

Re: Copying and Pasting Excel Files

@ScottShearer 

'Here is a zoom in verison of the original file:

 

Capture6.PNG

Highlighted
Anonymous
Not applicable

Re: Copying and Pasting Excel Files

@ScottShearer 

 

The row that I mannulay entered got over written by the new rows coping in from flow.

Highlighted
Super User III
Super User III

Re: Copying and Pasting Excel Files

@Anonymous 

I am not suggesting that you manually add rows of data to the table.  My suspicion is that the table is not automatically expanding as rows of data are added from Flow.  My suggestion is to redefine the size of the table in the destination file - make sure the table is large enough t hold all rows being copied in.  Once you do that, run your Flow again and see if all of the rows are copied to the destination file.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Anonymous
Not applicable

Re: Copying and Pasting Excel Files

HI @ScottShearer,

 

I do not know how to redefine the size of the table and also I do not know this could be something I could do everytime the flow is running since the flow makes a new file every time.

 

Thanks,

AskingQuestions

Highlighted
Community Support
Community Support

Re: Copying and Pasting Excel Files

Hi @Anonymous,

I have tested your Flow on my side in two ways: 1 is copy file after update the Excel file, 2 is creating file according to the Excel file.

Annotation 2019-08-28 153740.png

I found the created file will not get the lasted Excel file, but the copied file will. So I suggest you can use the Copy file action instead of creating the file. (Please notice to set the if another file is already here relace it.)

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

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Copying and Pasting Excel Files

I am open to new Ideas  in why create file is not working.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (6,477)