How to map user profile to ECT field

Last week I encountered a problem related to External Content Type (ECT). I had a SQL table that contains article information: title, content and author. I wanted to search in that table using SharePoint 2016 search (on-prem). In order to do that I’ve created an External Content Type with above data, create content source and crawl it. Then I’ve mapped all crawled props to managed props in search. I was able to see articles data from SQL in my search results. 

Perfect? Not really…

Continue reading “How to map user profile to ECT field”

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”

How to change Todoist task project when task is updated using Flow


You need to make automation so when you’ll set a date for any Todoist task it will be moved to special project called “Planned”.

Sounds like piece a cake so you decide to achieve it quick and simple using workflow software like Zapier, IFTTT or Microsoft Flow.

But if something looks easy it means that it will be not, right?


Actually there are 3 of them.

  1. There is no trigger “Todoist – when a task is updated”. Neither in Zapier, IFTTT or MS Flow.
  2. If you want to check if JSON contains some property (i.e. Date field) and/or JSON property is not empty there is no easy to use function in Zapier or IFTTT
  3. There is no action (block) that allows you to change todoist task project. Neither in Zapier, IFTTT or MS Flow.

Continue reading “How to change Todoist task project when task is updated using Flow”

August changes in Microsoft products and services

I’ve just thought it would be great to update you about MS rolling outs – only important parts that is something that you can NOW check and test if you want. I skip all “in development” updates or minor stuff. 

Below I gathered all updates from August in following categories: 
Collaboration (Office 365, Office 365 services, Sharepoint, Yammer, S4B)
Productivity (Word/Excel/Powerpoint/Outlook, Apps that you can use privately like Flow, Office Lens, ToDo, Planner etc)
Tech (Azure, PowerBI, all kind of APIs)
Continue reading “August changes in Microsoft products and services”