copy file from onedrive to sharepoint with powershell or automate

Question

copy file from onedrive to sharepoint with powershell or automate

豬肉榮 1

Hi , Everyone

This is what my boss want to do .........copy one account's onedrive file (almost 3TB) to specify sharepoint site , now , I found three methods .

First : login user onedrive , use "Copy to" function to copy file to sharepoint site , but the poor performance is not acceptable .

Second : use power automate , in oder to face user's file hierarchy , now I still study how to achieve this goal . if user's onedrive only one level file , I think I can achieve it !

Third : user powershell ......about this issue , I still studying ~~~

So , could everyone give me some guides to get my boss need !!!

chavda Rahul 5

Sure, here's how you can copy a file from OneDrive to SharePoint using PowerShell: Visit My Blog

First, make sure you have the SharePoint Online PowerShell module installed on your computer. You can install it by running the following command in PowerShell as an administrator: Install-Module -Name Microsoft.Online.SharePoint.PowerShell
Next, connect to both your OneDrive and SharePoint Online accounts using the following commands:

    sqlCopy code
    Connect-PnPOnline -Url https://yourtenant-my.sharepoint.com/personal/username_domain_com -Credentials (Get-Credential)

Connect-PnPOnline -Url https://yourtenant.sharepoint.com/sites/yoursite -Credentials (Get-Credential)
    ```
    
    
    Replace **`yourtenant`** with your actual tenant name, **`username_domain_com`** with your OneDrive username and domain name, and **`yoursite`** with the name of your SharePoint Online site.
1. Once you are connected to both accounts, use the **`Copy-PnPFile`** command to copy the file from your OneDrive to SharePoint. Here's an example command:

rustCopy code
Copy-PnPFile -SourceUrl "/Documents/FileName.docx" -TargetUrl "/Shared Documents/FileName.docx" -Force
```


Replace **`FileName.docx`** with the name of the file you want to copy, and make sure the source and target URLs are correct for your OneDrive and SharePoint Online accounts.

Finally, run the command to copy the file. You should see a progress bar indicating the status of the copy operation.

    rustCopy code
    Copy-PnPFile -SourceUrl "/Documents/FileName.docx" -TargetUrl "/Shared Documents/FileName.docx" -Force
    ```
    
    
That's it! Your file should now be copied from OneDrive to SharePoint using PowerShell. You can automate this process by creating a script or scheduling the PowerShell commands to run automatically at specific times.

2 answers

Your answer

chavda Rahul 5 Reputation points

2023-03-05T09:27:47.8333333+00:00

Sure, here's how you can copy a file from OneDrive to SharePoint using PowerShell: Visit My Blog

First, make sure you have the SharePoint Online PowerShell module installed on your computer. You can install it by running the following command in PowerShell as an administrator: Install-Module -Name Microsoft.Online.SharePoint.PowerShell

Next, connect to both your OneDrive and SharePoint Online accounts using the following commands:

sqlCopy code Connect-PnPOnline -Url https://yourtenant-my.sharepoint.com/personal/username_domain_com -Credentials (Get-Credential) Connect-PnPOnline -Url https://yourtenant.sharepoint.com/sites/yoursite -Credentials (Get-Credential) ``` Replace **`yourtenant`** with your actual tenant name, **`username_domain_com`** with your OneDrive username and domain name, and **`yoursite`** with the name of your SharePoint Online site. 1. Once you are connected to both accounts, use the **`Copy-PnPFile`** command to copy the file from your OneDrive to SharePoint. Here's an example command:

rustCopy code Copy-PnPFile -SourceUrl "/Documents/FileName.docx" -TargetUrl "/Shared Documents/FileName.docx" -Force ``` Replace **`FileName.docx`** with the name of the file you want to copy, and make sure the source and target URLs are correct for your OneDrive and SharePoint Online accounts.

Finally, run the command to copy the file. You should see a progress bar indicating the status of the copy operation.

rustCopy code Copy-PnPFile -SourceUrl "/Documents/FileName.docx" -TargetUrl "/Shared Documents/FileName.docx" -Force ``` That's it! Your file should now be copied from OneDrive to SharePoint using PowerShell. You can automate this process by creating a script or scheduling the PowerShell commands to run automatically at specific times.

Answer 1

豬肉榮 1

Thanks !

I will test today on office

Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-03-08T05:48:30.78+00:00

Hi ,

Is there any update?

Have you tried the method above?
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-03-17T09:00:47.7866667+00:00

Would you please provide us with an update on the status of your issue?

I am checking to see if the problem has been resolved.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-03-22T06:55:56.1433333+00:00

I am checking to see if the problem has been resolved. If you have any questions or progress, you can contact me in time.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Answer 2

Hi. the Copy-PnPFile was lacking the full functionality to allow copying from OneDrive to SharePoint and vice versa. Recently, they confirmed the mobile PnP.Powershell has been upgraded with the solution for this. and I used it and it worked as expected, however my case was from SharePoint to OneDrive based on that, and assuming that you have access to both locations:

Install-Module pnp.powershell
Import-Module pnp.powershell
$SourceConn = Connect-PnPOnline -URL $SourceSiteURL -Interactive -ReturnConnection
Copy-PnPFile -Connection $SourceConn -SourceUrl $f.ServerRelativeUrl -TargetUrl $DestinationLibraryURL -Force -OverwriteIfAlreadyExists

SourceURL is a relative path that start with: /Documents/....Target URL is a full path TargetUrl is a full path like https://MYTENANT.sharepoint.com/sites/SITENAME/Shared%20Documents/MYFOLDER

Share via

copy file from onedrive to sharepoint with powershell or automate

2 answers

Your answer