Answered

Copy file from one folder to spcific folder

(0) Share

Report

Posted on by poorteeth

Hello,

There is sernario that I need to copy file from one folder to a special folder, but there has to be a matching relationship in this case.

For instance, the relation is:

- SO 1,2,3 shared invoice 111

- SO 4,5,6,7 is invoice 222

- SO 8,9,10,11,12 shared invoice 333.

2020-05-25 20_45_17-New Microsoft Excel Worksheet.xlsx - Excel.png

Now I have IV 111, 222, 333 in one folder already and created folder 1-12, need to:

- copy 111 to folder 1, 2, 3

- copy 222 to folder 4, 5, 6, 7

- copy 333 to folder 8,9,10,11,12

Is there any possibilty to bulid to flow of this kind of sernario ?

Thanks !

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

LEts see I understood your requirements:

"Now I have IV 111, 222, 333 in one folder already and created folder 1-12, need to:

- copy 111 to folder 1, 2, 3

- copy 222 to folder 4, 5, 6, 7

- copy 333 to folder 8,9,10,11,12"

So all files 111, 222, 333 are created in the same folder? If so, how we can identify a file is of type 111, 222 or 333? By means of the filename?

Thanx!

Was this reply helpful? Yes No
poorteeth 39 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes, file 111, 222, 333 are created in one folder, named as 111, 222, 333 (this should be the variables in the real cases)

Now I just need to cpoy these files to the right folder follow by the relationship in the excel.
desitnation folder is named as SO#, and invoice file is named as the value in column B.

Thanks!

Was this reply helpful? Yes No
v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @poorteeth ,

Do you want to copy the file based on the excel table and the excel table content would be modifed?

Have you created table to the excel file?

Or does the excel table would never be updated, and the content would always be as below?

- copy 111 to folder 1, 2, 3

- copy 222 to folder 4, 5, 6, 7

- copy 333 to folder 8,9,10,11,12

Where is the excel files saved in? OneDrive or sharepoint library?

Best regards,

Alice

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

Was this reply helpful? Yes No
poorteeth 39 on at

Like (0)

Report
Copy link

Link copied!

Hi Alice,

Here is my comments:

Do you want to copy the file based on the excel table and the excel table content would be modifed?
Yes, I want to copy the file based on the excel table, they won`t be modified once the excel file is put on the onedrive.
Have you created table to the excel file?
Yes, excel is formated as table, I know that, flow only read table format.
Where is the excel files saved in? OneDrive or sharepoint library?
The excel file is saved in onedrive.

Thanks.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @poorteeth ,

You could refer to screenshot below to create the flow:

Best regards,

Alice

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

Was this reply helpful? Yes No
poorteeth 39 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Alice.
It works, really appreciate your kindly help.

Was this reply helpful? Yes No