Workaround for Delegating Filter and Sort Large Data Set

Like (0) Share

Report

Posted on 10 Jun 2020 12:27:22 by ag12

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.

I have the same question (0)

Summarized by AI

All responses (4)

Answers (1)

mdevaney 29,987 Moderator on 10 Jun 2020 at 12:31:41

Like (0)

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

Was this reply helpful? Yes No
JayMagness 1,663 on 10 Jun 2020 at 12:33:53

Like (1)

Report

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

Was this reply helpful? Yes No
mdevaney 29,987 Moderator on 10 Jun 2020 at 12:56:07

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

ag12 51 on 15 Jun 2020 at 18:19:38

Like (0)

Report

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.

Was this reply helpful? Yes No