Unanswered

Copying files with properties from one site to another

(0) Share

Report

Posted on by User190

Hi,

I have two SharePoint Sites. I need to copy files with its properties from one library to another library located on another site. I can copy files, but without its properties. The problem is what there are some look-up columns. Can you provide a solution please?

Screenshot 2022-09-21 112150.png Screenshot 2022-09-21 112215.png

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@User190 so i understand that you want to copy data of lookup columns as well while copy files from one site to another? So i understand that your source and target document libraries are in different site, the lookup columns within those libraries must be referring to different lists? In that case you will need to take lookup column value from source library, query that data in target lookup lists, then take id of that lookup list item to update it in target document library.

Was this reply helpful? Yes No
DorotaK 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Anna, If there is a list with several lookup columns, shall I take IDs one by one? Could you please help with some screenshots to follow your advice? " take lookup column value from source library, query that data in target lookup lists"

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

1. Take value of the lookup column from source list
2. Use Get Items to get items from the target list which is used in the lookup column
3. From outputs of Get Items, take the first element id using expressions first(body('GetItems')?['value'])?['Id’]
4. Use that item id in the update action to update value of lookup column

Was this reply helpful? Yes No