DEV Community: Tony Watters

How to make SharePoint column fields readOnly / Hidden with PnP PowerShell

Tony Watters — Fri, 01 Jun 2018 14:48:27 +0000


Param(
    $tenantUrl = "https://YOURSITE.sharepoint.com",
    $spCredential = (Get-Credential),
)

$sites = @("siteOne", "SiteTwo")

foreach($name in $sites) {

    Connect-PnPOnline -Url $tenantUrl/sites/$name -Credentials $spCredential

    #Field Guids

    $Summary = Get-PnPField -Identity 98e1ecf3-3ae3-44a4-820c-f1de12ff346a
    $Country = Get-PnPField -Identity 7d9fd33a-e726-4d7f-b3ed-60e1c8e9690d
    $Location = Get-PnPField -Identity 0d2db348-a438-48f2-bcd2-461acd6f149f
    $Language = Get-PnPField -Identity 81b712c3-a41f-4e65-9a3a-8e7110bd9b5e
    $Topic = Get-PnPField -Identity 5f9fd169-0cf6-4779-a6be-e4635327c9a8

    $columns = $Summary, 
               $Country,
               $Location, 
               $Language, 
               $Topic


    foreach ($column in $columns) {

        try{
            $column.ReadOnlyField = $true
            $Column.SetShowInEditForm($false)
            $column.UpdateAndPushChanges($true)
            $column.Context.ExecuteQuery();
        }
        catch{
            Write-Host "error" $columns
        }
    }
    Write-Host "finished updating read Only fields in" $name
}

PnP PowerShell adding navigation links

Tony Watters — Tue, 01 May 2018 09:20:34 +0000

How to add a Navigation link with child links to numerous sites with PnP PowerShell

$tenantUrl = "https://YOURTENENT.sharepoint.com/"

$cred = Get-Credential

$sites = "Site1", "Site2", "Site3", "Site4"

foreach($name in $sites) {  

    Connect-PnPOnline -Url "$tenantUrl/sites/$name/SitePages/" -Credentials $cred

    Add-PnPNavigationNode -Title "Parent Link" -Url "$tenantUrl/sites/mysite/SitePages/somesite1.aspx" -Location "QuickLaunch"
    Add-PnPNavigationNode -Title "Child one" -Url "$tenantUrl/sites/mysite/SitePages/somesite2.aspx" -Location "QuickLaunch" -Header "Parent Link" 
    Add-PnPNavigationNode -Title "Child two" -Url "$tenantUrl/sites/mysite/SitePages/somesite3.aspx" -Location "QuickLaunch" -Header "Parent Link" 
    Add-PnPNavigationNode -Title "Child three" -Url "$tenantUrl/sites/mysite/SitePages/somesite4.aspx" -Location "QuickLaunch" -Header "Parent Link" 
    Add-PnPNavigationNode -Title "Child four" -Url "$tenantUrl/sites/mysite/SitePages/somesite5.aspx" -Location "QuickLaunch" -Header "Parent Link" 
}

Checkout these excellent PowerShell resources

My good friend Velin Georgiev blog is an excellent resource on all things SharePoint
https://blog.velingeorgiev.com/provision-custom-list-sharepoint-pnp-powershell

Also found this great Cheat sheet
http://compari.tech/powershell

How to export xml scripts from SharePoint Online with PnP PowerShell

Tony Watters — Mon, 30 Apr 2018 10:40:32 +0000

Exporting xml script from SharePoint

First create new folder mkdir i.e. demo to house your exported xml.

Next connect to your SharePoint Online site

Connect-PnPOnline -url https://yourtenent.sharepoint.com/sites/mysite

then run the following command to retrieve the pages xml

Get-PnPProvisioningTemplate -out C:\demo\articles.xml

Navigate to view newly created xml file via command

explorer C:\demo\article_xml

when you have updated your xml to your specifications run the following command to apply the edited xml to your selected site i.e. mysite

Apply-PnPProvisioningTemplate -Path C:\demo\articles_xml\

How to change menu items within SharePoint Online with PnP PowerShell

Tony Watters — Mon, 30 Apr 2018 09:40:01 +0000

Introduction

Changing menu navigation items within SharePoint sites is a tedious manual step, it can take a long time to update the menu items throughout numerous sites. This is where PnP PowerShell comes in to make your work/life easy.

This tutorial will show you how to remove/add a new menu item to multiple SharePoint sites using the power of PnP PowerShell cmdlets.

PnP Powershell Overview

SharePoint Patterns and Practices (PnP) contains a library of PowerShell commands (PnP PowerShell) that allows you to perform complex provisioning and artifact management actions towards SharePoint. The commands use CSOM and can work against both SharePoint Online as SharePoint On-Premises.
https://github.com/SharePoint/PnP-PowerShell/blob/master/Documentation/readme.md

The fun begins

First, we need to connect to the tenant of your current web

$tenantUrl = "https://xxx.sharepoint.com/"

Next, we will get your sign in credentials with Get-Credential

$cred = Get-Credential

In the next line of code, we will put our site page names with in an array called $sites

$sites = "volvo", "ford", "opel", "lada",

Then we will create a for each loop that will create a variable called $name to loop through the array of $sites

foreach($name in $sites) {

Here is where the nuts and bolts of the SharePoint PnP PowerShell come in.
We connect to the PnPOnline and add our -Url with our previously created variable $tenantUrl then concat the previously created $name variable to sites/$name then our Get-Credentials $Cred variable which logs us in to the SharePoint Online.

Connect-PnPOnline -Url $tenantUrl/sites/$name -Credentials $cred

We then loop through all the sites Navigation Nodes and find a “-Title” called "My old Cars" and remove it from the all the $sites Navigations entirely.

Remove-PnPNavigationNode -Location QuickLaunch -Title "My old Cars" -Force

Next, we can add our new Navigation Page link called “My New Cars” to our navigation menu. We find the location Quicklaunch then add a new -Title called "My New Cars" with the specific -Url.

Add-PnPNavigationNode -Location QuickLaunch -Title “My New Cars” -Url 'SitePages/MyNewCars.aspx'
}

After running you will see that the old link has been removed and a new link node has been added to your navigations.

See full code below.

$tenantUrl = https://YOURSITE.sharepoint.com 
$cred = Get-Credential 
$sites = "volvo", "ford", "opel", "lada", 
foreach($name in $sites) {

    Connect-PnPOnline -Url $tenantUrl/sites/mycar-$name -Credentials $cred 
    Remove-PnPNavigationNode -Location QuickLaunch -Title "My old Cars" -Force 
    Add-PnPNavigationNode -Location QuickLaunch -Title “My New Cars” -Url 'SitePages/MyNewCars.aspx' 
}

Hope this helps any aspiring PowerShell ninjas out there :)