locked
updating-sharepoint-online-list-with-more-than-100000-records-using-csom RRS feed

  • Question

  • I am having a SharePoint list with records (1,70,000). Trying to update a lookup column in the list using CAML Query. Indexing is present for both the columns Columns.

    CAML Query: oQuery.ViewXml = oQuery.ViewXml = $@"<View><Query><Where><And><Eq><FieldRef Name='DocumentUniqueID' /><Value Type='Text'>{dtExcel.Rows[i]["DocumentUniqueID"]}</Value></Eq><Eq><FieldRef Name='SequenceNo' /><Value Type='Number'>{dtExcel.Rows[i]["SequenceNo"]}</Value></Eq></And></Where></Query></View>";

    ERROR: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator


    • Moved by CoolDadTx Thursday, November 12, 2020 3:24 PM Sharepoint related
    • Edited by SPQues Friday, November 13, 2020 3:48 AM wrong forum
    Thursday, November 12, 2020 9:47 AM

All replies