I am getting list view threshold although all the columns involved in the filter and Sort are indexed columns

Question

I have the Workflow tasks list which contain 42,613 items. and inside a list view i have those filtering and sorting (where all the columns are indexed):-

but when we access the list view we got this threshold error:-

Although those columns involved in the filter and sort are indexed as follow:-

any advice on this please? how we can overcome the threshold error?

Thanks

Answer 1

Hi @john john ,
It is suggested that you can separate the first condition in Filter into two views, one setting [is greater than] and the other setting [is equal to], so as to reduce the number of items in the view.
Or you can try the follow methods:

For more information, please refer to:
https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-b8588dae-9387-48c2-9248-c24122f07c59#:~:text=Go%20to%20Application%20Management%20%3E%20Manage,list)%20to%20a%20reasonable%20value.
https://www.sharepointdiary.com/2017/02/list-view-threshold-in-sharepoint-online-faq.html
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
*
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.