cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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
Super User III
Super User III

@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
Anonymous
Not applicable

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

Anonymous
Not applicable

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

@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
Anonymous
Not applicable

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

@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
Anonymous
Not applicable

@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
Anonymous
Not applicable

@ScottShearer 

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

 

Capture6.PNG

Anonymous
Not applicable

@ScottShearer 

 

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

@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
Anonymous
Not applicable

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

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (7,044)