cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Olivia_Dudley Advocate I
Advocate I

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

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
4 REPLIES 4
DanielaHo Advocate III
Advocate III

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

I am curious about this as well..

Olivia_Dudley Advocate I
Advocate I

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

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

cgreen1983 Helper II
Helper II

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

Any update on this from Microsoft?

TopShelf-MSFT Community Champion
Community Champion

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

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,

 

@TopShelf-MSFT 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,177)