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

@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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,517)