Hello All,
I am using a share point list with over 20,000 lines to populate my gallery. To overcome the data limits of power apps the program is currently delegating a filter function to share point. However I also need to add a sort function to these items. According to Microsoft documentation the Sort function can only be delegated without other operators or functions. One thing I tried was creating a second gallery populating from the first(which populated from the filtered share point list). This didn't work because it didn't account for the filters. If anyone has ideas or experience in sorting and filtering large data sets any knowledge is appreciated.
We did a workaround by sorting the table in excel before it gets to sharepoint. Then delegating the filter.
@ag12
You could also watch this Youtube video by Daniel Christensen about working with large SP datasets (44,000 rows).
Link to Youtube Video:
https://www.youtube.com/watch?v=IvTiAanB3Cs
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi,
Depending on the data I setup what I call a chunking process. When using PowerApps and SharePoint there are limits but there is always ways around it. If designed correctly you can get good response and also go over the limits.
It is much easier if we can get on a teams session to explain to you and see what you are trying to accomplish.
In cases like this 4 eyes is better then 2 eyes 🙂
send me an email if you like jay@research-Nest.com
@ag12
Are you trying to SORT this list on multiple columns? If yes, simply do this:
Sort(Sort(Sort(your_datasource_name, Column1, Ascending), Column2, Ascending), Column3, Ascending)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2