0

After 5000 items threshold is exceeded, custom new form stops working even though I did index a couple of columns, and views are working fine, so as default the new form. But when I want to open the custom new form, I get an error.

Read somewhere it might be a problem with the query which should be changed, but I can't find a concrete explanation or example.

Error:

This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator.

To view items, try selecting another view or creating a new view. If you do not have sufficient permissions to create views for this list, ask your administrator to modify the view so that it conforms to the list view threshold.

  • Could you please share the error you get in your post? This way, it will be easier for others to help you find a solution. – Marc-André Jan 15 '18 at 15:22
  • Does the custom New form use JavaScript to query the list? If so, is that query trying to return more than 5000 items? – Mike Smith - MCT - MVP Jan 15 '18 at 18:59
  • I pasted information of error message. No, there is no js code in new form for now. – Danilo Jan 16 '18 at 9:10
0

You can Increase the List Threshold to fix this issue or use indexed columns , Please see the below article for more info:

https://social.technet.microsoft.com/wiki/contents/articles/37426.sharepoint-troubleshooting-this-view-cannot-be-displayed-because-it-exceeds-the-list-view-threshold-5000-items-enforced-by-the-administrator.aspx

  • Thank you for answer, but please read my question before posting. I already indexed columns. View are working fine, only new form is making problem. I don't want to increase threshold as that is not a solution. – Danilo Jan 16 '18 at 10:33
0

Solved it.

So what was necessary to be done in form was to add part of code in query. This was original code:

<Query>
  <Where>
   <Eq>
    <FieldRef Name="ContentType"/>
    <Value Type="Text">Item</Value>
   </Eq>
  </Where>
</Query>  

What I did was adding additional part of query

<Query>
  <Where>
   <And>
    <Eq>
     <FieldRef Name="ContentType"/>
     <Value Type="Text">Item</Value>
    </Eq>
    <Eq>
     <FieldRef Name="name of one of indexed columns"/>
     <Value Type="Text">One of its values</Value>
    </Eq>
   </And>
  </Where>
</Query>

Additional condition was necessary so I get only couple of values and not whole list of 5000+ items. Instead of < and > you should put &lt; and &gt;. " is &quote; in new form.

Explanation I found here in similar topic.

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.