--- title: "Copy files with SharePoint connector" url: "https://docs.signnow.com/docs/power-automate-signnow-copy-sharepoint-files" type: "page" section: "Integrations" slug: "power-automate-signnow-copy-sharepoint-files" --- # Copy files with SharePoint connector # Copy files with SharePoint connector Filter files in a source SharePoint library by criteria and copy the matches into another folder, using Power Automate's SharePoint connector. **Use case overview** Useful when files (for example, completed or signed documents) need to end up somewhere other than the default SharePoint integration (Team) folder. Instead of moving files manually, this flow filters a library by file properties and copies only the matching files to a destination folder. **Prerequisites** - A Power Automate account with access to the source and destination SharePoint sites - SharePoint connector permissions on both the source library and the destination folder - Familiarity with SharePoint's OData filter syntax, used to build the Filter Query **Flow overview** ```mermaid flowchart LR A["Get files (properties only)"] --> B["For each"] B --> C["Copy file"] ``` 1. **Get files (properties only)** action retrieves file metadata from the source library, narrowed down by a Filter Query. 2. **For each** loops through the filtered results one file at a time. 3. **Copy file** action copies each file from the loop into the destination folder. ![sn_pa_copy_file_2.png](/reference-assets/images/Power%20Automate/copy_files/sn_pa_copy_file_2.png) ## Step 1. Create a new flow - In Power Automate, go to **My flows**. - Click **New flow** > **Instant cloud flow** > **Manually trigger a flow**. - Click **Create**. ![sn_pa_copy_file_1.png](/reference-assets/images/Power%20Automate/copy_files/sn_pa_copy_file_1.png) ## Step 2. Set up the Get files (properties only) action Add the SharePoint action **Get files (properties only)** to the flow. Click **+** and start typing *sharepoint* in the search bar. Select the **Get files (properties only)** action. ![sn_pa_copy_file_3.png](/reference-assets/images/Power%20Automate/copy_files/sn_pa_copy_file_3.png) Set up the action parameters. ![sn_pa_copy_file_4.png](/reference-assets/images/Power%20Automate/copy_files/sn_pa_copy_file_4.png) The table below describes each field shown above. | Field | Required | Description / what to enter | | :--- | :--- | :--- | | **Site Address** | Yes | The source SharePoint site, e.g. `https://contoso.sharepoint.com/sites/sitename`. | | **Library Name** | Yes | The document library that holds the files you would like to copy, e.g. `Documents`. | | **Filter Query** | No | Filter that limits which files are returned. See Filter query reference below. | | **Top Count** | No | Maximum number of files to return, e.g. `50`. | | **Limit Columns by View** | No | Restrict which columns are returned by selecting an existing library view, e.g. `All Documents`. | | **Limit Entries to Folder** | No | Restrict the search to one folder. Select the source subfolder here; leave blank to scan the whole library. | | **Include Nested Items** | No | Whether to also return files from sub-folders. Default = `true`. Set to `No` to copy only the top-level folder. | ### Filter query reference Key file properties: | Property | Meaning | Example value | | :--- | :--- | :--- | | **FileLeafRef** | File name only | `'Invoice.pdf'` | | **FileRef** | Full server-relative path | `'/sites/demo/Shared Documents/Invoice.pdf'` | | **FileDirRef** | Containing folder path | `'/sites/demo/Shared Documents'` | | **FSObjType** | Item type: `0` = file, `1` = folder | `0` | | **Modified / Created** | Date columns | `'2026-06-25T00:00:00Z'` | Filter examples: | Goal | Filter Query | | :--- | :--- | | Only files (exclude folders) | `FSObjType eq 0` | | Only PDFs | `substringof('.pdf', FileLeafRef) and FSObjType eq 0` | | Exact file name | `FileLeafRef eq 'Invoice.pdf'` | | Name starts with "2026" | `startswith(FileLeafRef, '2026')` | | Modified today or later | `Modified ge '2026-06-25T00:00:00Z'` | | A choice/text column equals a value | `Status eq 'Approved' and FSObjType eq 0` | ## Step 3. Add Copy file action inside a For each loop Add the SharePoint **Copy file** action and reference **value** (the file list) from the **Get files (properties only)** step in its fields. Click **+** and start typing *sharepoint* in the search bar. Select the **Copy file** action. Set up the action parameters. In the **File to Copy** field, select the lightning icon and start typing *identifier* in the search bar. Select **Identifier** from the **Get files (properties only)** action. ![sn_pa_copy_file_5.png](/reference-assets/images/Power%20Automate/copy_files/sn_pa_copy_file_5.png) > When you reference value from **Get files (properties only)**, Power Automate automatically wraps **Copy file** in a **For each** loop. You don't need to add the loop manually. The loop runs **Copy file** once per matched file. ![sn_pa_copy_file_6.png](/reference-assets/images/Power%20Automate/copy_files/sn_pa_copy_file_6.png) The table below explains each field used to configure the **Copy file** action. | Field | Required | Description / what to enter | | :--- | :--- | :--- | | **Current Site Address** | Yes | The source site that contains the file being copied, e.g. `https://contoso.sharepoint.com/sites/sitename`. Must match the site used in **Get files**. | | **File to Copy** | Yes | The identifier of the file to copy. Use the dynamic content **Identifier** from the current **For each** item, so each loop pass copies the right file. | | **Destination Site Address** | Yes | The site that contains the destination library/folder. Can be the same as, or different from, the source site. | | **Destination Folder** | Yes | The target folder where the copy is placed. Use the folder picker to select the destination folder. | | **If another file is already there** | Yes | How to handle a name collision at the destination: `Copy with a new name`, `Replace`, or `Fail this action`. | ## Step 4. Save the flow Click **Save** in the top-right corner of the flow designer. ## Result Once the flow runs, files matching the Filter Query are copied from the source library into the destination folder, leaving the originals in place. --- **See also:** [Getting started with SignNow for SharePoint Online](/docs/sharepoint) --- *Full page: https://docs.signnow.com/docs/power-automate-signnow-copy-sharepoint-files*