sharepoint - Search for more columns of a lookup - Stack Overflow

admin管理员组

文章数量:1356290

My scenario is:

• I have created a list, let's call it Customers, with a few columns, say CustomerID, CustomerName and CustomerTaxNr.
• Then there's the Document Library in which I've created a column of type Lookup, getting data from the Customers list. It shows one of the fields, say CustomerID, and I've done the "add additional columns from the list" to show the rest of the fields.

So far so good. Every document in the library is tagged with a CustomerID and shows the CustomerName and CustomerTaxNr as well.

But then we get to search.

With this configuration, users can search for CustomerID and find the relevant documents. But searching for customer name or tax nr returns nothing.

I can change the column to CustomerName (and add the others as additional); then they can search for the name but not the id or the tax nr.

Any idea how can I make search work for all the columns of the list?

My scenario is:

• I have created a list, let's call it Customers, with a few columns, say CustomerID, CustomerName and CustomerTaxNr.
• Then there's the Document Library in which I've created a column of type Lookup, getting data from the Customers list. It shows one of the fields, say CustomerID, and I've done the "add additional columns from the list" to show the rest of the fields.

So far so good. Every document in the library is tagged with a CustomerID and shows the CustomerName and CustomerTaxNr as well.

But then we get to search.

With this configuration, users can search for CustomerID and find the relevant documents. But searching for customer name or tax nr returns nothing.

I can change the column to CustomerName (and add the others as additional); then they can search for the name but not the id or the tax nr.

Any idea how can I make search work for all the columns of the list?

• search
• sharepoint
• sharepoint-online

Share Improve this question Follow edited Mar 31 at 9:03 jonrsharpe 122k3030 gold badges268268 silver badges475475 bronze badges asked Mar 31 at 9:01 Jim AndrakakisJim Andrakakis 18722 gold badges33 silver badges1010 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Ok, answer was given in MS forums:

1. Manually add index: Go to library settings > Indexed columns > Manually add the lookup column, then

2. Go to Site settings > site information > view all site settings > Search and Offline Availability > Reindex the site.

After reindexing (which can take some time, depending on volume) search works.

本文标签： sharepointSearch for more columns of a lookupStack Overflow