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.

XRANK in SharePoint Search REST API

I work with SharePoint Search from some time now. Since many clients need assistance on Search optimization KQL is one of my best mates. Especially XRANK is very powerful function that leverage KQL capabilities but also enlarge its complexity. Anyway I feel quite sure about what we can achieve using KQL and how. However last week a colleague of mine asked me about what is proper syntax of XRANK in REST search queryโ€ฆand I was like “emmmโ€ฆ”.

There are many not obvious questions – which characters need to be encoded? Is the syntax the same as in common KQL query?

I did quick documentation check as well as googling for an answer but there was no satisfying results at all (if there is no answer in Stack Overflow the web contains no answer).

So this post is about clarification for XRANK syntax in REST API calls.

Use Search Query Tool

The old sentence says “Do not break open doors”. That’s why I did not investigate topic by myself trying different REST queries to SP Search. Instead I used great great great tool called Search Query Tool. It really makes your work with search easier and faster. You can build any kind of KQL query in it and it will be translated to REST query because it uses it to communicate with SharePoint.

So for instance if you want to execute following KQL query

*  XRANK(cb=1) Position:Manager

Its REST equivalent will be:


As you can see syntax is the same as in common KQL query however ‘=’ character has been encoded to URI format in order to be properly understood by browser and endpoint and any spaces has been replaced by “+”.

Complex XRANK queries

Remember that in order to build you must remember about proper use of parenthesis. For instance if you want to make multiple XRANK boosts you need to arrange them in following way:

(SearchQuery XRANK(cb=1) condition1) XRANK(cb=1) condition2

In other words, if you want to add boosting for position AND for date freshness your KQL will look like below:

(* XRANK(cb=1) Position:Manager) XRANK(cb=0.5) LastModifiedTime>{Today-365}

and your REST query text will be like following:


which gives you following results:

  • results older than 30 days and for person that position does not contain “Manager” in its name will get 0 ranking points
  • results modified less than 30 days ago and for person that position does contain “Manager” in its name will get 0.5 ranking points
  • results older than 30 days and for person that position does contain “Manager” in its name will get 1 ranking points
  • results modified less than 30 days ago and for person that position does not contain “Manager” in its name will get 1.5 ranking points


Hope it helps you in using XRANK and KQL in REST API queries.


Thanks & have a great day!

Week 4/2018


I decided to post week updates less often, but more valuable. And this week I have something really worth of noting:


How to execute ANY SharePoint powershell command programmatically using C#

In one of my projects my team faced following challenges:

  • How to add query rules programmatically using C#
  • How to update thesaurus programmatically using C#

I tried to find information in official documentation but it was not very helpful neither was googling.

Powershell cmdlets to c# assembly mapping

In my team we were thinking what to do in this situation and one of my colleagues came with brilliant idea – he searched for PowerShell cmdlet in file explorer with searching in files content option turned on.

Result? What he found was exactly what we were looking for.

In location “C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\CONFIG\PowerShell\Registration” there is file named OSSSearchCmdlets.xml.

What it contains is xml structure with following structure:







My eyes see this just as below:






Maps for Search, WSS and many more

OSSSearchCmdlets.xml file contains ps cmdlets to .NET assemblies mapping only for SharePoint Search.

But in the same location there is also another file called WSSCmdlet.xml that contains all kind of cmdlets mapping like

  • Enable-SPFeature
  • New-SPContentDatabase
  • Get-SPFarm
  • Etc.

Shortly everything that you can do with SharePoint Application using PowerShell.


If you just want to quickly check what those files contains I’ve uploaded them to my github. I put there also more files like for Reporting Services, Workflows etc. You can check it here.

Have you found useful this tip? Maybe you know alternative way? Share it in comments!

Thanks & Have a great day! ๐Ÿ™‚


Week 1/2018

Hey there!

Welcome in the first week of 2018. End of 2017 was quite busy but not only for me – I guess all IT world was focused on closing projects or budgets (polish companies close budgets on end of calendar year). In other words there is not much to update except maybe one thing:

  • SharePoint Online – personalized search from SharePoint home in Office 365. It includes multiple results (like sites, people, files) based on your activity and frequency.

That’s why I try not to focus only on MS updates but also on interesting articles from MS-IT world. Like below:

Script Wars: The Farce Awakens (part I)  – both amusing and informative posts about how to write powershell properly. Directly from MS PFE who is “strong in the ways of The Farce”. 

Week 51/2017

Week 51 update incoming!

But first…This week I made a presentation on Google Campus in Warsaw about Typescript. 

I’ll write about it more on the next week but just for now – quick link to view my presentation about Typescript ๐Ÿ™‚


All designs made by “Design Ideas” (automagic!) available in PowerPoint!

Office 365

Few important changes for Microsoft Teams – a tool from Microsoft that is becoming one of the most hits from Microsoft and place it right after OneNote in my private ranking ๐Ÿ™‚ :

  • Microsoft Teams
    • First of all – you can now use your Microsoft Teams as your private telephone network used within a company (PBX)
    • There was an update for MS Teams that fixes problem with polish characters (believe me – it was crucial!), allow for sharing window (before you can only share whole screen) and few other stuff that prepares MS Teams to swap Skype for Business for ever! (yey!)


Quantum-computing is something that is arising from laboratory phase into development and common usage. Microsoft is aware that quantum computing is becoming more and more important so they providing free preview version of its Quantum Development Kit (Article) -> Direct Link to Quantum Development Kit (includes local quantum machine simulator).


There is also documentation on how to setup your environment and start with Q# coding – check it out!

Extra read for weekend

  • Nowadays there are many different opinions on FaceID feature presented by newest Apple device. There are some pros and cons for that (as for everything actually) but Troy Hunt made well argumented opinion that for me is a verdict – FaceID stinks
  • From some time I’m quite interested more in management topics than before. I started to read more and more about it and I found that that some time ago Google ignited project called Oxygen that tried to prove if management roles are needed or not in organization. Great article, great conclusions.
  • If you were interested in attending on AWS re:Invent 2017 Sessions but from some reasons skip that and wanted to see what it was about (like me) – there is a great list with all AWS re:Invent 2017 Sessions

Week 50/2017

Just before Christmas there is much more work than ever so no much time for writing posts. However there is always time for quick week update! ๐Ÿ™‚

Not many positions but huge and great changes:

  • Check out new connector in MS Teams for Github, Jira and Bitbucket where you can set notifications of pull requests (create, approve, update, reject), pushes, issues and commits so you can keep an eye on everything from one place. From my perspective that was something really important since I can use now 1 software to get quick overview and if I would like to get more in detail (i.e. code review) I can go for more specialized tool. 
  • There is General Availability of Office 365 Advanced Threat Protection for SharePoint, OneDrive, and Microsoft Teams (yey!)
  • Visual Studio for Mac is now released
  • This one is from last month but…I don’t know how could I missed that. Visual Studio Live Share – and this is awesome! Why? Just first few thoughts: code review, learning with assistance, remote pair-programming, skill examination etc.

Have a great weekend! ๐Ÿ™‚

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!