Laurent Schoenaers

SharePoint Online document library default metadata values

In SharePoint Online, for a list or document library, it is possible to define default metadata values based on the folder where an item or document is added.

As with a lot of cases in SharePoint, the defaults are set on subfolders with inheritance. On every folder-level it is possible to break the inheritance and define other default values for your metadata.

In the example below we work with a Managed Metadata field, called customer, we need to default. This way our co-workers don’t need to specify the value everytime they create or upload a document to the document library.

There are two ways to make the magic happen. Through the user interface, and with Powershell.

Get a direct link to a document in Modern Libraries

31 October 2017 / Laurent Schoenaers / 0 Comments

With the Modern Libraries in SharePoint Online, getting a direct link – with a readable path – is not as straight forward as it was with the Classic Libraries. While the option is not there right before you, it is still possible to obtain such a link. In fact, there are even two.

Change the Office 365 language for synced users

26 August 2017 / Laurent Schoenaers / 0 Comments

In Office 365, every user can change their preferred language through the Office 365 settings.

Except when you are a synced user.

For synced users (your on-premise AD account is synced to Office 365), the language set in the on-premise AD will be used in Office 365 as well. With no way to change the language in Office 365.

Even if you would want to force it with PowerShell, you would get an exception.

Sharegate bulk incremental update

23 August 2017 / Laurent Schoenaers / 0 Comments

In Sharegate, having the full license (!), it is possible to run PowerShell scripts. In this script we could read a CSV-file to bulk migrate document libraries, lists or sites.

This can speed up the migration time, since you would only need to specify the objects once in a simple CSV-file instead of manually going through every object one by one, which is very time consuming.

In this example, we will perform a bulk incremental update (only copy the item if it is newer in the source than the corresponding item at the destination) of some document libraries from an on premise environment to different Site Collections in SharePoint Online.

The reports can be found in Sharegate as well, through the “Migration reports” button in the Ribbon.

Windows 10 Creators Update: Slow wireless connection

11 August 2017 / Laurent Schoenaers / 0 Comments

An upgrade to Windows 10 Creator made my wifi-connection very slow. From 60mbps to barely 50kbps, but on my phone I still experienced the maximum speed.

For me the solution was to disable “Receive Segment Coalescing” (RSC), described by Steven Van de Craen:
http://www.sharepointblogs.be/blogs/vandest/archive/2017/05/08/windows-10-creators-update-slow-wireless-connection.aspx

Steps:

Run an elevated PowerShell prompt
Get-NetAdapterRsc to show the status per adapter
Disable-NetAdapterRsc –Name “your_wifi_adapter_name” to disable

SharePoint Online lock/unlock your site

26 July 2017 / Laurent Schoenaers / 0 Comments

In some scenarios it is required to put a site in read only-mode, for example a project site, or to simply just remove access to it.

From the SharePoint Online Admin Center there is no way to lock your site, or to put it in read-only. There are two ways to achieve this, one is through Powershell, the other one through the Site Settings of your Site Collection.

Get all checked out documents in a SharePoint Site Collection, and check them in

13 July 2017 / Laurent Schoenaers / 0 Comments

A customer of mine had the need to get an overview of all the checked out documents for a given Site Collection, and to check them in afterwards prior to a content migration from SharePoint 2013 to SharePoint Online.

Since no out of the box features exist to accomplish this goal, I had to write a Powershell-script to find all the checked out documents in a Site Collection.

You can find the script here. It works for SharePoint Online as for SharePoint 2013. I did not test it with SharePoint 2010.

Embedding external content in an Office 365 Group / SharePoint Online site

8 June 2017 / Laurent Schoenaers / 0 Comments

Recently I had the requirement to embed an external website onto a modern page on a SharePoint Online site. Fine, that’s no problem at all. This is available out-of-the-box on a modern page, right?

Microsoft Teams has no document management features – no problem

30 May 2017 / Laurent Schoenaers / 0 Comments

While Microsoft has been promoting the usage of metadata and views above folders in SharePoint document libraries, Microsoft Teams lacks these possibilities. It gives you a full list of documents in that document library, but with no metadata, no views and no filtering.

Introduction to SharePoint Framework

25 February 2017 / Laurent Schoenaers / 0 Comments

As technology is evolving into a more and more client-side experience, JavaScript is becoming a substantial part in SharePoint implementations. With JavaScript you can build rich, fast, interactive user experiences on the client with responsive interfaces that run in browsers as well as a hybrid, native HTML experience on phones.

SharePoint fully embraces this trend, and has released the SharePoint Framework (SPFx). A Page and Part model that enables fully supported client-side development, easy integration with the Microsoft Graph and support for open source tooling. The new experiences for the new mobile app, SharePoint Online and OneDrive for Business, including the new document library and list experiences are built using the SharePoint Framework.