I am facing the error below, how to fix it? This is office 365 SharePoint list which has more than five thousand items on it. I am using U2U tool to get data :

enter image description here

any suggestion will be appreciated.

  • Use filters in a way that it will return less than 5000 items. Jul 28 at 8:37
  • I used already Status ='New', which will get less than 100 item!
    – HAJJAJ
    Jul 28 at 9:32

1 Answer 1


You can avoid the list item threshold by indexing the affected column, more information can be found here:

Manage large lists and libraries

  • all these has been applied and still getting the same issue
    – HAJJAJ
    Jul 28 at 9:37
  • Is the column you're using for the query a supported column for indexing? Jul 28 at 9:42
  • no but I need to filter by it
    – HAJJAJ
    Jul 28 at 13:12
  • I'm guessing the column you're using is a multi-value choice column, rather than an ordinary single value choice column? Can't you use a column type which is supported by indexing? If not, there isn't much that can be done to help here. Jul 28 at 13:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.