Announcements
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.
@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."
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 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
We did a workaround by sorting the table in excel before it gets to sharepoint. Then delegating the filter.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 397 Super User 2026 Season 2
Mohsin Ali 354
WarrenBelz 232 Most Valuable Professional
