web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Copying files with properties from one site to another

(0) ShareShare
ReportReport
Posted on by

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?

photo_5285215415783505490_y.jpgScreenshot 2022-09-21 112150.pngScreenshot 2022-09-21 112215.png

I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: Copying files with properties from one site to another

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

  • DorotaK Profile Picture
    2 on at
    Re: Copying files with properties from one site to another

    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"

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: Copying files with properties from one site to another

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard