Poo in Poo out

I have seen a very nice graphic which shows in one picture the necessity of data hygiene when using Copilot.

I'm sure you've come across this image in one or other presentation. Unfortunately, I have not yet been able to find a version without a cluttering background or other image elements. I have therefore created my own version and am making it now available. Have fun with it at your next presentation.

Many thanks to Matt Wade who had the initial idea for this illustration.

Setting SharePoint View properties with the PnP-Framework

The PnP-Framework has made a lot of task easier when taking care of a SharePoint environment. However, the documentation is still… ehem, let’s say developer friendly. In this article I’ll take a look at the Set-PnPView cmdlet and what values can be configured and why.

Session I held at the Ignite 2018

Since we, in the company I work for, have rolled out 65,000 Office 365 licenses and are one of the most successful companies ever with Yammer and Teams, I had the great luck this year to be invited by Microsoft as a speaker to the Ignite 2018 in Orlando. Together with my colleague we held a total of 3 sessions and were interviewed in a podcast.

In the meantime the sessions are available on YouTube. The links to the videos can be found here:

Find out how one of the biggest retailers in Europe is using Microsoft Teams - BRK2366

With approximately 48,000 frontline workers spread across 5,000 stores around Europe, dm drogerie's employees communicate with each other by smartphone and Microsoft Teams. The introduction of modern communications tools based on Office 365 has led to a productivity increase felt by every employee and ultimately by our customers. We describe how we encouraged adoption by taking away the fears of colleagues who weren’t IT-affine and showing them the value to be gained from the new tools. Across the entire company, communications skills, team and project work has been taken to a new level. We tell the success story from the first pilot through the tsunami of demand to the roll out in production.

Build your communities using SharePoint and Yammer - BRK2076

Learn how SharePoint and Yammer bring together modern content and conversations to deliver a best-in-class community solution. Understand what's new and coming next for building communities across your organization using Microsoft 365. Leaders from Rolls Royce and DM share how to champion a community approach to business challenges for accelerated business transformation. Learn how you can empower community leaders to support a strategic approach to community management.

Success with Teams Customer Panel – Best practices for large scale enterprise - BRK2189

Learn from key customers about how they are moving to Microsoft Teams. This session includes real world guidance for planning, delivering, managing and driving adoption of Microsoft Teams at scale.

The Office 365 Secure Score

Keeping track how secure your Office 365 tenant is can be a bit of a hassle. To make it easier for you, Microsoft created the Office 365 Secure Score.

In this 4-minute overview of Office 365 Secure Score, you will learn about a new tool that helps you to automatically assess the security posture of your Office 365 accounts, data, and devices. You'll discover the security features and best practices available to you to implement based on your overall security and productivity goals.

Code Snippet: Load the SharePoint Office PnP Module in PowerShell

How do you load the PowerShell OfficeP PnP module for SharePoint?

Addendum: I've added a try/catch block to the code. This way you can be sure the module is loaded.

# Loading Office Online PnP Module
try {
    if((Get-Module "Microsoft.Online.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) {
        Import-Module Microsoft.Online.SharePoint.PowerShell
        Write-Host "PowerShell module Microsoft.Online.SharePoint.PowerShell initialized"
    }
    else {
        Write-Host "PowerShell module Microsoft.Online.SharePoint.PowerShell loaded"
    }
}
catch {
    throw "PowerShell module Microsoft.Online.SharePoint.PowerShell initialization failed"
    exit 3
}

Connect to Office365 via Office PnP behind a proxy

How do you connect to your SharePoint Office365 tenant with the PowerShell if you are locked behind a proxy? This hint will probably work for all kind of PowerShell scripts, not only for Office PnP. I tried this with the Microsoft SharePoint Online extensions as well and it worked.

So my problem was, the company I was working for, had a proxy which could not be bypassed. The proxy settings have been set by a GPO and the network settings where fine so far. However the proxy used user authentication to access the internet. Now if I want to use the SharePoint Online tools, I must authenticate my PowerShell session at the proxy so the tools can access the internet too.

The trick to get your PowerShell connected is quite simple. You only need to enter the following line:

[System.Net.WebRequest]::DefaultWebProxy.Credentials = [System.Net.CredentialCache]::DefaultCredentials

Now you should be able to connect to Office365 SharePoint without problems. If you don't want to enter this line every time you open a new PowerShell, you could add it to your PowerShell profile.

ise $PROFILE
then add this to the profile file:

#Set user default credentials for any webrequest
"Setting the users default credentials for WebRequests..." | Write-Host -ForegroundColor White
[System.Net.WebRequest]::DefaultWebProxy.Credentials = [System.Net.CredentialCache]::DefaultCredentials

Toolbox: SharePoint 2013 Search Tool

Using the SharePoint REST API can be sometime a bit of a pain. Good to have some tools at hand that make life more easy. With the SharePoint 2013 Search Tool you learn how to build an HTTP POST query, and how the different parameters should be formatted.

After running the query, you can view all the different result types returned, e.g. Primary Results, Refinement Results, Query Rules Results, Query Suggestions and the actual raw response received from the Search service.

SharePoint 2013 On-Premise and Office 365 are both supported.

To download visit the project page at Codeplex:
https://sp2013searchtool.codeplex.com

The future of Forms for SharePoint 2016 and Office 365

As you might remember, Microsoft announced last year, that InfoPath will be discontinued. It seemed the product would come to an end and would only be supported until April 2023. All efforts from Microsoft were heading into Forms designed on SharePoint Lists, or better known as FoSL.

Well these plans have changed. As it seems Microsoft will not be able to provide FoSL on time for the next SharePoint release. Instead they announced that SharePoint 2016 will indeed have full support for InfoPath Forms for Office 365 and On Premises installations. However, a new version of InfoPath will not be part of the next Office.

Read the full story at:
http://blogs.office.com/2014/01/31/update-on-infopath-and-sharepoint-forms/

Opening Word file from SharePoint 2010 causes Office to crash

Today I wasn’t able to open a Word file from the SharePoint Server. Every time I opened the document from the server, Word crashed. Saving the file to disk and opening it then worked just fine. What made it even worse was that SharePoint thought the file was opened exclusive for my user account and I couldn’t do any action on the file on the server e.g. deleting. Bugs! I don’t like them, but it’s always a good feeling when you found out how to get rid of ‘em.

Creating a bookshelf with the Content Query Webpart in SharePoint

A lot of information these days comes in form of an eBook or similar format like a simple PDF. In SharePoint the easiest way to present this information to the user is as a list. For the more ambitious there is the metadata navigation, which brings a lot of beauty for handling list content. I will use a more sophisticated approach via the Content Query Webpart (CQWP) to present the information like books on the bookshelf.

Preparation

Before we can start, we’ll need to step back for a moment and think about the data structure we’ll need in order to support the view we are creating here. There are a few questions you must ask yourself:

• Where and in which document library will you store you eBooks?
• Will you mix different content types in that document library or will you create a new library for every document type?

In my case, I have more documents other than just eBooks. I’ve decided to keep all documents in a single document library and to identify the documents by their content type. Therefore, one of the first steps will be to create the library, the columns and the content type.

This post is

SharePoint 2015 is peeking thru

Today I was working with the SharePoint Design Manager on Office365 when I found something interessting:

Wave 16 can already be selected in Office365

It seems like Microsoft is already testing Office Wave 16 in the field or at least preparing for it. It is possible to select the Option for SharePoint 2015, but you will get an error that uploading has been disabled by the administrator.