Learn What IT Pros Need to Know About Windows 11 - August 26th at 1 PM ET! Learn What IT Pros Need to Know About Windows 11 - August 26th at 1 PM ET!
SharePoint|SharePoint Online

The Must Have Tool While Working with Search and SharePoint Online

One of my main frustrations with the search experience in SharePoint Online is the indexing process. Especially with managed properties. I am referring to the inability to check if a managed property is filled with a value. Let me provide you with a real-world example. We have developed a series of apps for SharePoint Portals. One of these is the Highlighted News app:

The app contains an option to display a topic (e.g. security). These topics are assigned to news posts by using a site column:

Sponsored Content

Read the Best Personal and Business Tech without Ads

Staying updated on what is happening in the technology sector is important to your career and your personal life but ads can make reading news, distracting. With Thurrott Premium, you can enjoy the best coverage in tech without the annoying ads.

The Highlighted app, making use of SharePoint Search, needs to connect a managed property to the site column to display the topic. There is one major challenge! After assigning a topic, we have no idea when the managed property is actually connected to the correct topic. This is totally depending on a magical timer job that refreshes the search index. There is no menu where we can check if the index is refreshed and our managed property contains the correct topic. Although Microsoft really improved the speed, and quality, of the indexing process within SharePoint Online, there isn’t a 100% guarantee it works and no menu to check the index.

This is why I highly recommend downloading the SharePoint Search Query Tool. This tool, created by the awesome Mikael Svenson, allows you to check the search properties of your SharePoint content or people. This way, you know if a managed property is actually connected to a value.  Let me show you how this works by assigning a topic to a brand new news post:


The Highlighted app makes use of the managed property ‘RefinableString100’ to display a topic. After we publish our news post, we have no idea if the topic is actually assigned to the managed property. This is where the SharePoint Search Query Tool steps into action. We need to login first:

Once we logged in, we search for the title of our news post, apply the properties button and enter our refinablestring100:

Now we can see the magic happens by clicking on the run button:

Awesome! We can see the correct topic! Let’s take a look at our Highlighted app:

The SharePoint Search Query Tool is a true life saver! I have been recommending the tool to all my colleagues, and new colleagues, for many years. Everyone truly loves the tool. Don’t wait and go download the tool now!

Related Topics:


Don't have a login but want to join the conversation? Sign up for a Petri Account

Comments (0)

Leave a Reply

Register for Advanced Microsoft 365 Day!

GET-IT: Advanced Microsoft 365 1-Day Virtual Conference - Live August 24th!

Join us on Tuesday, August 24th and hear from Microsoft MVPs and industry experts about how to take advantage of Microsoft 365 at a technical level and dive deep into the features and functionality that will make your environment more secure and compliant.


Sponsored By