SharePoint list >10k (soon to be over 20k) is being filtered and returned to a gallery. This filter does not return any items after the first 10k. Please help me get around this 10k limit. According to this I should be able to search the entire list (SP lists & libraries have a limit of 30 million items) using delegable functions. There is no mention of a top 10 thousand limit. Is there something I am missing? ...And more importantly how do I filter my almost 20k list?
Formula used:
- Filter(SharePointList, FieldID = VarFromPA)
Important criteria:
- Gallery must be used to view items AND edit them
- Gallery may return 0 to 100+ items (from approx. 20k list)
- Gallery is filtered based on one field
