Microsoft Technologies – Page 2 – PhoeNIXBird Networks

[SPO/PNP] [Sample] Get all files created by a specific user

February 8, 2023 Andrei Rachita 0

The script below can only be used as a sample! So, here goes:

Connect-PnPOnline -Url https://tenant-admin.sharepoint.com -Interactive

$allsites = Get-PnPTenantSite -Filter "Url -like 'hub'"
$Resultset = @()
$Resultset += "_Name;RelativeUrl;CreatedBy;CreatedOn;ModifiedBy;ModifiedOn;FileSizeInKB"
foreach ($site in $allsites)
{
    Connect-PnPOnline -Url $site.Url -Interactive
    $ctx = Get-PnPContext
    Set-PnPContext -Context $ctx
    Write-Host "Processing: ", $site.url -ForegroundColor Yellow
    $lists = Get-PnPList | Where-Object {$_.BaseTemplate -eq 101 -and $_.Hidden -eq $false} #Or $_.BaseType -eq "DocumentLibrary"
    #WRite-Host $lists.Count
    foreach ($list in $lists)
    {
        #Write-Host $list.Title $list.Id
        $ListItems = Get-PnPListItem -List $list -PageSize 2000 | Where {$_.FieldValues.Editor.Email -eq admin@tenant.onmicrosoft.com -and $_.FileSystemObjectType -eq "File"}
        foreach ($listitem in $ListItems)
        {
            $Name  = $listitem.FieldValues.FileLeafRef
            $RelativeURL = $listitem.FieldValues.FileRef
            $CreatedBy =  $listitem.FieldValues.Author.Email
            $CreatedOn = $listitem.FieldValues.Created
            $ModifiedBy =  $listitem.FieldValues.Editor.Email
            $ModifiedOn = $listitem.FieldValues.Modified
            $FileSizeInKB = $listitem.FieldValues.File_x0020_Size
            Write-Host "_$Name;$RelativeUrl;$CreatedBy;$CreatedOn;$ModifiedBy;$ModifiedOn;$FileSizeInKB"
            $Resultset += "_$Name;$RelativeUrl;$CreatedBy;$CreatedOn;$ModifiedBy;$ModifiedOn;$FileSizeInKB"
    
        }
    }

}
$Resultset &gt; C:\temp\result.csv

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

Connect-PnPOnline -Url https://tenant-admin.sharepoint.com -Interactive

$allsites = Get-PnPTenantSite -Filter "Url -like 'hub'"

$Resultset = @()

$Resultset += "_Name;RelativeUrl;CreatedBy;CreatedOn;ModifiedBy;ModifiedOn;FileSizeInKB"

foreach ($site in $allsites)

{

Connect-PnPOnline -Url $site.Url -Interactive

$ctx = Get-PnPContext

Set-PnPContext -Context $ctx

Write-Host "Processing: ", $site.url -ForegroundColor Yellow

$lists = Get-PnPList | Where-Object {$_.BaseTemplate -eq 101 -and $_.Hidden -eq $false} #Or $_.BaseType -eq "DocumentLibrary"

#WRite-Host $lists.Count

foreach ($list in $lists)

{

#Write-Host $list.Title $list.Id

$ListItems = Get-PnPListItem -List $list -PageSize 2000 | Where {$_.FieldValues.Editor.Email -eq admin@tenant.onmicrosoft.com -and $_.FileSystemObjectType -eq "File"}

foreach ($listitem in $ListItems)

{

$Name = $listitem.FieldValues.FileLeafRef

$RelativeURL = $listitem.FieldValues.FileRef

$CreatedBy = $listitem.FieldValues.Author.Email

$CreatedOn = $listitem.FieldValues.Created

$ModifiedBy = $listitem.FieldValues.Editor.Email

$ModifiedOn = $listitem.FieldValues.Modified

$FileSizeInKB = $listitem.FieldValues.File_x0020_Size

Write-Host "_$Name;$RelativeUrl;$CreatedBy;$CreatedOn;$ModifiedBy;$ModifiedOn;$FileSizeInKB"

$Resultset += "_$Name;$RelativeUrl;$CreatedBy;$CreatedOn;$ModifiedBy;$ModifiedOn;$FileSizeInKB"

}

$Resultset > C:\temp\result.csv

[SPO/PNP] Bulk creation of site collections using a CSV file as data input

December 8, 2022 Andrei Rachita 0

The goal is to have multiple site collections created in bulk with data input from a CSV file . The CSV file will contain the […]

[SPO/PNP] Bulk update UPA property with a certain value read from a CSV file

December 8, 2022 Andrei Rachita 0

OK, so the goal of this script is to update a User Profile property (in this case Work E-mail) for several users having a CSV […]

[SPO/CSOM] Send and e-mail from SPO using CSOM

November 11, 2022 Andrei Rachita 0

So, let’s send and e-mail directly from SharePoint Online. The e-mail will appear as being sent from: no-reply@sharepointonline.com So, here goes:

clear
#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\csom\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\csom\Microsoft.SharePoint.Client.Runtime.dll"



#variables region.
$siteURL="https://tenant.sharepoint.com/teams/Asite" 
$spUserName="user@domain.com"
$BCCUserName = "user@domain.com" 
$ccUserName = "user@domain.com"
$toUserName = "user@domain.com"
$emailBody = "Test email from SharePoint online CSOM PowerShell script." 
$password = "mysecretpassword"
#variables region end.
$securePassword= $Password | ConvertTo-SecureString -AsPlainText -Force
  
#Setup the Context
try
{
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteURL)
$ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($spUserName, $securePassword)  
$clientCSOMEMailProperties=New-Object Microsoft.SharePoint.Client.Utilities.EmailProperties        
$clientCSOMEMailProperties.BCC= [Collections.Generic.List[String]]@($BCCUserName) 
$clientCSOMEMailProperties.CC=[Collections.Generic.List[String]]@($CCUserName) 
$clientCSOMEMailProperties.To=[Collections.Generic.List[String]]@($ToUserName) 
$clientCSOMEMailProperties.From=$spUserName 
$clientCSOMEMailProperties.Body=$emailBody
$clientCSOMEMailProperties.Subject="Test email from SharePoint online CSOM PowerShell script." 
$csomUtility=[Microsoft.SharePoint.Client.Utilities.Utility]::SendEmail($ctx, $clientCSOMEMailProperties)        
$ctx.ExecuteQuery() 
$ctx.Dispose() 
}
catch 
{
  
    $errorMessage = $_.Exception.Message +"in sending email from CSOM SharePoint online";
    Write-Host $errorMessage -BackgroundColor Red
    Write-Log $errorMessage 
}         
Write-Host "##########################################################"
Write-Host "Test email from SharePoint online CSOM PowerShell script." -ForegroundColor Green

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

clear

#Load SharePoint CSOM Assemblies

Add-Type -Path "C:\csom\Microsoft.SharePoint.Client.dll"

Add-Type -Path "C:\csom\Microsoft.SharePoint.Client.Runtime.dll"

#variables region.

$siteURL="https://tenant.sharepoint.com/teams/Asite"

$spUserName="user@domain.com"

$BCCUserName = "user@domain.com"

$ccUserName = "user@domain.com"

$toUserName = "user@domain.com"

$emailBody = "Test email from SharePoint online CSOM PowerShell script."

$password = "mysecretpassword"

#variables region end.

$securePassword= $Password | ConvertTo-SecureString -AsPlainText -Force

#Setup the Context

try

{

$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteURL)

$ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($spUserName, $securePassword)

$clientCSOMEMailProperties=New-Object Microsoft.SharePoint.Client.Utilities.EmailProperties

$clientCSOMEMailProperties.BCC= [Collections.Generic.List[String]]@($BCCUserName)

$clientCSOMEMailProperties.CC=[Collections.Generic.List[String]]@($CCUserName)

$clientCSOMEMailProperties.To=[Collections.Generic.List[String]]@($ToUserName)

$clientCSOMEMailProperties.From=$spUserName

$clientCSOMEMailProperties.Body=$emailBody

$clientCSOMEMailProperties.Subject="Test email from SharePoint online CSOM PowerShell script."

$csomUtility=[Microsoft.SharePoint.Client.Utilities.Utility]::SendEmail($ctx, $clientCSOMEMailProperties)

$ctx.ExecuteQuery()

$ctx.Dispose()

}

catch

{

$errorMessage = $_.Exception.Message +"in sending email from CSOM SharePoint online";

Write-Host $errorMessage -BackgroundColor Red

Write-Log $errorMessage

}

Write-Host "##########################################################"

Write-Host "Test email from SharePoint online CSOM PowerShell script." -ForegroundColor Green

Enjoy!

[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
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

#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

1

2

3

4

5

6

7

8

9

$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 […]

[CSOM] Copy list items from one SPO list to another

August 19, 2022 Andrei Rachita 0

So, here goes:

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"

Function Copy-ListItems()
{
    param
    (
        [Parameter(Mandatory=$true)] [string] $SiteURL,
        [Parameter(Mandatory=$true)] [string] $SourceListName,
        [Parameter(Mandatory=$true)] [string] $TargetListName
    )    
    Try {
        #Setup Credentials to connect
        $Cred = Get-Credential
        $Cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password)
    
        #Setup the context
        $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
        $Ctx.Credentials = $Cred

        #Get the Source List and Target Lists
        $SourceList = $Ctx.Web.Lists.GetByTitle($SourceListName)
        $TargetList = $Ctx.Web.Lists.GetByTitle($TargetListName)
    
        #Get All Items from Source List
        $SourceListItems = $SourceList.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery())
        $Ctx.Load($SourceListItems)
        $Ctx.ExecuteQuery()
    
        #Get All fields from Source List &amp; Target List
        $SourceListFields = $SourceList.Fields
        $Ctx.Load($SourceListFields)
        $TargetListFields = $TargetList.Fields
        $Ctx.Load($TargetListFields)        
        $Ctx.ExecuteQuery()

        #Get each column value from source list and add them to target
        ForEach($SourceItem in $SourceListItems)
        {
            $NewItem =New-Object Microsoft.SharePoint.Client.ListItemCreationInformation
            $ListItem = $TargetList.AddItem($NewItem)        
 
            #Map each field from source list to target list
            Foreach($SourceField in $SourceListFields)
            {  
                #Skip Read only, hidden fields, content type and attachments
                If((-Not ($SourceField.ReadOnlyField)) -and (-Not ($SourceField.Hidden)) -and ($SourceField.InternalName -ne  "ContentType") -and ($SourceField.InternalName -ne  "Attachments") )  
                {
                    $TargetField = $TargetListFields | where { $_.Internalname -eq $SourceField.Internalname}
                    if($TargetField -ne $null)
                    {
                        #Copy column value from source to target
                        $ListItem[$TargetField.InternalName] = $SourceItem[$SourceField.InternalName]  
                    }
                }
            }
            $ListItem.update()
            $Ctx.ExecuteQuery()
        }

        write-host  -f Green "Total List Items Copied from '$SourceListName' to '$TargetListName' : $($SourceListItems.count)"
    }
    Catch {
        write-host -f Red "Error Copying List Items!" $_.Exception.Message
    }
}

#Set Parameters
$SiteURL= https://tenant.sharepoint.com/sites/DOCTEST1
$SourceListName="TESTLIST2222"
$TargetListName="Test List"

#Call the function to copy list items
Copy-ListItems -siteURL $SiteURL -SourceListName $SourceListName -TargetListName $TargetListName

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

#Load SharePoint CSOM Assemblies

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"

Function Copy-ListItems()

{

param

(

[Parameter(Mandatory=$true)] [string] $SiteURL,

[Parameter(Mandatory=$true)] [string] $SourceListName,

[Parameter(Mandatory=$true)] [string] $TargetListName

)

Try {

#Setup Credentials to connect

$Cred = Get-Credential

$Cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password)

#Setup the context

$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)

$Ctx.Credentials = $Cred

#Get the Source List and Target Lists

$SourceList = $Ctx.Web.Lists.GetByTitle($SourceListName)

$TargetList = $Ctx.Web.Lists.GetByTitle($TargetListName)

#Get All Items from Source List

$SourceListItems = $SourceList.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery())

$Ctx.Load($SourceListItems)

$Ctx.ExecuteQuery()

#Get All fields from Source List & Target List

$SourceListFields = $SourceList.Fields

$Ctx.Load($SourceListFields)

$TargetListFields = $TargetList.Fields

$Ctx.Load($TargetListFields)

$Ctx.ExecuteQuery()

#Get each column value from source list and add them to target

ForEach($SourceItem in $SourceListItems)

{

$NewItem =New-Object Microsoft.SharePoint.Client.ListItemCreationInformation

$ListItem = $TargetList.AddItem($NewItem)

#Map each field from source list to target list

Foreach($SourceField in $SourceListFields)

{

#Skip Read only, hidden fields, content type and attachments

If((-Not ($SourceField.ReadOnlyField)) -and (-Not ($SourceField.Hidden)) -and ($SourceField.InternalName -ne "ContentType") -and ($SourceField.InternalName -ne "Attachments") )

{

$TargetField = $TargetListFields | where { $_.Internalname -eq $SourceField.Internalname}

if($TargetField -ne $null)

{

#Copy column value from source to target

$ListItem[$TargetField.InternalName] = $SourceItem[$SourceField.InternalName]

}

$ListItem.update()

$Ctx.ExecuteQuery()

}

write-host -f Green "Total List Items Copied from '$SourceListName' to '$TargetListName' : $($SourceListItems.count)"

}

Catch {

write-host -f Red "Error Copying List Items!" $_.Exception.Message

}

#Set Parameters

$SiteURL= https://tenant.sharepoint.com/sites/DOCTEST1

$SourceListName="TESTLIST2222"

$TargetListName="Test List"

#Call the function to copy list items

Copy-ListItems -siteURL $SiteURL -SourceListName $SourceListName -TargetListName $TargetListName

Enjoy!

[CSOM] Create a specified number of list items using CSOM

August 18, 2022 Andrei Rachita 0

So the idea is to create a large number of list items (definable) using CSOM. So… here goes:

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"

#Config Parameters
$SiteURL=https://tenant.sharepoint.com/sites/DOCTEST1
$ListName="Test List"
$ItemsToCreate="2000"

Try {
    $Cred= Get-Credential
    $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)

   #Setup the context
    $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
    $Ctx.Credentials = $Credentials
        
    #Get the List
    $List = $Ctx.Web.Lists.GetByTitle($ListName)
    $Ctx.Load($List)
    $Ctx.ExecuteQuery()

    #add an item to list SharePoint Online PowerShell - with Random Data
    For($i=1; $i -le $ItemsToCreate; $i++)
    {
        #create list item in sharepoint online using powershell
        $ListItemInfo = New-Object Microsoft.SharePoint.Client.ListItemCreationInformation
        $ListItem = $List.AddItem($ListItemInfo)
        $ListItem["Title"] = $I
        $ListItem.Update()
        $Ctx.ExecuteQuery()

        Write-host "New Item $I Added to the List!" -ForegroundColor Green  
    }
}
Catch {
    write-host -f Red "Error Adding Items to List!" $_.Exception.Message
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

#Load SharePoint CSOM Assemblies

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.dll"

Add-Type -Path "C:\CSOM\Microsoft.SharePoint.Client.Runtime.dll"

#Config Parameters

$SiteURL=https://tenant.sharepoint.com/sites/DOCTEST1

$ListName="Test List"

$ItemsToCreate="2000"

Try {

$Cred= Get-Credential

$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)

#Setup the context

$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)

$Ctx.Credentials = $Credentials

#Get the List

$List = $Ctx.Web.Lists.GetByTitle($ListName)

$Ctx.Load($List)

$Ctx.ExecuteQuery()

#add an item to list SharePoint Online PowerShell - with Random Data

For($i=1; $i -le $ItemsToCreate; $i++)

{

#create list item in sharepoint online using powershell

$ListItemInfo = New-Object Microsoft.SharePoint.Client.ListItemCreationInformation

$ListItem = $List.AddItem($ListItemInfo)

$ListItem["Title"] = $I

$ListItem.Update()

$Ctx.ExecuteQuery()

Write-host "New Item $I Added to the List!" -ForegroundColor Green

}

Catch {

write-host -f Red "Error Adding Items to List!" $_.Exception.Message

}

Enjoy!

[MS Graph/SPO PowerShell] Pre-Provision OneDrive sites

August 3, 2022 Andrei Rachita 0

Since the Get-MSOLUser cmdet is going to be deprecated, (see: https://practical365.com/azure-ad-license-management-extension/), the pre-provisioning script for ODB sites (https://docs.microsoft.com/en-us/onedrive/pre-provision-accounts) will need to be re-written for Microsoft […]

[PowerShell/PNP] – Copy files and folders from one site collection to another using PnP PowerShell

July 28, 2022 Andrei Rachita 0

So, here goes:

Connect-PnPOnline -Url https://tenant.sharepoint.com/sites/ARACHITA1 -Interactive

$allItems = Get-PnPListItem -List "LibTestMulti" -FolderServerRelativeUrl "/sites/ARACHITA1/LibtestMulti/Folder1"


foreach ($item in $allItems) {
if ($item.FileSystemObjectType -eq "File") {
Write-Host "Copying file: $($item.FieldValues.FileLeafRef)" -ForegroundColor green
Copy-PnPFile -SourceUrl "$($item.FieldValues.FileRef)" -TargetUrl ("/sites/Calendar2405/doclib33/TEST") -Overwrite -Force
}
}

1

2

3

4

5

6

7

8

9

10

11

Connect-PnPOnline -Url https://tenant.sharepoint.com/sites/ARACHITA1 -Interactive

$allItems = Get-PnPListItem -List "LibTestMulti" -FolderServerRelativeUrl "/sites/ARACHITA1/LibtestMulti/Folder1"

foreach ($item in $allItems) {

if ($item.FileSystemObjectType -eq "File") {

Write-Host "Copying file: $($item.FieldValues.FileLeafRef)" -ForegroundColor green

Copy-PnPFile -SourceUrl "$($item.FieldValues.FileRef)" -TargetUrl ("/sites/Calendar2405/doclib33/TEST") -Overwrite -Force

}

So the script will copy the files from /sites/arachita1/LibtestMulti/Folder1 to /sites/Calendar2405/doclib33/Test Enjoy!