SharePoint Patterns & Practices – March 2018 update

Vesa Juvonen

SharePoint Dev Ecosystem / SharePoint Patterns and Practices (PnP) March 2018 update is out with a summary of the latest guidance, samples, and solutions from SharePoint engineering or from the community for the community. This article is a summary around all the different areas and topics around SharePoint Dev ecosystem during the past month.

What is SharePoint Patterns & Practices (PnP)?

SharePoint / Office Dev Patterns and Practices

SharePoint PnP is a nick-name for SharePoint Dev Ecosystem activities coordinated by SharePoint engineering. SharePoint PnP is community driven open source initiative where Microsoft and external community members are sharing their learning’s around implementation practices for SharePoint and Office 365. Active development and contributions happen in GitHub by providing contributions on the samples, reusable components, and documentation.

PnP is owned and coordinated by SharePoint engineering, but this is work done by the community for the community. The initiative is currently facilitated by Microsoft, but already at this point, we have multiple community members as part of the PnP Core team and we are looking to extend the Core team with more community members.

Notice that since this is open source community initiative, there’s no SLAs for the support for the samples provided through GitHub. Obviously, all officially released components and libraries are under official support from Microsoft. You can use SharePoint Developer group in the Microsoft Tech Community for providing input and to ask any questions about the existing materials.

Some key statistics around SharePoint Dev topics from February 2018

  • GitHub repository forks at most popular repositories in SharePoint GitHub organization
  • Unique visitors during past 2 weeks in SharePoint organization repositories – 35,427
  • Merged pull requests across SharePoint repositories (cumulative) – 4,573
  • Closed issues and enhancements ideas cross SharePoint repositories (cumulative) – 3,006
  • SharePoint Online CSOM NuGet package downloads (cumulative) – 411,619
  • PnP Core component NuGet package downloads (cumulative) – 166,719
  • Page views in SharePoint Dev pages at – 781,567
  • Unique tenants using PnP components – 9,765
  • Http requests towards SharePoint Online from PnP components (CSOM Core, PowerShell, PnP JS Core) – 8,834,249,239
  • SharePoint Dev YouTube channel had 25,326 views with 155,062 minutes watch time

Main resources around SharePoint PnP and SharePoint development

March 2018 monthly community call

Agenda for the Tuesday 13th of March 2018 SharePoint Dev Ecosystem / Patterns and Practices community call at 9 AM PST / 5 PM CEST (notice time change for PT due daylight savings):

  • Monthly summary of SharePoint Development topics – Engineering update and community news – Vesa Juvonen (Microsoft) ~15 min
  • Modern Team Sites Navigation Application Customizer – Alex Terentiev (SharePointalist) ~ 10-15 min
  • Applications Customizer Groups external links – Luis Máñez (ClearPeople) ~10-15 min
  • Bulk Groupify – Getting ready for upcoming Groupify capability – Bert Jansen (Microsoft) ~10-15 min
  • Q&A

Monthly community call will get recorded and release to PnP YouTube channel typically within 24 hours after the recording is ended. If you have any questions, comments or feedback, please participate in our discussions in the Microsoft Tech Community under SharePoint developer group.

SharePoint Dev Blog posts

Here are the latest blog posts and announcements around SharePoint development topics from

PnP Webcasts

We started new PnP Webcasts are typically 15-30 min long conversational webcasts around a specific topic. This series was started in October 2015 and have continued releasing new videos since. All new webcasts are released on PnP YouTube Channel. Here are the new webcasts released after the last monthly release. We are looking into continuing the releases of the webcast in the future using weekly or bi-weekly schedule depending on the topics to be covered.

General Dev, CSOM, PnP Core, PnP PowerShell SIG Bi-Weekly Call Special Interest Group (SIG)

General SP Dev, CSOM PnP Sites Core, PowerShell and Provisioning Special Interest Group (SIG) have bi-weekly meetings to cover the general SharePoint topics, CSOM and latest in the PnP CSOM core component, PnP PowerShell and in the PnP remote provisioning engine. These calls have also free Q&A section if you have any questions about SharePoint development in on-premises or in the cloud. Need to get a recommendation for your design or having a hard time with some APIs? – Drop by, ask a question and we’ll help you.

You can download invite for the bi-weekly meeting from the following location.

All SIG meetings are being recorded and are available for view from PnP YouTube Channel. Here are the latest recordings of the SIG calls.

  • 8th of March – SP Dev news with engineering update. Modern team site creation with a bot, flow and Azure Function. Preview on PnP PowerShell Core – update on CSOM Core plans.
  • 22nd of February – SP Dev news with engineering update. Full end-to-end demo on hub sites. Usage, administration and API support.
  • 8th of February – SP Dev news with engineering update. Demo on Async option with ExecuteQueryAsync. Demo on cross-platform PowerShell Core. SharePoint through Graph.

Interested in doing a community demo in these community calls? – Please let us know!

SharePoint Framework (SPFX) and JavaScript Special Interest Group (SIG)

SharePoint Framework and JavaScript Special Interest Group (SIG) has bi-weekly meetings to cover latest changes in the SharePoint Framework side, from the engineering perspective and to cover also latest development related to the PnP JS Core library. These calls are designed to have 50%/50% of content and demos and there has been already great community demos on the new SharePoint Framework Client-side web parts. If you’re interested in showing your code, just let us know.

All SharePoint Framework and JS SIG meetings are recorded, so that you can check the demos and discussions if you can’t make the actual call. You can find the latest recordings from the PnP YouTube Channel. Here are the latest recordings.

  • 1st of March – SharePoint Framework engineering update, PnP JS Core update, Office 365 CLI update, SPFx controls update – Live demos on React File Upload, Q&A Chatbot with SPFx application customizer and Offline First React
  • 15th of February – SharePoint Framework engineering update, PnP JS Core update, Office 365 CLI update, SPFx controls update – Live demos on modern page management with PnPJs and building react Slide Swiper Sample

Interested in doing a community demo in these community calls? – Please let us know!

SharePoint Dev Ecosystem in GitHub

There are quite a few different GitHub repositories under the SharePoint brand since we wanted to ensure that you can easily find and reuse what’s relevant to you. We do also combine multiple solutions to one repository so that you can more easily sync and get latest changes of our released guidance and samples.

  • PnP – Main repository for SP add-in, Microsoft Graph etc. samples
  • PnP-Guidance – Guidance, presentations, and articles which are partly synced to MSDN
  • PnP-Sites-Core – Office Dev PnP Core component
  • PnP-JS-Core – Office Dev PnP Core component for JavaScript
  • PnP-PowerShell – Office Dev PnP PowerShell Cmdlets
  • PnP-Tools – Tools and scripts targeted more for IT Pro’s and for on-premises for SP2013 and SP2016
  • PnP-Partner-Pack – Packaged guidance with detailed instructions on setting things up in Office 365 and in Azure.
  • PnP-Transformation – Material specifically for the transformation process. Currently, includes samples around InfoPath replacement and transformation tooling from farm solutions to add-in model.
  • PnP-Provisioning-Templates – Source for templates available from PnP Template Gallery at
  • PnP-Provisioning-Schema – PnP Provisioning engine schema repository
  • PnP-IdentityModel – Open source replacement of Microsoft.IdentityModel.Extensions.dll

What’s supportability story around PnP material?

Following statements apply across all of the PnP samples and solutions, including samples, core component(s) and solutions, like PnP Partner Pack.

  • PnP guidance and samples are created by Microsoft & by the Community
  • PnP guidance and samples are maintained by Microsoft & community
  • PnP uses supported and recommended techniques
  • PnP implementations are reviewed and approved by Microsoft engineering
  • PnP is open source initiative by the community – people who work on the initiative for the benefit of others, have their normal day job as well
  • PnP is NOT a product and therefore it’s not supported by Premier Support or other official support channels
  • PnP is supported in similar ways as other open source projects done by Microsoft with support from the community by the community
  • There are numerous partners that utilize PnP within their solutions for customers. Support for this is provided by the Partner. When PnP material is used in deployments, we recommend being clear with your customer/deployment owner on the support model

Latest changes

SharePoint Framework samples

These are samples which are available from the SharePoint client-side web part sample repository at or from the SharePoint Framework Extensions repository at

Reusable open source controls for SharePoint Framework

New reusable controls initiative was announced in Ignite 2017 during September. There are two new npm packages and source code repositories for the reusable controls which you can use in your SharePoint Framework solutions. We do welcome community contributions to these initiatives as well. There are two different repositories: sp-dev-fx-property-controls and sp-dev-fx-controls-react. Here are the changes on these repositories.

New controls

  • PropertyFieldMultiSelect got added
  • PropertyFieldNumber got added


  • Optimized telemetry so that it only pushes control data
  • PropertyFieldTermPicker newly introduced property to specify to show or hide the term store name: hideTermStoreName.
  • PropertyFieldTermPicker an updated process when terms were unselected based on ID instead of the path.


  • Fixes for label rendering issue #30
  • Fix for people picker validation issue #33

Community column formatting definitions

SharePoint Columns Formatting capability was released for First Release customers during October 2017. As part of the availability, we also announced the availability of open source repository for sharing different column formatting definitions. Following lists the changes in the column formatting area.

  • No new column formatting samples during February

Office 365 CLI

Office 365 CLI was released in November 2017. This is an open source tool which enables you to controls tenant level properties in SharePoint Online or in Office 365 without the need of using PowerShell. SharePoint Online Management Shell is only available for Windows operating system.

v1.0.0 release available with following changes


PnP CSOM Core and Provisioning Engine

PnP CSOM Core component is a wrapper on top of native SharePoint CSOM and REST API, which simplifies complex scenarios with remote APIs, one of the example is the PnP Provisioning Engine for remote templates. The first version of the PnP remote provisioning engine was released with the May 2015 release. This list contains the main updates in this release:


  • Added ExecuteQueryRetryAsync method [baywet and SharePointRadi]
  • Added EnsureLabel extension method to the taxonomy extensions [paulpascha]
  • Added SetDefaultContentType extension methods on List objects. Notice that this method behaves differently from the deprecated SetDefaultContentTypeToList method. See the Deprecated section.
  • Added AliasExistsAsync extension method to verify if an Office 365 Group alias is available for use
  • Added support for taxonomy fields in DataRows at the provisioning engine level. [jensotto]
  • Added support for updating owners and members of an Office 365 Group.
  • Added support for TermStore DefaultLanguage when retrieving or adding a term. [stevebeauge]
  • Added support for getting apps by title [gautamdsheth]
  • Added .NET 2.0 Standard project to allow cross-platform use of the PnP Sites Core library


  • Improved test reliability by scoping out tests that should not execute during app-only test runs
  • Correctly set the lookup list for fields of type User [pschaeflein]
  • Don’t tokenize ~sitecollection in web parts XML [paulpascha]
  • Updated base templates for March 2018 release
  • Fix #1585 – Correctly handle Overwrite=false with the new pre-create of pages
  • TimerJob framework reliability improvements (avoid breaking when client context could not be obtained)
  • Fix #1595 – Fixed provisioning issue when the AppCatalog is missing. [gautamdsheth]
  • Updated DataRow handler in provisioning engine to not update read-only fields, and to allow for emptying fields by leaving the element value empty of a DataValue element.
  • Support extraction of “empty” client-side pages when using an extensibility provider that extracts more than the default home page
  • Improved detection of illegal characters in folder and file names [aslanovsergey]
  • Fix #1509 – Role inheritance can be broken when site security is specified with BreakRoleInheritance set to true without additional RoleAssignments specified [paulpascha]
  • Commenting can be enabled/disabled on home page via the ClientSidePages object handler
  • RoleDefinitions are now parsed in the SiteSecurity object handler
  • WebHook provisioning errors will not stop the provisioning process
  • Improved list content type handling [jensotto]
  • Exclude ComposedLook handler processing for NoScript sites
  • Improved detection of App-Only to support web login based use
  • SiteName and SiteTitle token updates [jensotto]
  • Fix #1059 – SharePoint 2013 on-premises issues with ApplyProvisioningTemplate when publishing activated
  • Switched to CSOM version 7414.1200
  • Groupify method supports the “keep existing homepage” scenario
  • Fixed behavior while adding/updating data rows with the Provisioning Engine [craig-blowfield]


  • Marked SetDefaultContentTypeToList extensions methods on List and Web objects as deprecated. This method has some flaws. It was possible to use the ID of a content type at site level to set as a default content type in the list, IF a content type in that list was inheriting from the parent content type. The new method requires you to specify the actual content type that is associated with the list. It will not work to specify a parent content type id.

See also for day-to-day results and executed tests.

PnP JavaScript Core Library

Latest update is version 1.0.3 on the PnPJs library. Here’s are the latest changes since the previous monthly release.


  • @pnp/sp: Support for backward navigation in item paging skip method [PR]
  • @pnp/sp: Support for % and # character in files and folders with the ResourcePath API [PR]
  • @pnp/sp: Support for social follow API (_api/social.following) [PR] [Docs]
  • @pnp/sp: commentsDisabled property to ClientSidePage class [PR] [Docs]
  • @pnp/sp: Support for finding controls to ClientSidePage class [PR] [Docs]
  • @pnp/sp: Export ContentTypes and RegionalSettings related classes (@allanhvam) [PR]
  • @pnp/sp: Support for managing client-side pages [PR]
  • @pnp/sp: getAll method on Items collection [PR]
  • @pnp/sp: addUser, addLookup, addChoice, addMultiChoice, and addBoolean on Fields collection [PR]
  • @pnp/sp: getClientSideWebParts method on Web [PR]
  • tooling: updates to test gulp task to support –s and –site parameters [PR]


  • @pnp/sp: Issue with File.setContentChunked and Files.addChunked in odata=verbose mode [PR]
  • @pnp/sp: Issue with clone and configure [PR]
  • @pnp/graph: Issue clone and configure [PR]
  • @pnp/sp: Issue with adding client-side webparts with ids with {} chars [PR]
  • @pnp/sp: Issue with adding client-side webparts and setting order values [PR]
  • Removed gulp-util in favor of individual libraries per guidance [PR]

This is a similar effort as what PnP initiative previously has done with the PnP CSOM Core Component together with the community.

PnP PowerShell

PnP PowerShell providers more than three hundred additional PowerShell cmdlets, which can be used to manipulate content in SharePoint Online and in on-premises (SP2013, SP2016). These cmdlets are additive for SharePoint Online management shell, which concentrate more on the administrative tasks with SharePoint Online.

Here are the latest changes in the PnP PowerShell


  • Added Get-PnPTenant cmdlet
  • Added Set-PnPTenant cmdlet
  • Added Set-PnPWebTheme cmdlet
  • Added Invoke-PnPSiteDesign cmdlet
  • Added Read-PnPProvisioningTemplate cmdlet [Rename: see deprecated section]
  • Added Invoke-PnPQuery cmdlet [Rename: see deprecated section]
  • Added Resolve-PnPFolder cmdlet [Rename: see deprecated section]
  • Added New-PnPAzureCertificate cmdlet
  • Added Get-PnPAzureCertificate cmdlet
  • Added Test-PnPOffice365GroupAliasIsUsed cmdlet
  • Added Remove-PnPStoredCredential
  • Added Add-PnPStoredCredential
  • Added Get-PnPHubSite cmdlet
  • Added Set-PnPHubSite cmdlet
  • Added Grant-PnPHubSiteRights cmdlet
  • Added Register-PnPHubSite cmdlet
  • Added Unregister-PnPHubSite cmdlet
  • Added Connect-PnPHubSite cmdlet
  • Added Disconnect-PnPHubSite cmdlet
  • Added Add-PnPTenantTheme cmdlet
  • Added Get-PnPTenantTheme cmdlet
  • Added Remove-PnPTenantTheme cmdlet
  • Added Set-PnPTenantCdnEnabled cmdlet
  • Added Get-PnPTenantCdnEnabled cmdlet
  • Added Get-PnPTenantCdnOrigin cmdlet
  • Added Add-PnPTenantCdnOrigin cmdlet
  • Added Remove-PnPTenantCdnOrigin cmdlet
  • Added Get-PnPTenantCdnPolicies cmdlet
  • Added Set-PnPTenantCdnPolicy cmdlet
  • Added Add-PnPSiteCollectionAppCatalog cmdlet
  • Added Remove-PnPSiteCollectionAppCatalog cmdlet
  • Added Get-PnPNavigationNode cmdlet
  • Added Get-PnPRoleDefinition cmdlet
  • Added Add-PnPRoleDefinition cmdlet
  • Added Remove-PnPRoleDefinition cmdlet
  • Implemented .NET 2.0 Standard project to allow for cross-platform use with PowerShell 6.0


  • Added “Formula” dynamic parameter to Add-PnPField to allow creating calculated fields.
  • Updated Set-PnPClientSidePage to support setting the page title
  • Added -Graph [and -LaunchBrowser] option to authenticate with Connect-PnPOnline to the Graph using the PnP O365 Management Shell Azure AD Application
  • Updated the UnifiedGroup cmdlets to also take an Alias of a group as a value for the -Identity parameter
  • Minor documentation updates [thechriskent]
  • Updated Connect-PnPOnline to support connecting using PEM encoded certificate strings
  • Updated Connect-PnPOnline for On-Premises to allow for additional HighTrustCertificate parameters [fowl2]
  • Added -EnableAttachment parameter for Set-PnPList [Laskewitz]
  • Added -Approve parameter for Set-PnPFileCheckedIn [Aproxmiation]
  • Added -EnableModeration for Set-PnPList [Apromixation]
  • Fixed issue where it was not possible to use New-PnPSite when using Connect-PnPOnline with the -UseWebLogin parameter
  • Fixed issue with Copy-PnPFile when copying to a location within the current web where metadata was not being retained
  • Fixed issue with Add-PnPFile when a new file was uploaded and using the cmdlet also field values where set, the version would increase to 2.0 instead of the expected 1.0
  • Fixed issues with Set-PnPTheme cmdlet not accepting site relative urls
  • Move-PnPFolder now returns the folder that has been moved
  • Updated Get-PnPStoredCredentials to support .NET Standard
  • Updated/fixed documentation on various cmdlets
  • Fixed issue with Get-PnPTenantSite not returning all sites in large tenants
  • Added -PnPO365ManagementShell [and -LaunchBrowser] login option to Connect-PnPOnline
  • Changed changelog format
  • Updated Remove-PnPNavigationNode cmdlet to support removal by Id
  • Updated Remove-PnPNavigationNode cmdlet to support the -All parameter
  • Updated Set-PnPList cmdlet to change moderation setting
  • Updated Set-PnPFileCheckedIn to approve the file


  • [SharePoint Online Only] Deprecated Get-PnPAppInstance, Import-PnPAppPackage, Uninstall-PnPAppPackage. Use Add-PnPApp, Install-PnPApp, Publish-PnPApp, Uninstall-PnPApp, Remove-PnPApp instead where applicable.
  • Deprecated Load-PnPProvisioningTemplate, renaming it to Read-PnPProvisioningTemplate which follows the PowerShell approved verb standard. Load-PnPProvisioningTemplate has been added as an alias for Read-PnPProvisioningTemplate.
  • Deprecated Execute-PnPQuery, renaming it to Invoke-PnPQuery which follows the PowerShell approved verb standard. Execute-PnPQuery has been added as an alias for Invoke-PnPQuery.
  • Deprecated Ensure-PnPFolder, moving functionality to Resolve-PnPFolder which follows the PowerShell approved verb standard. Ensure-PnPFolder has been added as an alias for Resolve-PnPFolder.
  • Documentation/Markdown generation has been removed from the build, now points to
  • Deprecated Remove-PnPNavigationNode -Title and -Header parameters. Use the Identity parameter instead.
  • Marked -WebTemplate parameter on Get-PnPTenantSite as obsolete. Use -Template instead.
  • Deprecated Get-PnPAzureADManifestKeyCredentials. Use Get-PnPAzureCertificate instead.


PnP sample library

Here are updates across the PnP code sample library by the community on the code and documentation, which is a great way to contribute as well.

  • New sample O365.Modern.Provisioning demonstrating how to integrate a typical enterprise scenario where the user can submit a creation’s request for a new SharePoint team site, communication site or a Microsoft team
  • New sample MultiGeo.TenantInformationCollectionCSOM showing how to use CSOM to get geolocation details for a multi-geo tenant
  • New sample Provisioning.Extensibility.Pages which is an extensibility handler that exports all client-side pages of a site
  • Updates to Business.StarterIntranet solution sample, which is a generic, enterprise intranet publishing solution, compatible with SharePoint 2013, 2016 and SharePoint Online.

SharePoint Dev articles

SharePoint Dev articles are surfaced currently in ´Since the last release, we have now merged also SharePoint PnP Solution guidance to platform, so you’ll only have one location to follow all relevant SharePoint Dev documentation and guidance. You can provide contributions to these documents by submitting documentation improvements using GitHub tooling. All of the SharePoint Dev docs are stored and surfaced from the sp-dev-docs repository.

Here are new/updated articles on the SharePoint Development.

PnP Guidance videos

You can find all SharePoint Dev videos on our YouTube Channel at This location contains already a significant amount of detailed training material, demo videos, and community call recordings.

Key contributors to the March 2018 update

Here’s the list of active contributors (in alphabetical order) since last release details in SharePoint Dev repositories or community channels. PnP is really about building tooling and knowledge together with the community for the community, so your contributions are highly valued across the Office 365 customers, partners and obviously also at Microsoft.

Thank you for your assistance and contributions on the behalf of the community. You are making a difference!

Companies: Here’s the companies, which provided support for PnP initiative for this month by allowing their employees working for the benefit of others in the PnP initiative. There were also people who contributed from other companies during last month, but we did not get their logos and approval to show them in time for these communications. If you still want your logo for this month’s release, please let us know and share the logo with us. Thx.

Arvo Systems
Content and Code
 onebit software
 Rapid Circle
 Sii Technologies
 Stefan Bauer
 Storm Technology

Microsoft people: Here’s the list of Microsoft people who have been closely involved with the PnP work during last month.

Next steps

  • March 2018 monthly community call is on Tuesday 13th of February at 8 AM PT / 5 PM CEST / 4 PM GMT for latest release details with demos – Download recurrent invite to monthly community call with a detailed schedule for your time zone from

PnP Resources in one picture - numerous links mentioned in this blog post

“Sharing is caring”

Vesa Juvonen, Senior Program Manager, SharePoint, Microsoft – 12th of March 2018

Feedback usabilla icon