Notes from Collaboration Summit 2018 conference

Few days ago I was on European Collaboration Summit 2018 conference – one of the biggest Office365&SharePoint-oriented conferences in Europe.
I’ve learned a lot, talked with multiple MVP’s and speakers about O365/SP issues, changes and future approaches.
I want to share my notes with you:
What is coming for Microsoft Productivity area (SharePoint, Office 365)
Microsoft Teams:
– Library UX in Microsoft Teams will have the same UX as library in SharePoint UX.
– Microsoft Teams will have new tab type: SharePoint Page 🙂
– news aggregated from SP News Pages may be fetched into channel via new connector dedicated for sp news page.
– SharePoint will get an Image Webpart which displays image and also suggest tags based on objects recognition in image(!).
– New Modern SP News pages – aggregate news from site hubs. Allow for creating templates, targeting (via details panel that based on metadata). News can be marked as “read later” (such news will appear in dedicated panel in user profile) and also marked as official (which will increase reach to recipients). Page promotion can be also achieved via email (right from the page) or added to navigation for better visibility. If page was not a news page it can be easily converted to such. Worth to note that you can also utilize Microsoft Flow for workflows activities (accepting, reviewing, publishing, extended notification etc). In terms of future releases Microsoft is working on network/click analytics as well as automatic translations
– SharePoint pages support content targeting so people will see content more personlized
– “Share with” expirience will be constant on every device. Moreover all related policies will be better visible for sharing person.
– you can embed Microsoft Streams video as a webpart in SP page. Why to do that? Because Microsoft Streams supports searching inside video (!)
– Site Collection structure will be replaced by Site Hubs. Hub sites aggregate news/activity content + add same global navigation. Hub concept bases on site label tagging (rather than structural db-related site collections that makes maintenance not that easy) – you can easily move site from one hub to another.
SharePoint search:
– In new SharePoint Classic Search UX will be replaced by Modern Search. It will be also open for customization using spfx.
– OneDrive will monitor suspicious behaviours (i.e. caused by maleware) and allows you for ease restoration of all changed files
Yammer is now more integrated:
– Yammer groups connected to O365 groups (had a shared calendar, SP site)
– announcements are push msgs on mobile
– well cooperate with Streams
– will be integrated with SP search (soon)
– Future: all files in yammer will be stored in SP, content sharing improvements, further development over employee engagement and social features.
– PnP is going powerful more and more. One of the best Frameworks from Microsoft (or not that Microsoft in fact ;)). Billions of usage per month. Absolutely amazing. If you do not know it that better do – immediately!!!111oneone -> 

 – You probably may heard of Site Scripts: JSON files, which define an ordered list of actions to execute while creating the SharePoint site. The actions can include any combination of below:

  • Create a new list
  • Apply theme
  • Set site logo
  • Add navigation
  • Trigger Microsoft flow

Site design may contains 1 or more site scripts. However site scripts has it’s own limitations (i.e. no they are non-destructive. You can only add missing elements to the site). But where site scripts stops a pnp provisioning engine takes over!

On one of the sessions there were presented example of site provisioning via site scripts that runs azure function which apply pnp-provisioning.

From others topics:
– Skype for Business will be supported for on-premise solutions
– Microsoft Flow got new block that allows for calling ANY sharepoint REST endpoint…A-M-A-Z-I-N-G!
– SharePoint on-prem will have a Microsoft Flow gateway. However SharePoint Workflows will be still supported but it is recommended so that you first try to find a solution using Flow and if it is unachievable than try with SharePoint Workflows.
So to summarize it:
MS has a plan and they seems to know what they’re doing.
Paraphrasing Steve Ballmer words: Integrate, Integrate, Integrate.

Week 49/2017

New week, new quick update for you!

  1. I cannot count how many times it was a pitfall for me and my colleagues – managing O365 without powershell (i.e. from Mac)? Now you can – Platform independent Command-Line Interface for Office365 now available! 
  2. Visual Studio Code now supports Azure Data Lake R & Python extensions!
  3. There is new version of the Elastic Database Client Library for Azure SQL database supporting Java. The client library provides tools to help developers scale out the data tier of their applications using sharding, including support for multi-tenancy patterns for Software as a Service (SaaS) applications.
  4. iOS Yammer users have now an option to praise their coworkers as well as publish announcements from mobile app.


And if you have a little bit more time for a small literature I recommend you below content:


Microsoft is now like never before

Today won’t be technically. Today will be about something that has been following me from a long time. Something that is a result of many years strategy and 27caused that Microsoft is now like never before. 

Genesis: The Story 

Few weeks before now I had a chat with a colleague of mine. In his company he has O365 tenant with all of its sugar: Word, Excel, Project Online, SharePoint Online etc. However for team chat/messaging his company use Slack. When I asked “Why?” he answered: “we’ve tried using Skype for Business but it’s unusable. It’s absolutely counter-intuitive and its conference quality (especially audio) leaves a lot to be desired. And I must agree. But then I asked him:

Continue reading “Microsoft is now like never before”

Week 48/2017

This week I’m serving you great news from SharePoint Online areas:

  1. Remember Document Information Panel in Microsoft Word?

Properties area of Info Tab with Status field displaying a red border

Quite limited especially when thinking about SharePoint integration. That’s why a new panel for document properties has been released (allow even for picking managed metadata!)

2. Now you can use PowerApps to provide SharePoint list form!!!!

3. Last week I wrote about new powershell module for Microsoft Teams. What if we could use it in Azure Function? This post describe how! Awesome job.

4. And since Azure Function has been mentioned – they’re now available on IoT and Linux too!

Have a great weekend!

Week 47/2017

This week there were some great roll-outs in Office 365 (source: roadmap):

  • Zip file support – In the OneDrive web view , users will now be able to look at the content in a zip file and choose which files to extract

  • Secure External Sharing – When sending secure links to recipients outside of your organization, those recipients will be sent an email message with a time-limited, single-use verification code when they open the link
  • OneDrive Support for OnPrem with Android app
  • Files On-Demand – With files on Demand users can access all their files in the cloud without using their device storage space.

Besides you may be also interested in:

  • Bots still in “Buzz bucket”. This week Stephan Eyskens uploaded new video on channel9 about building chatbot with Custom Speech service from Azure. Btw – check out his other episodes where he is playing with other services from Cortana Intelligence Suite – awesome job!
  • New improvements in SharePoint Mobile app! Among them: notifications about new articles, me tab, “save for later” cache or SharePoint Server 2013/2016 on-prem support for Android SharePoint mobile app.
  • I know it’s now really an update but somehow I’ve missed it – do you know that you can add other cloud storages than Microsoft to your MS Teams Files? 🙂


Bonus article for weekend :

iPhone X Face Recognition was the hot topic for last days. Ars Technica add their 2 cents why they’re not really convinced about breaking Apple Face ID.


Have a great weekend! 🙂

How I speed up loading my SharePoint Online site component 6x – part 2

Last week I wrote a post about how I fix CSOM code in order to accelerate whole query execution. Final result was not that bad though still not good enough:

  • 0.8s for fetching ~500 subsites
  • 6.5s for fetching ~900 subsites recursively for whole subsites hierarchy

My aim is to fetch whole subsites hierarchy within time that is reasonable to wait (1-2s total).

In this post I show you how to achieve it – we can fetch whole subsites hierarchy in less than 2s!

Continue reading “How I speed up loading my SharePoint Online site component 6x – part 2”

How I speed up loading my SharePoint Online site component 6x – part 1

Intranet home page should contains all information that are needed in daily manner. In fact many companies use home page as a traffic node where everybody comes just to find a navigation link pointing to another part of intranet. In my current company, Findwise, we do that too. However one of our components that allows us to quickly navigate through intranet sites gets slower and slower year by year. Currently it’s loading time is almost 10 seconds! I decided to fix it or even rebuild it if needed. Especially that few weeks ago on ShareCon 365 conference I talked about SharePoint Framework in Search Driven Architecture where I described the customer case, PGNIG Termika, who saved about 600k PLN (~$165.000) per year thanks to their information accessibility improvements (information time access dropped from 5-10 minutes to 1-2 seconds). 

In this post I wanted to show you what was the problem, how I fixed it and how my fix cuts the component loading time 6 times!

Continue reading “How I speed up loading my SharePoint Online site component 6x – part 1”

Week 44 update

When I wrote post about August changes in Microsoft products I was not expecting that it will be so hard to decide which information include in such update – Microsoft is changing a lot (which is great!) and I would like to give you every great link that I came across on the internet but from the other side – if you would have to check every link or article I’ve provided you and read it…such updates will be pointless because I want it to give you quick glance of “how things are going in general in MS”.

That’s why I came up with new idea – week updates! Every friday so you can have a lecture for weekend and be updated for next week 🙂

I want to gather information about MS products road map updates (preview/release), some announcements about future plans and great articles that reading give you a lot of value.


So – here we go!


Roadmap updates


  1. Onedrive was always kind of mistery in terms of integration with other MS tools, licensing and priv/biz. Now it’s not! 
  2. Roadmap for Skype for Business capabilities coming to Microsoft Teams
  3. An introduction to Azure Web Apps on Linux
  4. Want to introduce your employees to the newest updates in SharePoint Online? At, there are 3 new SharePoint Online training courses to help users get up and running


Have a great weekend!

How to get all terms from Managed Metadata Service in SharePoint?

In this post I want to show you quick solution how to get all terms from Managed Metadata Service in Sharepoint Online


A colleague from my company asked me is there an easy way to get all terms from Managed Metadata Service in SharePoint Online. I told him:

– “sure, there is managed metadata app that allows you to navigate through whole managed metadata terms structure. Have you tried that?”

– “Yeah I know. But I need to export all terms, with their structure path and present them in list” (don’t really remember specific reason – suppose some data science probably). 

– “Oh, I see…”

Continue reading “How to get all terms from Managed Metadata Service in SharePoint?”

Sharepoint Framework in SharePoint Search Driven Architecture

On 16.10.2017 I had a privilege to be one of speakers on ShareCon365. I had technical speech where I showed how to make Sharepoint Framework (SPFx) apps in Search Driven Architecture. If you were on my speech you are probably interested in materials which you can find here: My presentation materials.

If you were not…than keep reading 🙂 

Continue reading “Sharepoint Framework in SharePoint Search Driven Architecture”