Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [indexed-column]

An index on a column enables Windows SharePoint to quickly analyze the data in that column, even when working with thousands or millions of items.

Filter by
Sorted by
Tagged with
0 votes
0 answers
10 views

do we need to add SharePoint indexes if we only want to filter SharePoint items through a power apps gallery?

I have a SharePoint test list named Test, and it contain 10,000 items and I did not add any index to the SharePoint list. Now when I write this formula, I were able to filter:- Filter(Test,Num=Value(...
microsoftdeveloperdesigner's user avatar
0 votes
0 answers
19 views

In SharePoint Online can I still index columns in a library after reaching the 5000 limit?

I know you could previously extend the threshold view in SharePoint On-Premise. In SharePoint Online can I still index columns in a library after reaching the 5000 list view limit? I'm assuming there'...
Haz's user avatar
  • 365
0 votes
1 answer
88 views

I am able to filter list views using none-indexed column even if the result will be more than 5000 items

We have a term set named Customer and we have a managed metadata site column named "mmcustomer" which allow multiple selection linked to the customer term set:- and inside our document ...
John John's user avatar
0 votes
1 answer
198 views

Create an index that restarts in the beginning of each year

I have never worked with power automate or sharepoint lists in the past. We have a test request system that has a unique identifier of the following format: "PTL"-YEAR-Index. PTL is a ...
Georgije Stanisic's user avatar
1 vote
1 answer
105 views

Access files via autogenerated ID through REST API

what I'm currently doing is accessing the files in my Document Library through the REST API like this: [baseURL]/_api/Web/GetFileByServerRelativeUrl('[relativeURL]'). To collect these relativeURLs, I ...
nanoxid's user avatar
  • 13
0 votes
2 answers
378 views

Ability to filter and sort large SharePoint list using UN-indexed fields

I have a SharePoint online site collection, which contain a custom list, which contain around 51,000 items, as follow:- and currently the list contain these 3 indexes :- When i access the main list ...
John John's user avatar
1 vote
1 answer
312 views

Filtering Sharepoint Server 2013 list with multiple "OR" column view filters above the 5000 item threshold

I have a list that's butting up against the 5000 item threshold and I've added a couple of dummy items so I can experiment with the threshold before I cross over with real data. My list is structured ...
Brian Lyerly's user avatar
0 votes
2 answers
62 views

If I disable the list items to display in search results, will it have any impact on indexing?

I am having a SharePoint list with 30 columns. I have added few columns to the "Indexed Columns". But I don't want to display any list item in the search results. So I want to disable following option....
Mihir's user avatar
  • 1,546
1 vote
1 answer
218 views

SharePoint 5000 item limit threshold in sharepoint 2016

I know the issue is quite old and solved too many times, but for my case the solution should be faster and sophisticate as much as I can. The case is, my sites are migrated from SharePoint 2013 to ...
Imen Turki's user avatar
  • 2,183
1 vote
0 answers
307 views

Filtered, large list exporting

I'm currently managing a large list (just over 5000 items) and have a filtered view using indexed columns that is returning 143 items. I want to export those 143 to Excel. I'm getting an error ...
khops's user avatar
  • 31
2 votes
1 answer
90 views

Sharepoint large list filtering

Currently in Sharepiont 2010. I have a list that just went over 5000 items. I have columns indexed and all views are filtered with these indexed columns. One of the columns is a "Date and Time" type ...
khops's user avatar
  • 31
1 vote
1 answer
19 views

Items that SHOULD be showing in a view, aren't

So, I have a large list, with ~10,000 items. I have created several views that filter via indexed columns that show below the threshold amount. But I just modified one of the views, (changed the ...
Cody Smith's user avatar
0 votes
1 answer
757 views

Approaches we can have to allow indexing managed metadata columns which allow multiple values

I have the following scenario inside our sharepoint online and sharepoint on-premises 2013:- 1) We have an enterprise wiki site collection inside our sharepoint on-premises 2013. the enterprise wiki ...
John John's user avatar
0 votes
1 answer
367 views

Why we have different indexes options inside 2 document libraries on our sharepoint online

I am facing this weird issue inside our sharepoint online tenant:- I have a classic team site collection, which contain 2 docuemnt libraries inside 2 separate sub-sites. the document libraries are ...
John John's user avatar
0 votes
0 answers
534 views

Adding an Index column on my list for the "Modified" column, did not allow me to show more than 5,000 items on the list view

I am working on a SharePoint 2013 on-premises farm, and i have a document library which have 5651 documents, and i got this message that the library exceeds the threshold:- and when non-admin users ...
John John's user avatar
1 vote
1 answer
141 views

Indexing SharePoint 2013 List Columns

I have sharepoint list which has more than 40,000 item. Now the performance was very slow, So I planned to try Indexing to improve performances. When I try to add the Indexing it's returning the ...
Naveen Kaliyaperumaal's user avatar
2 votes
3 answers
3k views

Calendar View Always shows List threshold exceeded error

I am using Sharepoint 356 (office 365). I recently migrated my site from sharepoint 2007 to 365. I used to have a calendar on my homepage that had 5800 items. Office 365 view limit is 5000. So the ...
codeNinja's user avatar
1 vote
0 answers
505 views

Avoid threshold limit with view using "Or condition" on person columns

Here is my issue: I have a sharepoint 2013 list with more than 5 000 items inside. In order to avoid threshold limit I indexed several columns and created views using these columns. Most of the views ...
StarLord's user avatar
0 votes
1 answer
197 views

Indexing "Task Outcome" Column - possible?

We've just had a Workflow History list hit 5000 items - yay people are using sharepoint! A naive "Open Items" view filters on "Task Status" <> "Completed" and can be made to work with an index, ...
Fowl's user avatar
  • 167
0 votes
1 answer
60 views

Does index column help as refiners in sharepoint 2013

I have a document library in SharePoint 2013 on premise. I have added a 'Document Type' site column of Choice type in the document library. Now I will add 'Document Type' as refiners in the search ...
SharepointDEV's user avatar
1 vote
0 answers
184 views

CrossListQueryCache - get 10 items on indexed column

I have a question, basically I build a query and use the CrossListQueryCache to retrieve all the required items. Now all was good and well but there is a problem: lists are big some of them more than ...
Shkipper's user avatar
  • 2,105
8 votes
1 answer
401 views

List View Threshold (5000 items): What limitations for 5k-issue can we expect even after the "correct" columns are indexed (manually or automatically)

The infamous 5000 Threshold view limit [1, 2, 3] is a well-known struggle. One often suggested solution is to "plan ahead", and let's imagine we have done this and indexed our most important ...
eirikb's user avatar
  • 7,415
1 vote
1 answer
205 views

Do Views affect performance?

Whenever it comes to Views in SharePoint (2013 or above), the documentation offers it as a way to get around limitations (usually 5000 elements). I currently use CSOM to retrieve data from ...
Ole Albers's user avatar
0 votes
1 answer
487 views

Performance impacts while Indexing a SharePoint list in production environment

Indexing a column in a SharePoint list that's approaching the 5000 items threshold limit. Are there any expected impacts for users/apps consuming/writing to that list during index creation? Should I ...
sasfrog's user avatar
  • 314
0 votes
2 answers
141 views

Add Content to Search Index Based on Calculation of Properties in Record Center

I have a requirement to be able to search a record(document) in the record center based on a calculation. I can not store the calculated value as part of the item properties because an update of the ...
JonesEJ's user avatar
  • 58
1 vote
1 answer
839 views

Iterating SPList.GetItems(SPQuery) very slow and times out

I have a SharePoint 2013 Custom List. It has 3 MMS columns, 3 User Columns and 3 or 4 DateTime columns and a Choice Column and 1 or 2 columns of type Text. This list currently has around 2000 items. I ...
Ven's user avatar
  • 1,147
6 votes
1 answer
27k views

Difference between Index column and simple column in SharePoint?

Difference between Index column and simple column in SharePoint? What is the need of creating index column ?
user47524's user avatar
  • 393
2 votes
2 answers
6k views

REST query not working on list after 5k threshold

The following query works on one site: mysite/_api/lists/getbytitle('Listname')/items?$top=5001&$filter=IndexedCol1 le 'M' and Author/Title eq 'John Doe'&$expand=Author/Title&$select=...
Dinerdo's user avatar
  • 769
1 vote
1 answer
827 views

Indexing a column in all content types that use it

I'm wondering if it's possible to add an Index to a column in every Item of a specific Content Type. I'm still having issues with the List View Threshold in an Intranet Site Collection so that CQWP's ...
N03L's user avatar
  • 33
3 votes
1 answer
3k views

Powershell - How to get index columns for a given list

For some strange reasons I can't get to the Index page. It gives me following error. Is there a way to get the index columns via powershell? http://local.intranet.net/sales/_layouts/IndexedColumns....
Moa's user avatar
  • 31
7 votes
1 answer
11k views

Find an item, search multiline text

I have a SharePoint list that contains multiple fields. One of which is a multiline "Notes" field that is not included with the default view. When I perform a search on the list, I can search on any ...
Linuxx's user avatar
  • 173
1 vote
1 answer
568 views

Search ignoring all numeric search

We are running SharePoint 2013 and are trying to use the people search to find employees by their employee ID number. The column has been indexed in SharePoint and if we search using the syntax ...
Peter's user avatar
  • 347
0 votes
1 answer
420 views

Ordering Indexed Column on SharePoint lists

I have a SharePoint lists with 10 000 items, and someone else has increased the limit to 250 000 (Crazy right?). What I have done is I've indexed the Changed By Date, and made views that is sorting ...
williamwmy's user avatar
1 vote
1 answer
3k views

How create an index based on an internal list field?

I have a huge library and its documents don't have any metadata. They have only the name (FileLeafRef) filled (and FileRef -> file's path automatically filled). I'm trying to update their metadata (...
Douglas Mendes's user avatar
0 votes
2 answers
4k views

How to filter a people/user column that has been indexed

I have a long list (more than 5,000 items) and due to view threshold I indexed some columns. One of them is a people/user column. When I want to create a view that filters on the User column, then it ...
AymKdn's user avatar
  • 1,189
5 votes
3 answers
11k views

Should i index all columns in a list?

I have a screen where the user will be querying using all columns in the list. Should i index every column. What are the rules around this? Would there be any performance problems?
user1786107's user avatar
1 vote
1 answer
6k views

Column being indexed - cannot create site from custom template

I created several content types in the content type hub. Next, I have created a site out of the default team site with several document libraries and lists on my site which utilize these content types ...
Boris's user avatar
  • 1,410
3 votes
1 answer
4k views

Indexing sharepoint lists with ps

I would like to index a column in a list with powershell. I have a problem, when i retrieve the list how can i set what field should be put to index? Is there a special command, can anyone provide me ...
Shkipper's user avatar
  • 2,105
1 vote
2 answers
236 views

Is it possible to update the searchindex for only one item?

Is it possible to update the searchindex for only on specific item. I'm search some tasklists through keywordsearch and showing them in a webpart. Then I have a custom action which changes the status ...
Steffen Schindler's user avatar
11 votes
6 answers
24k views

SharePoint 2010 Column Index on Large List

I have a custom list with more than 5000 items. This article: http://msdn.microsoft.com/en-us/library/ff798465.aspx (the last section, "How Does Indexing Affect Throttling?") states: "For ...
Efil4zaggin's user avatar
10 votes
4 answers
6k views

SharePoint 2010 CAML Query fails when indexed columns used

I have an SPQuery that has been working fine until my list hit 500 items: q.Query = "<Where><Eq><FieldRef Name='DefectID' /><Value Type='Counter'>" + DefectID + "</Value>...
Callum's user avatar
  • 146
2 votes
1 answer
2k views

When will an index be created for a column?

I have a SharePoint 2007 List and it has almost 10 columns and 1000+ items, I want to enable the Index for a specific column is in the list. If I enable the index now then when it will create an index ...
Karthikeyan's user avatar
  • 2,548