List View Threshold
Posted by Alex Miller - Sep 23 ’14 at 09:18
Sorry. I posted this in the ask a question section. I did not see the prior note about moving inquiry to the forum.
I have a list (list A) with cross site lookups to 5 different fields. One of the lists these fields points to has records beyond the list view threshold (list B). The fields are indexed columns both in lists A and B.
I can edit items fine using spforms.
I cannot create a new item. I get an error that I have exceeded then list view threshold.
Other lists that I have that are beyond the threshold that do not have lookups work fine to create a new item. Is there a way around this OTHER than increasing the threshold, which is not recommended?
-
Dmitry KozlovAdminMember for: 9 years 4 months 17 days
As I understood, you cannot create a new item in list B. Am I right? Does List B contain lookups? Could you provide the screenshot of the error?
-
Alex MillerMemberMember for: 8 years 4 months 16 days
I cannot create a new item in List A. I have been experimenting and as soon as i create a new item form (even with only one field on it) in spform, then I run into the threshold error and cannot create the new item. With the default sharpoint new item form i can create a new item. Is there a way around this as most of my lists have very large numbers of records.
-
Dmitry KozlovAdminMember for: 9 years 4 months 17 days
[#2]: Hi Alex,
Unfortunately, I couldn't reproduce the issue: I created lists with more than 5000 items with/without lookups, pointed lookups to lists with exceeded threshold as well. But all new custom forms worked properly. So, please, try to install SP1 for SharePoint 2013:
Server:
http://support.microsoft.com/kb/2880552Foundation:
http://support.microsoft.com/kb/2880551If it doesn't help, let's schedule a TeamViewer session.
-
Alex MillerMemberMember for: 8 years 4 months 16 days
I already am on the latest service pack - i did verify version numbers to be sure.
Even without the lookup columns and reverting back to a clean save, I can create an item when I do not use spforms, but when I define even the simplest form I get the threshold error.
I am available at any time that is convenient to you for a team viewer session. How would you liek to proceed?
-
Dmitry KozlovAdminMember for: 9 years 4 months 17 days
[#4]: Hi Alex,
May we schedule the team viewer session for today from 4pm to 7pm (GMT+4)? Please, send the connection settings to [email protected]
-
gilbert65MemberMember for: 3 years 4 months 5 days
Cross-checking rows allow you to integrate a SharePoint list with a public library into any of the sites listed on the site. I know about https://assignmentman.co.uk/ now. It provides an easy-to-use toolbox to quickly search for related items, supports thousands of thousands of features and has great ability to customize eg. softening down, refining and arranging results, adding new items to a linked list, etc.
-
gilbert65MemberMember for: 3 years 4 months 5 days
Delta Baggage
-
BulkCheapAmmoMemberMember for: 3 years 2 months 10 days
Visit Bulk Cheap ammo, we have all the top branded ammo available from different vendors. Bulk Cheap Ammo gives the best deals to gun lovers at competitive prices from top retailers. We have a different collection of ammo: 223 ammo, 22lr ammo, 22 TCM ammo, 45-70 ammo, Armscor ammo, vepr 12, 300 savage ammo more on our website.
-
Treat Assignment HelpMemberMember for: 3 years 30 daysTreat assignment help offers custom assignment online where you can get excellent writing services from our Professional writers for your assignments. Treat Assignment Help is top-notch solution for custom history assignment help online in UK. Hire best coursework writers online and send your assignment requirements, our writing experts will give you affordable pricing quotation. for more info please email at: [email protected] ! Call us at Toll Free Number Or Whatsapp at: +44 7520644027 ..!!
-
hwp1503MemberMember for: 2 years 9 months 11 days
Have you heard of reliable online writing companies? https://writepaperfor.me/ is one of those. You’ll add this website to your favorites for sure. Try it once, and you’ll never need to look for another academic help service.
Show more messages