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 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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors
Users online (1,496)