Preauthenticate Office 365 (SharePoint and Exchange) for Internal Users

Using ADFS for Single Sign On does not leverage a full Single Sign On Experience for the users. People will often see the Office 365 and need to fill in their email/upn, before Single Sign On will happen.

Thanks to a very nice OneDrive CodePlex project (, which you should visit too, I was able to write the following PowerShell script which you can use to preauthenticate Office 365 when you use ADFS.

Run the following powershell script after login (see to configure the script to run after login)

$domain = ""; # your Federated domain
$ie = new-object -com InternetExplorer.Application
$ie.visible = $true #Uncomment this for debugging

# Wait for the page to finish loading
do {sleep 1} until (-not ($ie.Busy))
# We have to click the remember me checkbox before logging in, we also have to have IE be automated for this to work
try {
  do {sleep 1} until (-not ($ie.Busy))
} catch {$null}

try {
  $ie.document.GetElementById("cred_userid_inputtext").value = "dummy@"+$domain
  do {sleep 1} until (-not ($ie.Busy))
  do {sleep 1} until (-not ($ie.Busy))
}catch {$null}

sleep -seconds 15 # give plenty of time to redirect

For exchange it is quite easy to create a auto-login just with some DNS modification. You just need to create a CNAME to

e.g. =>


Release Notes Office 365 SharePoint Online (unofficial)

In this blogpost I am trying to gather information about updates performed in SharePoint Online and publish them here. Several feature updates are missing, please feel free to send in any comments!

Version (march 2014)
-SkyDrive becomes OneDrive
-OneDrive storage up to
-Office Web Apps gets updated with enhanced features
-Office Web Apps has new names Word App becomes Word Online etc|
-Content Search Web Part availlable
-Several DIV ID’s renamed

Version 16.0.x.x (september 2013)
– Maximum upload size to 2Gb
– Maximum number of sitecollections from 2.000 to 10.000

Version 16.0.1922.1200 (august 2013)
– SkyDrive Pro; personal space to 25Gb
– SkyDrive Pro; Shared with Me features, to show all documents shared with you (on SkyDrive)

Version (february 2013)
– Initial SharePoint Online 2013 release

Version 14
– Initial SharePoint Online 2010 release

The information published on this blog is not verified by Microsoft and can contain incorrect information.

Signs of Office 365 Preview ( 2013 ) getting to General Availability (GA)

Today I’ve noticed a slight change in our Office 365 Preview which seems to be a preparation step of Microsoft to get ready for general availability (release) of Office 365 version 2013.

In the top left corner we were used to see , but from the 23th January we have

It looks like we are moving from preview to production.

Although Outlook Web App and management portal still shows Office 365 Preview

Day 4 of the SharePoint Conference 2012

The takeaways of the fourth and last day of the SharePoint Conference 2012.

OAuth and SharePoint

– To make a trusted connection between an application and SharePoint use OAuth

– OAuth is implemented in SharePoint and Exchange, onpremise to onpremise and to SharePoint Online. Currently there is no support to authenticate from SharePoint Onpremise to Exchange Online.

– In Office365 OAuth is using a Broker, which is the ACS (Access Control Service), for onpremise you do not have a broker

SharePoint Governance

– Define a policy for using SharePoint hosted, Provider hosted and Autohosted apps

– Check and confirm the SLA of a provider hosted app, catch up with your legal people for data sensitivity and backup/recovery

– Decide if users can install or just request apps from the app store

– Decide if you want to install apps local to one web, or for the whole “tenant”

Webtemplates and SharePoint (Online)

– Webtemplates can be used in Office365, using sandbox solutions

– Sandbox solutions are deprecated in SharePoint 2013

– No alertnative has been announced yet

– Use webtemplates instead of sitetemplates

Time to get home! Thanks Las Vegas and #SPC12

Day 3 of the SharePoint Conference 2012

On the third day of the SharePoint conference 2012 I’ve focus on Search, Azure and Office365, and Windows Phone

Search Driven Development

– Transform search results really easy using result sets and query rules

– Query rules perform on conditions and run actions against the result set. E.g if query contains the word “picture” the user is probably looking for pictures, with the query rule we can push a resultsblock with pictures alternatively styled

– Configure refiners to present themselves as sliders, multichoiche or barchart

– Configure refiners to load for specific queries with query rules

– Manage Search configuration in the site collection and web level

– This is THE way to build your intranet or internet website

Azure and SharePoint, better together

– Azure websites can communicate with SharePoint using OAuth tokens

– A Client App Part can show a page from azure with the required token information in the URL. So now you can integrate functionality which cannot be build in SharePoint in Azure and integrate with a Client App Part.

– Azure is still in Preview, GA (General Availlability) is not yet announced

Windows Phone app and SharePoint

– Developing Windows Phone Apps can be straightforward when it fits in the templates provided by the SDK

– Apps will run on Windows Phone 7, 7.5 and 8

– The Apps will use the REST/JSOM models to fetch and write data to SharePoint

Almost done here, tomorrow the last day of the conference

Day 2 of the Sharepoint Conference 2012

The second day of the SharePoint Conference 2012 was very interesting with some deep dive sessions.

Connecting hybrid to Office 365

– In a hybrid deployment you can combine search results from onprem and o365

– Profile store will be connected to the online profile

– Metadata cannot be connected to the cloud

Office Web Apps Server 2013

– Standalone server, upscaling really easy with auto load balancing

– Configuration is just 2 PowerShell commands, there is no UI

– Office Web Apps 2012 are a lot richer in functionality for authoring

– OneNote is now part of Office Web Apps

– OWA server can be used by Exchange, Lync, SharePoint and every other third party vendor. Also Open from URL is available, where the URL can be any websites or URN on you network

– Security IS taken care of

Claims authentication migrations

– Claims are the default in SharePoint 2013

– Several migration scenario’s for Classic, Windows Claim, SAML Claim etc.

– I you do not migrate to Claims and stay in classic, Ofiice Web Apps previews will not work

– Custome code cannot using WindowsIdentity anymore, although you can use the Claim2WindowsToken service

Running SharePoint in Windows Azure

– Running SharePoint in Azure will be fully supported

– You can run SharePoint on Azure for your internal users only, a caveat is that you have to provide load balancing yourself

– If your requirement is to publish the environment to the web you only have to make a new Endpoint in azure, Azure will take care of the load balancing

– Costings are way lower than hosting SharePoint in your own datacenter(s), especially storage is very cheap

– With PowerShell you are able to export and import Virtual Machine Configuration. This enables a lot of interesting management tools to lower the cost of virtual machines which should not always be on. Like development, test and acceptance environments

– If you want to have a disaster recovery environment ready in 15 minute, but don’t want to pay for hot-standby, Windows Azure is the solution

Catch up tomorrow with a new update

First impressions of SharePoint 2013 on the SPC2012

On the first day of the SharePoint Conference 2012 we have heard a lot about Office365, Yammer, Apps, Upgrades and more. In this blogpost I will give you a summary of the most interesting items in my opinion.


– Autohosted Apps running in Azure which require no additional configuration in Azure, OAuth and Azure services are setup right away

– Drag and drop files to sharepoint document libraries

– Easy design changes with the Design Manager, upload HTML from your favorite tool and it will be automaticly translated to a SharePoint masterpage.

– Yammer integration in Q1 of 2013 which will contain Document and Newsfeed integration. Next release it looks like Yammer will be completely integrated into SharePoint, which should be, because it looks a bit of the same kind when looking at the social features of SharePoint 2013

What´s new for developers

– Three different development scenario´s with access services for endusers, napa javascript development for prototyping and Visual Studio for the hard core development

– Outlook Apps will be compatible with Outlook 2013 and Outlook Web App 2013, so there is no different experience when using the web ui

– Napa web interface for developing apps, Open in Visual Studio when reaching boundaries of the interface

Upgrade overview

– The upgrade scenario´s are kind of the same as SP2010

– SP2010 Mode for backwards compatibility, even can create new sites with SP2010 mode

– Allthough you have a staged upgrade for site collections

– First the database schema is upgraded on attach

– Then you as IT, or the end user, has the choice to upgrade the site collection

– Build to build upgrades can leverage the functionality of SQL Snapshots, very handy to reduce outage during upgrade.

Building SharePoint Apps with Azure and Windows 8

– Neat integration between all these platforms with HTML5, JSON, XML Javascript, OAuth

– OAuth is the key integrater regarding authentication between SharePoint and Azure

– _API (yes, UNDERSCORE API) is the new Client Object Model api which is richer than before, now Profile and Taxonomy information can be accessed using this services and many more

– Windows 8 tiles can be build on HTML5 plus Javascript, called WinJS, really easy integration with SharePoint webservices

– SharePoint Workflows can be hosted in Azure, for greater scallabilty and stability

This is my summary of the first #SPC12 day, hope you like it as much as I do.