Copying and Pasting Excel Files

[Anonymous]

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

[ScottShearer]

@Anonymous 

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

[Anonymous]

Flow is not copying all of my data.

Original File Has 21 rows of data:

copyed file has 18 rows of data:

Flow Connection:

Thanks For replaying,

AskQuestions

[Anonymous]

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

[ScottShearer]

@Anonymous 

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

[Anonymous]

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

[ScottShearer]

@Anonymous 

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

[Anonymous]

@ScottShearer 

[ScottShearer]

@Anonymous 

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

[Anonymous]

@ScottShearer 

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

[Anonymous]

@ScottShearer 

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

[ScottShearer]

@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.

[Anonymous]

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

[v-litu-msft · Accepted solution]

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.

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.

[Anonymous]

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