How to fix PowerShell not being found in Visual Studio on Mac

Getting PowerShell to run on a Mac is quite easy these days. Still you might run into issues when trying to use PowerShell not only in the default Terminal app but instead in a tool such as Visual Studio Code. This article shows how to fix an issue that causes Visual Studio Code showing error Unable to find PowerShell.

How to use SharePoint Pages and WebParts in your OneDrive

As we anticipate the next generation of OneDrive, it’s essential to remember that the current version also boasts a variety of hidden features that can be activated with just a few clicks. Have you considered creating your own personal intranet within OneDrive by incorporating SharePoint pages and web parts? Explore the possibilities!

Create a RACI matrix using SharePoint

This article demonstrates how to create a Responsibility assignment matrix using SharePoint.

Remove SharePoint document sharing using SharePoint REST API

SharePoint offers the ability to share files to specific users. This feature is different from directly settings permissions for the item. This article explains how to remove the sharings using SharePoint REST API.

SharePoint Search Query Tool: InformationProtectionLabelId missing

The SearchQueryTool is an open source tool which helps to execute Search queries for SharePoint. This article explains how to find the special property InformationProtectionLabelId.

SharePoint search: Use the RefinementFilter property to avoid the 4096 characters limit of SharePoint search queries

Even after 5 years of SharePoint and O365 development I sometimes stumble across endpoints I did not know about. Quite often those endpoints are quite helpful.

In this case it was the  RefinementFilter property that can be added to SharePoint Search calls. Using this property you can ignore the query length limit of 4096 characters. This can be super helpful when querying huge collections of items.

The ultimate Guide for storing user settings in O365

There are many different ways for storing user settings in O365. This article should help choosing the best methods for your use cases.

CSOM: Set primary set collection admin

When creating modern site collections (e.g. sites with STS#3 Base Template) in SharePoint Online using CSOM the creator of the site will be automatically set as site owner and afterwards becomes site collection administrator afterwards.

To prevent this you have to change to primary site admin, remove old admin user from the site collection admins. This can be done in CSOM using the following logic.

SharePoint Online: Check in Javascript if the tenant is multi geo enabled

SharePoint Multi Geo tenant features have been enabled for some time. Users can switch between the different geo location. Using Javascript it is possible to check if the tenant is multi geo enabled.

PowerShell: SharePoint Online Authentication using AzureAd App certificate

Using azure ad apps it is possible to login to SharePoint Online using a certificate. This certificate could be loaded locally or from Azure Key Vault. The following method shows how to connect to SPO using an azure key vault certificate in memory.

You need to install PNP Online PowerShell and Azure PowerShell modules to enable to commands used in this scripts.