Working with dates in Microsoft Flow

Arjan Cornelissen
In my journey of using Microsoft Flow, I had some frustration this week on working with dates. The problem we had is as follows, with the sending of the emails, the dates are in UTC. To make it usable, we needed to convert it to our time zone. Convert date and time to a time zone For this Microsoft has built-in functions like “convertFromUtc”, this function converts the input date from UTC like a SharePoint date to any time zone.

Force renewal of Content Types in SharePoint Online

Arjan Cornelissen
In 2014 I wrote a post on how to force the renewal of the content types in an on-premises environment and got a request on that post if it was possible to do the same in Office 365. After a short research and some changes to the original script, see below for the result. It uses the Office Dev PnP PowerShell CmdLets. See below for the version for SharePoint Online

Enabling modern authentication on Office 365

Arjan Cornelissen
The first thing that might come to your mind might be that modern authentication is enabled for Office 365. Well that is partly true. It is enabled for SharePoint online, not for Exchange and Skype for Business if your tenant is created before august 1st 2017. While writing this about 95% of the tenants are older then 1 month so modern authentication is not enabled for Exchange and Skype for Business.

Give a partner access to your SPO site

Arjan Cornelissen
As I described in a previous article you can add a partner to your Office 365 tenant to assist you with managing your tenant. This article goes deeper into what your partner can do in SharePoint Online Your partner can do the same things as the SharePoint administrator can do, so they see the SharePoint admin portal and can change all the settings. By default, they do not have access to any site collection or the data in your site collections.

SharePoint Saturday Munich 2017

This year of SharePoint Saturday’s started with the one in Munich last weekend. This time there was also a preconference session on Friday. The sessions on Friday and Saturday were held at the brand-new building of Microsoft Germany. Friday session This year they organized two preconference sessions. A developer one about Office Dev PnP and an IT Pro about SharePoint 2016. I went to the SharePoint 2016 session where they talked about all the aspects of SharePoint 20116.

Azure B2B updates

A week ago Microsoft released the public preview of the Azure B2B invitation API. I have seen this at Ignite in September that they were working on that. The announcement can be found here With this announcement I went looking into this what other options there already are for inviting a partner into your AD. The options at this moment are: Upload CSV file thru Add a user in the new portal https://portal.

SharePoint Saturday Brussel October 15, 2016

Last weekend I visited SharePoint Saturday in Brussel Belgium. This was my fourth time here in Belgium and again a great one. The day was setup up 6 sessions of 50 minutes and a lunch break of 1.5 hours with a 30 minute. We started at 9 with a welcome from the BIWUG team and the first session started short after that. I started with some developer sessions. Get Typing with TypeScript I started the day with a session from David Opdendries (@sharepointdavid)

Ignite 2016 Atlanta summary

Last week I had the privilege to attent Microsoft Ignite in Atlanta. This week was full of news, sessions and a lot of walking. Besides the sessions, this year the expo hall was large, I have spend a lot of time at the expo talking to venders, partners and Microsoft. I have created a PDF from all my notes. On a few notes I have references to slides, the slides should be come available on https://myignite.

Microsoft Security analytics service for Office 365

Arjan Cornelissen
Last week I got an email from a coworker that Microsoft has created a score website ( for Office 365 tenants. This website measures the security of your Office 365 tenant. By default the score of your Office 365 tenant is very low, I got on my personal tenant a score of 29 out of 243 and on one of my customers also got 29 out of 243. What does it rank This website ranks about 60 settings within your tenant divided by three categories