Answered

PreFiltering performance

(0) Share

Report

Posted on by abc3

207

Hi All , Because of the 2000 limitation so I have a per-filtering collection loading when the button on click. Have any method can improve the performance on the collection loading.

ClearCollect(ItemDetailFilter1, Filter(ItemDetails, Index <=2000),Filter(ItemDetails, Index >2000 && Index <=4000),Filter(ItemDetails, Index >4000 && Index <=6000),Filter(ItemDetails, Index >6000 && Index <=8000),Filter(ItemDetails, Index >8000 && Index <=10000),Filter(ItemDetails, Index >10000 && Index <=12000),Filter(ItemDetails, Index >12000 && Index <=14000),Filter(ItemDetails, Index >14000 && Index <=16000),Filter(ItemDetails, Index >16000 && Index <=18000),Filter(ItemDetails, Index >18000 && Index <=20000),Filter(ItemDetails, Index >20000 && Index <=22000),Filter(ItemDetails, Index >22000 && Index <=24000),Filter(ItemDetails, Index >24000 && Index <=26000),Filter(ItemDetails, Index >26000 && Index <=28000),Filter(ItemDetails, Index >28000 && Index <=30000));
ClearCollect(ItemDetailFilter,SortByColumns(SortByColumns(GroupBy(ItemDetailFilter1,"cr5e8_style","cr5e8_autotagpriceact","cr5e8_jaxgoldcontentid","cr5e8_jaxstonetypedescriptionen","cr5e8_jaxstonetype2descriptionen","cr5e8_itemname","cr5e8_jaxstonetypeid","cr5e8_itemtype","cr5e8_rank","cr5e8_ranklast6","cr5e8_itemstyle","cr5e8_availordered","cr5e8_mainstonetype","cr5e8_totalstonewt","cr5e8_totalsidediawt","cr5e8_centerdiamondwt","Group"),"cr5e8_style",SortOrder.Ascending), "cr5e8_itemtype",SortOrder.Descending));

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,756 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @abc3 ,

Assuming here Index (not a good name as it is a Reserved Word for a Power Apps Function) is a sequential numeric column, then try this

Clear(ItemDetailFilter1); With( { wSets: With( { wLimits: With( { wLimit: Sort( ItemDetails, Index, Descending ) }, RoundDown( First(wLimit).Index / 2000, 0 ) + 1 ) }, AddColumns( RenameColumns( Sequence( wLimits, 0, 2000 ), "Value", "LowID" ), "HighID", LowID + 2000 ) ) }, ForAll( wSets As MaxMin, Collect( ItemDetailFilter1, Filter( ItemDetails, Index > MaxMin.LowID && Index <= MaxMin.HighID ) ) ) );

however collecting 30k records is never going to be anything but a slow process and subsequently any queries / manipulation of this is going to be also slow. For the second part, you can combine the SortByColumns, but other than that, if you want that structure, what you have would be the way to do it.

ClearCollect( ItemDetailFilter, SortByColumns( GroupBy( ItemDetailFilter1, "cr5e8_style", "cr5e8_autotagpriceact", "cr5e8_jaxgoldcontentid", "cr5e8_jaxstonetypedescriptionen", "cr5e8_jaxstonetype2descriptionen", "cr5e8_itemname", "cr5e8_jaxstonetypeid", "cr5e8_itemtype", "cr5e8_rank", "cr5e8_ranklast6", "cr5e8_itemstyle", "cr5e8_availordered", "cr5e8_mainstonetype", "cr5e8_totalstonewt", "cr5e8_totalsidediawt", "cr5e8_centerdiamondwt", "Group" ), "cr5e8_style", SortOrder.Ascending, "cr5e8_itemtype", SortOrder.Descending ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
abc3 207 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Thank you for your help. I trying your code but after I copy code to my powerapps it having error
I found out why having the error thank your help