SharePoint Online - List View threshold issue RRS feed

  • Question

  • Hi

    We have list "Invoice" on SharePoint 365. Recently we reached 5000+ line items in this list. We are doing below operations on that list which are getting failed now because of the list view threshold:

    1. A desktop based .NET application modifies the list items as per the status of the invoices. CAML query is getting failed here.

    2. There is another list on the same site "Query" which has lookup column from "Invoice" list which is not working now.

    3. We have some JQuery scripts on new item page of "Invoice" list where we are again using some CAML queries on "Invoice" list.

    This SharePoint site is in production. This error has become very critical issue for us.

    Please suggest.

    Thanks in advance.

    Best Regards, Somnath

    Saturday, February 13, 2016 8:27 AM


  • Column which you are using to fetch in caml query make tham as index column. Than caml query work. it works in my case.

    Try to fetch data from Large list, in chunks i mean hops. i.e. 500 each in loop.

    http://www.abdulazizfarooqi.wordpress.com Abdul Aziz Farooqi [BizTalk & SharePoint Consultant] MCPD Web & MCPD SharePoint 2010

    Saturday, February 13, 2016 2:04 PM