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 b...
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.
