Forum Discussion
Finding an item when list has over 5000 items using SPD 2013 Workflow
Using SharePoint online.
I'm using an IF statement to see if an item exists in a list with 50k+ items as follows:
If Archived Repair Ticket 2:ID not equals 0
This works in SPD2010 but in SPD2013 the workflow hangs giving the error message that the list limit has been exceeded.
Any ideas how to make this work in SPD2013?
4 Replies
Technosapian you can try changing the limit in Central Administration.
(Note that if you’re on a shared hosting plan, then this option is not available for you)
Navigate to Central Administration. You can get to it by going to the SharePoint server and searching for "Central Administration" under the start menu.
Go to Application Management > Manage Web Application and click on your web application to select it.
In the Ribbon, click on General Settings drop down and choose "Resource Throttling".
In the "List View Threshold", increase the value by 2 fold and click OK.
Check the list now. Keep increasing the threshold if the error persists.This is on the Microsoft SharePoint shared site so I have no admin rights to adjust the view limit.
Checking the SharePoint 2013 threshold limits (https://docs.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits) we can see that the limit for "Maximum list size for workflow lookups to non-indexed fields" is 5k items. You're effectively hit a list view limit. In the past I've gotten around this by: -
- Indexing the columns that I want looked-up
- Running the workflow with elevated privileges
- Amending the view settings so that less than 5k items are returned
Steven Andrews Thank you for the reply.
- I have the column indexed.
- I'm the creator of the site with as elevated as it gets rights.
- The return is for either 1 or 0 items.
The weird thing is that this works in a SPD2010 workflow but chokes on the SPD2013 workflow.
