Unanswered

Power automate to Copy/move files from one site to another and add metadata

(1) Share

Report

Posted on by Wijcc

Hi there,

I need to merge some sharepoint sites together but when copy is done, I need to have a column/metadata about the original location/have some new metadata added. So users can know that these files/folders came from originally.
So for example I need to move/copy files from Site A to Site B, and in site B when the files are copied create a new column/metadata with the value "Dept D1" for all the file & folders copied. I would create a new column in Site B called "old depart".

Then I need to copy files from Site C to Site B, and when the files are folders are copied over in the column "old depart" in site B, the value "Depart D2" be added/inserted for all the files and folders copied.

Can this be easily done using power automate, this will be my first time trying to use power automate so any help/advice would be greatly appreciated.

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

sandeepstw 312 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Wijcc ,

Yes, this can be done in this way using Power Automate.

Create Columns in Site B:

In Site B, create a new column named "Old Depart".

Power Automate Flow-

Trigger: Use "When a file is created or modified (properties only)" on Site A and Site C.

Actions:

1. Retrieve the properties of the file from Site A or Site C.

2. Use "Copy file" action to move the file to Site B.

3. Use "Update file properties" in Site B to set the "Old Depart" column-

i)For files from Site A, set "Old Depart" to "Dept D1".

ii)For files from Site C, set "Old Depart" to "Dept D2".

Flow Logic:

Create separate flows for Site A and Site C to Site B copy operations.

Please mark as solution if it helps.

Thanks,

Sandeep Mishra

Was this reply helpful? Yes No
Wijcc 7 on at

Like (1)

Report
Copy link

Link copied!

Thank you @sandeepstw , it sounds simple to do in principle.
I have already created a column called "old depart" in site B.

So I need to create two separate power automate flows, one to copy files from Site A to Site B and another to copy from Site C to Site B.
Each flow, will/should
1) Retrieve the properties of the file from Site A or Site C.
2) Use "Copy file" action to move the file to Site B.
3) Use "Update file properties" in Site B to set the "Old Depart" column

Do I use copy file or folders, if I want to copy entire folders with all its contents?
I have tried using file properties action, but I need to enter an ID (unique identifier of item to be retrieved), I am confused to what this is referring to (see pic below?

Thank you

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes

Was this reply helpful? Yes No