Large List SharePoint Delegation (10k, 20k+)

[Olivia_Dudley]

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

[DanielaHo]

I am curious about this as well..

[Olivia_Dudley]

FYI The columns being pulled into my gallery are all indexed on the SharePoint list. I would appreciate any help!

[Anonymous]

Any update on this from Microsoft?

[Anonymous]

Hi All,

Can you please review this blog post and advise if it is helpful? 

https://michalguzowski.pl/how-to-overcome-500-items-limit-in-powerapps/

Thank you,

@Anonymous