Create list from custom template in SharePoint with PowerShell

This examples shows how to create new lists from custom list templates in SharePoint using PowerShell and CSOM. Custom list templates are STP-files uploaded to the List Template Gallery on the site. This should work both on-premises (2013/2016) and Online (Office 365). https://gist.github.com/aflyen/da04a090cae03ae4db58589fe2246716 Note: This example uses commands from the Office Dev PnP PowerShell library, ex. "Connect-PnPContext". I … Continue reading Create list from custom template in SharePoint with PowerShell

Enable ratings in SharePoint with PowerShell and CSOM

In document libraries it is possible to enable ratings, both likes and average score (1-5). In this article I will cover how to enable "Likes" on the Pages library in a publishing site. When configuring libraries manually, this is enabled from the "Rating settings" in the library: But when we follow the remote provisioning pattern to create new … Continue reading Enable ratings in SharePoint with PowerShell and CSOM

Add AD security group as Site Collection administrator with PowerShell in SharePoint

In provisioning solutions it can be a good practice to add a security group from Active Directory as an additional site collection owner. Unfortunately a security group is not accepted as either primary or secondary owner. So to set a group as site collection administrator, the easiest approach I could find was to set the "IsSiteAdmin" … Continue reading Add AD security group as Site Collection administrator with PowerShell in SharePoint

Enabling scheduling on Publishing Pages in SharePoint Online (Office 365) using CSOM and PowerShell

Scheduling is easily enabled through the web interface when configuring the "Pages" library, but when deploying solutions using PowerShell, this must be automated as part of the configuration. Unfortunately, as many other sources also state, this is not directly supported in the Client Side API (CSOM). The solution is to manually set up the Pages … Continue reading Enabling scheduling on Publishing Pages in SharePoint Online (Office 365) using CSOM and PowerShell

Exporting XsltListViewWebPart in SharePoint 2013

By default the XsltListViewWebPart does not support export from the web user interface. I often build solutions by configuring the web parts in the browers, exporting and adjusting the defintions and then deploying them with PowerShell. With a few lines of PowerShell this capability can also be enabled for the Xslt List View Web Part. Before enabling the … Continue reading Exporting XsltListViewWebPart in SharePoint 2013

Unable to search for pages in SharePoint Online when using Managed Navigation

This is a summary of an issue we have had with publishing pages not being indexed, and then unable to build the search-driven pages we wanted using for example Content Search Web Part. This occured in SharePoint Online (Office 365) and we have only had this issue with a couple of tenants. So my guess … Continue reading Unable to search for pages in SharePoint Online when using Managed Navigation

Using BCS from PowerShell with SharePoint 2013

Running data migrations with SharePoint 2013 often involves using BCS and PowerShell if you don't have and third party tools at hand. This can be a bit tricky to set up, but once you are familiar the the BCS configuration, the PowerShell scripts are mostly straight forward. From my experience there are a few differences … Continue reading Using BCS from PowerShell with SharePoint 2013

Setting up a development environment for Office 365 and SharePoint Online

As we more and more evolve from working exclusively with SharePoint on-premises with our complex local SharePoint farm rigged with several virtual machines eating up our highly spec'd laptop, the new way of working with SharePoint in-cloud offers a more attractive setup for us developers. My background before starting with SharePoint, as for most others, … Continue reading Setting up a development environment for Office 365 and SharePoint Online

Error: There is a compatibility range mismatch between the Web server and database

There is a compatibility range mismatch between the Web server and database "SP2013_Content_InsertDatabaseNameHere", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to … Continue reading Error: There is a compatibility range mismatch between the Web server and database