web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : IrakIHVJtYYaEIP+QRlB1g
Power Apps - Building Power Apps
Answered

Workaround for Delegating Filter and Sort Large Data Set

Like (0) ShareShare
ReportReport
Posted on 10 Jun 2020 12:27:22 by 51

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. 

  • Verified answer
    ag12 Profile Picture
    51 on 15 Jun 2020 at 18:19:38
    Re: Workaround for Delegating Filter and Sort Large Data Set

    We did a workaround by sorting the table in excel before it gets to sharepoint. Then delegating the filter. 

  • mdevaney Profile Picture
    29,987 Moderator on 10 Jun 2020 at 12:56:07
    Re: Workaround for Delegating Filter and Sort Large Data Set

    @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."

  • JayMagness Profile Picture
    1,663 on 10 Jun 2020 at 12:33:53
    Re: Workaround for Delegating Filter and Sort Large Data Set

    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

  • mdevaney Profile Picture
    29,987 Moderator on 10 Jun 2020 at 12:31:41
    Re: Workaround for Delegating Filter and Sort Large Data Set

    @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."

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.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete