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?
Filter(SharePointList, FieldID = VarFromPA)
Gallery must be used to view items AND edit them
Gallery may return 0 to 100+ items (from approx. 20k list)