cancel
Showing results for 
Search instead for 
Did you mean: 

AMFTF: Showing all SharePoint Online list items in a gallery

In the PowerApps community, from time to time a question is asked about how to exceed the item limit (500 by default, minimum 1 and maximum 2000) for a SharePoint list.

 

When I see this, I often wonder if that person really wants their fellow employees to scroll for hundreds of items in a gallery? I personally don't and prefer creating a solution with filtering, sorting and if possible searching.

 

But is it possible? Yes, it is possible to scroll through all items from a SharePoint list in a gallery. What you need to know is that you:

  1. must add the data source directly to the gallery.
  2. can only use functions which are delegable for that data source.

With these restrictions, even a formula like 

SortByColumns(Filter('SPList', Status = "Open"), "Modified", Descending)

will show all items.

 

What has been "said" above also counts for other data sources like SQL Server and the Common Data Service. With SQL Server even more functions are possible.

 

References:

Comments

@Rick72 can you help me in my scenario please? I need to filter by date on a SP list...

https://powerusers.microsoft.com/t5/General-Discussion/Filtering-with-datepicker-from-a-SP-list-gall...

 

 

Hi @AleChoski,

 

Sorry for the late reply. Date columns can't be delegated in SharePoint. Check this blog post for more info.

 

Robot Happy Rick

Meet Our Blog Authors
Labels