Copy Files from one SharePoint library to another using Power Automate

By -
    In this post we will see how to copy files, when we upload files to one SharePoint library it will be automatically copied to another SP library using Power Automate.

Scenario 1: Copy File To Same Level (Files will be copied library to another library & not subfolder level)
Scenario 2: Copy File To Different Level dynamically(Files will be copied library sub folder to another library any subfolder)

Scenario 1:

Copy File To Same Level "SP Library -> SP Library"

    Copy File To Same Level. Files will be copied library to another library without subfolder levels.(Below is image is the complete code for scenario 1)


  • Create: From your Power Automate site > Create > Automated Cloud Flow > Enter Flow Name > Select trigger "When a file is created in a folder SharePoint" > Click Create


  • Enter SourceFile Details: Select trigger options of which "Site Address" & Library name > Click New Step > Search "SharePoint" > Select Copy File


  • Enter Copy File Details: In new step (Copy File) > select source & destination Site Address > select File to copy as "File Identifier" (which is returned by 1st step) > select Destination Library > select what to do if file already exists > click save



  • Output: Now if we upload file in Source Library it will automatically copy the file to Designation library


Scenario 2: 

Copy File To Different Sub Folders Level dynamically

    In this case we will copy the files from SP library sub folder to different library subfolder. 
    
    Source Library Subfolder: "DepartmentName(dynamic)/Location/Zone/EmployeeName(dynamic)"
    Destination Library Subfolder: "DepartmentName(dynamic)/EmployeeName(dynamic)"
    Here "DeptName & EmployeeName" subfolders are dynamic (Like Dept1,2,3... Employee1,2,3...)
Below image refers final Flow structure. Lets create step by step.




  • Create: Create > "Automated Cloud Flow" > Skip the trigger(we can select in next page) > Enter SharePoint > select trigger "For a selected File"


  • Enter SourceLibrary & CopyFile Details: Provide details (source Library) > Add new step same as scenario1  "Copy File" select relevant input as mentioned below ("File to Copy" Select "Identifier").
    Note here destination folder DepartmentName\EmployeeName are dynamic so we will get it in variable.




  • GetFileProperties:  To get DeptName & EmployeeName we need File path in a variable.
    Select "Add an Action" > "Get File Properties" > Enter source Library details. 




  • Get SourceFolderPath: 
    Select "Add an Action" > "Initialize Variable" > Enter Variable Name, type & value.
    Split the FilePath into array using '\' delimiter split(outputs('Get_file_properties')?['body/{Path}'],'/')


  • Get Department name: Select "Add an Action" > "Initialize Variable" > Enter Variable Name, type & value
    Here in Expression we given 1 since in array Dept is present in that position (Libraryname/Department/Location/Zone/Employee1)


  • Get Employee Name: Select "Add an Action" > "Initialize Variable" > Enter Variable Name, type & value
    Here in Expression we given 4 since in array Employee name is present in that position (Libraryname/Department/Location/Zone/Employee1)


  • In the "Copy File" Step > Replace "Department & Employee" variables in destination path (Add '/' between the variables)



Rename Flow with proper name and save the flow



Test Our Flow:

        When we go to source Library sub folder > select any file > By selection our Automate "MultiLevelFileCopy" > it will automatically copy file to relevant sub folder of destination library



Note: If you select existing file Flow will fail & throw error like "A file or folder with the name '<filename.txt>' already exists at the destination."






Refer this video for more details

Comments

Post a Comment

Popular posts from this blog

Upload Single/Multiple file by using the REST API and jQuery SharePoint 2013

By -
Image
Upload  Single/Multiple  file by using the REST API and jQuery SharePoint 2013 Here you can find how to upload single/multiple file in SharePoint 2013 Library using Rest API. We can use the Content Editor web part to call the script files. Include Script files in Content Editor: Go to content editor -> Edit Source -> enter the code like below (code for including the script files) For 'jquery.min.js' we can either use direct link from online or we can download to our SharePoint library & We can use that. <script src=" https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js" ></script> OR use the below code <script src="/ sites/<SiteName>/<Subsite>/SiteAssets/jquery-1.11.1.min.j s"></script> <script src="/ sites/ <SiteName>/<Subsite> /SiteAssets/taskpage.js " type="text/javascript"></script> <script src=" /sites/ <SiteName>/<Subs
Read more

A type named 'SP.Data. could not be resolved by the model error

By -
Image
When we are trying to update task list we will get this error " A type named 'SP.Data. could not be resolved by the model error. When a model is available, each type name must resolve to a valid name must resolve to a a valid type" This happens because there is a space in the list name. To resolve this issue we need to get the exact list name to be used in "SP.Data" 1.Use the below URL in chrome browser <SiteUrl>/_api/web/lists/GetByTitle('List Name')/ For Example:  https://SiteURL/_api/web/lists/GetByTitle('Workflow Tasks')/ Some times in Chrome browser you may get Authentication error. For that first open the list from your Chrome browser & then use the above URL. 2.Find "SP.Data" -> now you will get the list name that you can be used in SP.Data.ListNameListitem
Read more

Add content type to SharePoint List/Library using REST API

By -
Add content type to SharePoint List/Library using REST API Use this below code to add content type to SharePoint Library using REST API. For this you need to use the content type ID. Below function will get the content type ID from content type name & we will pass the content type id to next function which will update content type to list/library. var   varContentTypeName = " Your Content Type name "; var   Listname = " Your List name where you want to add content type "; //This will get the content type ID from content type Name function  getContentTypeID() { var deferred = $.Deferred();     var  isCurrentUserIsApprover = false ; var  serverURL = _spPageContextInfo.webAbsoluteUrl; var  listURL = String.format(" {0}/_api/web/AvailableContentTypes?$select=Name,Id,StringId&$filter=Name eq '"+varContentTypeName+"' ",serverURL); $.ajax({ url: listURL, type: " GET ", async: false, headers:
Read more