Copy Document Libraries (with contents) from List information to Subsite

Taylor Ram

• Created May 02, 2023 15:04

Greetings,

This post is seeking suggestions for possible/best methods (Actions) for moving the contents of (2) Document Libraries, to a single Library in a subsite... involving a List that contains the URLs to both Document Libraries.

I have accomplished this in different ways in the past using Power Automate, but once I got into trying to do something similar with Skybow Actions, I could quickly see multiple ways to accomplish this, but wasn't sure what would work best. Considering the URLs for the Document Libraries exists within the list, I figured there might be a way (Variables &/or the method of using Library Templates to copy files/folders) to greatly simplify the approach & number of Actions needed. At the most basic level, I am not sure if it would be easiest to approach this by using (1) the URLs in the list, or (2) Get Items actions...I figured there might be nuances or limitations I haven't considered between either approach.

All suggestions are greatly appreciative!

 

I will post screenshots below, but the overall concept I am trying to achieve is:

1. In a list (which contains links to Document Library folders), select a single Item & click an Action button

2a. Information from the list is used to create a new Item in a subsite List

2b. All the contents from Doc Library 1 is copied into a subsite Document Library

2c. All the contents from Doc Library 2 is copied into the same subsite Document Library

 

Overall Data Structure & Action Flow

 

Root Site List with Links to (2) Document Libraries

 

Doc Library 1 (Bid Docs) - Levels 1-3

Lvl 2

Lvl 3

 

 

Doc Library 2 - Lvl 1-3

Lvl 2 & 3

 

Thanks for your time,

Taylor

0

• 

  Matthias_Walter

  • June 06, 2023 15:02

  Hi Taylor Ram,

  I haven't tried your full scenario, but I would use the "Copy Folder" action twice, which will copy content contained in this folder automatically: https://my.skybow.com/hc/en-us/articles/5769717851036 

  If I'm right, then the Bids and Estimates Documents are sublibraries of the bids list? To get the corresponding folder for each bid in these libraries you could use the following dynamic query function:

  For Bid Documents:
  [[@Web.GetFirstValueForQuery([[@Web.ServerRelativeUrl]]+'/biddocuments', '<Where><Eq><FieldRef Name="ProjectName" LookupId="TRUE" /><Value Type="Lookup">[[ID]]</Value></Eq></Where>', 'FileLeafRef')]]

  For Estimate Documents:
  [[@Web.GetFirstValueForQuery([[@Web.ServerRelativeUrl]]+'/estimatingdocuments1', '<Where><Eq><FieldRef Name="ProjectName" LookupId="TRUE" /><Value Type="Lookup">[[ID]]</Value></Eq></Where>', 'FileLeafRef')]]

  Just change the field "ProjectName" to your lookup name in the document libraries pointing to the bids list.

  Kind regards

  Matthias

  0

Please sign in to leave a comment.