Using NBS search, showing columns but no data in them

Question

Using NBS search, showing columns but no data in them

Charlie Martharper 385

Hi!

I am working in a SharePoint On-premise, and then I added the nbs search (external app) to search files in the libraries. The thing is that, when looking for the files, the files appears correctly but the columns are blank.

Someone knows what is going on? What should I change in the settinhs of it?

This is the NBS search term without any information in the columns:

User's image This is the library with the same columns in the nbs, but filled.

User's image

1 answer

Your answer

Answer 1

Steven-N 21,165 Microsoft External Staff Moderator

Hi Charlie Martharper

Thank you for reaching out to Microsoft Q&A forum

The root cause is almost certainly that the Managed Properties for "Tipus Document" and "Paraules Clau" are either missing or not set as Retrievable in the Search Schema. Once properly configured and a full crawl is completed, the NBS Search results should display the column values correctly.

In this situation, could you please try the 3 steps below and get back to me with the results:

Step 1 – Verify Crawled Properties exist

Go to Central Administration → Manage Service Applications → Search Service Application → Search Schema
Click on Crawled Properties
Search for your column names ("Tipus Document", "Paraules Clau"). They will typically appear with an ows_ prefix, such as ows_Tipus_x0020_Document or ows_Paraules_x0020_Clau

If they do not appear, run a Full Crawl first (Central Administration → Search Service Application → Content Sources → Start Full Crawl), then check again

Step 2 – Map Crawled Properties to Managed Properties

In the Search Schema, go to Managed Properties
Search for your column names. If no managed property exists for them, click New Managed Property and create one for each column
Set the Name and map it to the corresponding Crawled Property (e.g., ows_Tipus_x0020_Document)
Please note that to enable Retrievable, this is the most critical setting; without it, search results will not return the column values

If managed properties already exist, verify that Retrievable is checked and mapped to the correct crawled property

Step 3 – Run a Full Crawl

After any changes to the Search Schema, you must run a Full Crawl for the changes to take effect then update the NBS Search web part configuration

Hope my answer will help you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Steven-N 21,165 Reputation points Microsoft External Staff Moderator

2026-02-16T05:02:45.6466667+00:00

Hi Charlie Martharper

It has been a while and I am writing to see how things are going with this issue.

Have you had a chance to check the replies provided?

Any update would be appreciated.
Charlie Martharper 385 Reputation points

2026-02-17T07:20:37.05+00:00

@Steven-N Hi!

Could you please, add some screenshots? It help me to do the steps. Thank you a lot
Charlie Martharper 385 Reputation points

2026-02-17T07:53:02.2033333+00:00

Hi @Steven-N

I added that into the refinablestrings. Those has both retrieve enabled but it doesn't let me enable the "search" is it necessary? Those are both columns I have there to show. I will try to crawl now and reindex.
Charlie Martharper 385 Reputation points

2026-02-17T09:07:39.5366667+00:00

@Steven-N

Hi, one user told me that I have to take ows_taxID of the columns:
Charlie Martharper 385 Reputation points

2026-02-17T11:27:51.9566667+00:00

@Steven-N

Did both thing and still didn't appear :(
Steven-N 21,165 Reputation points Microsoft External Staff Moderator

2026-02-20T14:53:37.54+00:00

Hi Charlie Martharper

Apologize for the delayed response

Please allow me some time to gather the necessary information. I will get back to you as soon as possible.
Steven-N 21,165 Reputation points Microsoft External Staff Moderator

2026-02-23T04:22:47.14+00:00

Hi Charlie Martharper

Can you tell me if you're using multiple-choice or single-choice for that affected column?

I've done some tests, and if I use single-choice, the data values display normally.

Regards
Charlie Martharper 385 Reputation points

2026-02-23T07:10:12.1266667+00:00

Hi @Steven-N

One of them is multiple-choice and the other is single-choice. None of them appear, but it is because I cannot get the refinablestring which the column is created with. Something is wrong with that. If I change the column type to single text, will it work?
Steven-N 21,165 Reputation points Microsoft External Staff Moderator

2026-02-24T06:28:22.17+00:00
Hi Charlie Martharper

Yes, changing the column to "Single line of text" is the easiest data type for SharePoint Search to index. However, changing the column type on an existing library will remove the dropdown choice functionality for your users and could affect existing metadata.

My recommended next steps for you:

Go to your mapping for the RefinableStringXX and ensure it is mapped to the standard ows_[ColumnName] crawled property, not the ows_taxId_ one. Both multiple-choice and single-choice mapping will work fine with RefinableString properties since they naturally support multiple values.

Go to your Document Library Settings > Advanced Settings > Reindex Document Library.

Run a Full Crawl from Central Administration.

Please let me know if mapping the standard ows_ property and running the Full Crawl brings the data into your NBS Search columns.

Regards

Share via

Using NBS search, showing columns but no data in them

1 answer

Your answer