How to output the Office 365 Roadmap as a spreadsheet

If you want to stay on top of what’s coming soon for Office 365, the Office blog will be the source for major announcements, but you’ll also want to keep an eye on the Office 365 roadmap – which also covers Office Online and If the Office blog is going to cover a feature, the news will be there first, but smaller features may only be covered in the roadmap.

A bit of a friction I’ve run into quite a bit, is that because there’s so much goodness in the pipeline that it’s kind of clunky to try and advise people as to what’s on deck, what’s been launched and everything in between – clearly some of the major new feature sets getting launched are pretty hard to miss as there will generally be a major post on the Office blogs about it. However, often the peripheral improvements are useful to have good optics on.

Everyone loves tabular data, so let’s get this sucker into a spreadsheet so we can crunch the data easier!

Due to the number of features in the mix, it’s kind of essential to get the info from those two sources into a spreadsheet to be able to crunch it and also track it in the long term (monitor for changes).

I used a few Chrome Extensions, primarily “Data Scraper”, whipped up the XPath formulas required and exported as CSV.

Chrome Extensions Used:
Data Scraper:
Recipe Creator:
Xpath Helper:

Here’s the Data Scraper rules I used – the XPath pattern used is to define the main repeating container of info, then divvy up the contents as they will be added as columns in Excel:

Container: //article/div[2]/div/div/div[1]/div
Status: ../../../div[1]/div[1][contains(@class, “feature-group”)]/div[1]
Title: ./div[1]/div[1]
Description: ./div[2]/div[1]
Link: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__more-info”)]/a[1]/@href
Category 1: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__tag”)][1]
Category 2: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__tag”)][2]
Category 3: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__tag”)][3]
Image: ./div[2]/div[3]/div[contains(@class, “feature-image clear-fix col-md-12”)]/img[1]/@data-original

This article does not advocate automatically polling the Office 365 Roadmap page. No one likes bots hammering their pages – you are obligated to play nice according to’s terms of use. This extensions/scripts described here work on the clientside browser only. Please manually download an offline copy of the page and do your work on that.

Microsoft Ignite Conference: Day 2 Round-Up

Day 2 started off with a walk to the shuttle bus under the looming John Hancock building. Infrastructure into the Cloud, this pic worked out well as a deep ol’ metaphor 🙂 :
John Hancock

Here’s some of the most awesome SharePoint/Office 365 sessions from Day 2:

There are over 150 Day 2 sessions available for immediate viewing.

Source: Microsoft Ignite Day 2 Sessions On-Demand

Here’s my takeaways from the sessions I had scheduled:

Microsoft Office 365 Groups Overview and Roadmap

“It’s not an email, it’s a conversation.”
Dynamics CRM and Group’s integration.

Office 365 Groups helps you collaborate by easily bringing together your colleagues and the applications you need to get work done. Office 365 Groups leverages a standard definition for team membership and permissions across Microsoft Exchange, SharePoint, and later Skype for Business, Yammer and the rest of Office 365, managed through Microsoft Azure Active Directory. This session provides an overview of Office 365 Groups, demonstrates its capabilities today, and provides a roadmap for future investments.

Designing and Applying Information Architecture for Microsoft SharePoint and Office 365

Provide Clear Guidance
Make it Easy
Keep it Simple, Stupid
Define > Design > Implement > Govern

This session demonstrates a proven process for defining, designing, implementing, and governing your information architecture (IA). IA is more than just columns and metadata. Learn how the different components available in SharePoint and Microsoft Office 365 can be leveraged to their fullest potential and your users’ ultimate benefit to content organization and discovery.

Managing Change in an Office 365 Rapid Release World

Selective First Release! Roll out first release changes to selected users only. ’nuff said.

Before moving to Microsoft Office 365, your team planned each and every change or update before your users saw anything new or different. Now in a services-first world, changes are introduced at a rapid pace, sometimes before you or your help desk may be prepared. Office 365 provides communications to help you manage change, stay informed, and inform your users. Learn how to best use the Office 365 Message Center,, and to get ahead of updates and help your business take advantage of the latest and greatest Office 365 has to offer.

Microsoft Office 365 Groups Deep Dive
Office 365 Groups helps you collaborate by easily bringing together your colleagues and the applications you need to get work done. Office 365 Groups leverages a standard definition for team membership and permissions across Microsoft Exchange, SharePoint, and later Skype for Business, Yammer, and the rest of Office 365, managed through Microsoft Azure Active Directory. This session follows the introduction session “Microsoft Office 365 Groups Overview and Roadmap,” and covers the following topics: architecture, administration, security and compliance, and extensibility.

All in all a great day- I was also lucky enough to be able to work at the Microsoft MVP Booth (in the “Microsoft on Microsoft” section of the Expo Hall). Very rewarding to answer questions about the MVP program and connect with people from around the world.

MS MVP Booth


Microsoft Ignite Conference: Day 1 One Round-Up

Microsoft’s Ignite was a huge event- 23,000+ attendees -and a lot of news came out of it on day one. I’ll share with you here my take on the big items of the day, flavoured through my lens of SharePoint/Office 365.

Since there was so much going on, i’m going to break it out into day-by-day posts- easier to digest and gives me time to collect my thoughts after being hit on the head with a Chicago-sized Microsoft frying pan. 🙂

The core concepts: Microsoft is taking a mobile-first, cloud-first approach with three top priorities: to usher in an era of more personal computing, to reshape work and productivity with enhanced products and processes, and to build trust in a reliable, extensible cloud service offering.

Let’s get started. First, check out the official Microsoft news homepage for the event at

Here’s a selection of  some of the hot sessions now available from Day 1:

Also available in the on-demand recordings is the Monday morning keynote, which was delivered effectively by Microsoft CEO Satya Nadella, and the evening keynote hosted by Harry Shum titled The Next Era of Computing: Seeing the Future Before It Happens.

spark the future
First, a little recap on the sheer scale of the event. 23,000 of some of the world’s best IT Professionals in one spot, yet the Borg-scale capacity of the McCormick + Lakeside Conference Centers seemed hardly enough:
stack overflow

The keynote began on the upswing, with a DJ pumping out music to many, many IT peeps who are perhaps used to a little more mellow entrance in Monday Morning: 🙂

A pretty unexpected kick off to the keynote: The rapper/Artist know as Common takes the stage and delivers some inspiring words:

Soon thereafter, the big boss Mr. Satya Nadella took the stage.

Satya Nadella



Office 2016 Public Preview
Skype for Business broadcasting
Office Delve Org Analytics
SQL Server 2016 on-premise Azure (if you want the deep-dive version, check here:
Windows users can try Office 2016 and its new desktop co-editing feature
Microsoft launches Operations Management Suite to deal with infrastructure across clouds

“Move IT from delivering services in our org, to delivering transformation and innovation.”
“Mobile first, cloud first – but it’s not about the mobility of a single device. It’s about the mobility of the experience. It’s about the cloud back end, and adding intelligence to your experiences.”
“MobileFirst is not about a device, it’s about sharing computing across all the experiences in our life.”

“Social collaboration and co-creation are at the core of what we do.”
“There are going to be more devices than people on the planet.”

“Exchange, Skype for Business and OneDrive span both your personal and work life”
“The next version of SQL Server is considered a breakthrough.”
“It is important to us to build trust into the core of the operating system…that’s not a bolt-on, you have to build that in.”

There was a brief unscripted comedy moment when Mr. Nadella was describing a scenario where Delphi software would allow one to know exactly when their partner was coming home:

Joe Belifiore

– Joe says about 5-8% of users use Alt-Tab to switch between apps. Adding multiple desktop support. Hold down control/Windows/right-arrow and switch between desktops, or left-arrow to go back. Dragging an app from one desktop to another got the first spontaneous audience applause.
– Demos Cortana, and Cortana driving PowerBI
– Demos Continuum, a new way of changing the Windows user interface to change between tablet mode and laptop mode depending on how you hold the device
– Demos Windows Hello, a new facial recognition authentication mechanism that works through the webcam. Takes a cloth off a webcam, and it unlocks his laptop in a matter of seconds without the user doing anything.

.. at this point I had to move on to the rest of the Conference –

The Evolution of SharePoint

– OneDrive integration improvements are a big priority for the SP team
– Experiences, Extensibility & Management are the core principles
– On track in development efforts for delivering SharePoint Server 2016 next year
– Cloud-inspired features eventually will make their way back into the server product. Functionality that doesn’t make it into the server will be offered as Office 365 services that can be leveraged by premises-based systems
– Microsoft is continuing to focus on SharePoint’s Files, Content Management, Sites and Portals components going forward. It plans to make it easier to use hybrid architectures (SharePoint Server plus Office 365 services) and make it easier for organizations to perform migrations when they are ready, according to Seth Patton, global senior director for SharePoint and OneDrive product marketing
– A new About Me next-generation portal coming to SharePoint Server 2016. It uses Microsoft’s Delve content discovery tool, based on Office Graph enterprise search technology, to surface content and organizational information. Microsoft is also planning to ship an upgrade to SharePoint Server 2013 that will enable the Delve portal for those organizations that can’t wait for the release of SharePoint Server 2016.

Information Management with Office 365 in Mind

The Next Era of Computing: Seeing the Future Before It Happens

All in all, a heavy duty day full of news, connections and learnings. Day two recap coming tomorrow, subscribe to my blog to stay looped in!

Office 365 Internet Explorer Security Settings – The Final Frontier

On the post, I tried to rationalize IE security settings relating to Office 365.

I spent a good three hours last night trying to understand why indicates that Office 365 users should have their Internet Explorer security zones set with the main properties in both Trusted & Intranet security Zones. Any authoritative () advice on if we’ve been wrong all these years advising just the Intranet Zone in https would be great!

Trusted Sites Zone:

Intranet Zone:


To my understanding the two base requirements for dual zones are WebDAV’y type stuff and ADFS SSO:

Theory 1: WebDAV
is that the intranet zone entries cater to the URLs without a dot but mostly for \\ UNC-style shares/webdav.The trusted sites version serves standard FQDNs. The intranet zone serves everything else. The PROPFIND stuff involved with ActiveX when Office documents are opened by IE is also likely borked by improper zone-age.

For example, I access an O365 doc library with “Open with Explorer View”, and the URL WebDAV negotiates is: Documents

BUT.. if I wanted to map that as a network drive the URL I would need to use would be:

Notice that literal https:// is not in play here.

For a similar approach, you can try the steps at to connect a local folder to SharePoint library. Try it with and without the dual zones to see the difference- i couldn’t personally get any unexpected logouts or other ill behaviour to occur but that could be caching. Worth testing.

To see what’s happening under the hood, download the ie zone analyzer tool from  I ran a comparison of the differences between my Surface’s IE11 Intranet Zone & Trusted Sites Zone.  There’s few yellow line items in there that Intranet Zone has that would make sense that you would want for full Explorer-like capabilities.

Looking at , they define the Intranet Zone as:
The Local Intranet zone is defined as all network connections that were established by using a Universal Naming Convention (UNC) path and websites that bypass the proxy server or that have names that do not include periods (such as http://local), as long as they are not assigned to either the Restricted Sites or to the Trusted Sites zone. The Trusted zone has a default configuration of automatic logon only in the Intranet zone.

Theory 2: ADFS SSO
On they direct us to ensure the “enable automatic login” is set. OOTB Internet Explorer is set on both Intranet and Trusted site zones to “Automatic Login in Intranet Zone only”.

If this is not done, the users will be prompted for credentials from the AD FS server. Adding the AD FS server farm address to the Local Intranet zone allows IE to pass your credentials to the webpage added to the zone.

SO, my thinking is that although you could of course manually adjust these individual security settings for different zones, it’s an easier pattern to follow to just have the Intranet Zone be the place where you want to have automatic logon enabled. This will allow Internet Explorer to automatically pass the user’s credentials to the AD FS server.

Of course, since we know that URL’s without a dot in the them (e.g. https://corpIntranet) are always shunted into the Intranet Zone no matter what, this is more fuel for the fire that we would want to be working from the from the Intranet zone, in the case that we were federating https://corpintranet to https://* . Is that scenario supported? I think so, cannot confirm or deny based on what I looked up but it would be a pretty common scenario I’d think.

In the end, i’ve..:
– Gone a bit bonkers trying to sort this out
– Haven’t got a 100% feeling about advising people to set both zones with those URLs
– Come to believe there’s a bunch of dependencies and variations across versions of Internet Explorer and the various O365 systems that make the Intranet Zone the right call sometimes, and Trusted Sites the other. Having the zones dual-configured like described allows MS Support to support all the scenarios with one simple directive.

– Latest URL’s added – article ref’d in my post – MS support confirming. MSFT Mikey comes in later in the thread and contradicts the dual zone setup directive – breaks down how having a dot in name causes address to be treated as if it’s in the Internet zone instead of Intranet zone and how to overcome – describes O365 desktop tool setup. – ADFS SSO Intranet zone requirement – ADFS SSO Intranet zone requirement