September 2022 – PhoeNIXBird Networks

[SPO/PNP] Bulk create a certain number of DOCX files in a document library

September 28, 2022 Andrei Rachita 0

So, besides PnP, you will need to have a file called WordDummy.docx in the c:\temp folder. Then, just run the script (and adapt it to your URLs):

#Parameters
$SiteURL = "https://tenant.sharepoint.com/sites/MP3TEST"
$LibraryName = "BULK"
$LocalFile= "C:\temp\WordDummy.docx"
$MaxFilesCount = 500

Try {
    #Get the File
    $File = Get-ChildItem $LocalFile

    #Connect to PnP Online
    Connect-PnPOnline -Url $SiteURL -Interactive
    #$Library = Get-PnPList -Identity $LibraryName

    $FileCounter = 1
    While($FileCounter -le $MaxFilesCount)
    {
           $NewFileName= $File.BaseName+"_"+$FileCounter+".docx"
           Try
           {
                 Add-PnPFile -Path $File -Folder $LibraryName -NewFileName $NewFileName | Out-Null
           }
           Catch
           {
                 Write-host "Error: $($_.Exception.Message)" -foregroundcolor Red
           }
           Write-host -f Green "New File '$NewFileName' Created ($FileCounter of $MaxFilesCount)!"
           $FileCounter++
    }
}
Catch {
    write-host -f Red "Error Uploading File:"$_.Exception.Message
}

#Parameters

$SiteURL = "https://tenant.sharepoint.com/sites/MP3TEST"

$LibraryName = "BULK"

$LocalFile= "C:\temp\WordDummy.docx"

$MaxFilesCount = 500

Try {

#Get the File

$File = Get-ChildItem $LocalFile

#Connect to PnP Online

Connect-PnPOnline -Url $SiteURL -Interactive

#$Library = Get-PnPList -Identity $LibraryName

$FileCounter = 1

While($FileCounter -le $MaxFilesCount)

{

$NewFileName= $File.BaseName+"_"+$FileCounter+".docx"

Try

{

Add-PnPFile -Path $File -Folder $LibraryName -NewFileName $NewFileName | Out-Null

}

Catch

{

Write-host "Error: $($_.Exception.Message)" -foregroundcolor Red

}

Write-host -f Green "New File '$NewFileName' Created ($FileCounter of $MaxFilesCount)!"

$FileCounter++

}

Catch {

write-host -f Red "Error Uploading File:"$_.Exception.Message

}

The […]

[PnP PowerShell] Copy a SPO list from one site collection to another

September 5, 2022 Andrei Rachita 0

OK, so we need to copy a site collection from one site collection to another. Here’s a way to do it:

$site1 = "https://tenant.sharepoint.com/site/site1"
Connect-PnPOnline -Url $site1 -Interactive

$template = ".\products.xml"
Get-PnPSiteTemplate -Out $template -ListsToExtract "TESTLIST1" -Handlers Lists

#for multiple lists use:
#$template = ".\products.xml"
#Get-PnPSiteTemplate -Out $template -ListsToExtract "TESTLIST1", "TESTLIST2" -Handlers Lists

$site1 = "https://tenant.sharepoint.com/site/site1"

Connect-PnPOnline -Url $site1 -Interactive

$template = ".\products.xml"

Get-PnPSiteTemplate -Out $template -ListsToExtract "TESTLIST1" -Handlers Lists

#for multiple lists use:

#$template = ".\products.xml"

#Get-PnPSiteTemplate -Out $template -ListsToExtract "TESTLIST1", "TESTLIST2" -Handlers Lists

The resulting XML […]