Answered

Load the gallery fast with datasource of 500 items

(1) Share

Report

Posted on by Iantaylor2050

531

I need to load my powerapps gallery fast where the datasource SharePoint list contains hardly 500 items. Out of 500, i am hardly showing 100 items in gallery based on filter conditions.

If i scroll down, the gallery spinner runs and it takes a while for remaining items to load. Is there anyway i can improve my loading speed?

Gallery Items

If(
    myfavselected,
    Filter(
        Items,
        ID in Filter(
            Favorites,
            Title = User().Email
        ).CatalogID && Item_Status = "Ready for Display" && !IsBlank(AuctionEventID) && checkBoxVal
    ),
    Filter(
        Items,
        (Len(searchText) = 0 || searchText in 'Item Name' || searchText in Description || searchText in 'Unit Price' || searchText in 'Item Category') && (IsBlank(ComboBox6.SelectedItems) || ('Item Category' in Concat(
        ComboBox6.SelectedItems,
        Value
    ))) && (IsBlank(ComboBox3.SelectedItems) || ("Under $50" in Concat(
            ComboBox3.SelectedItems,
            Value
        ) && Start_Value >= 1 && Start_Value < 50) Or ("$50 - $100" in Concat(
            ComboBox3.SelectedItems,
            Value
        ) && Start_Value >= 50 && Start_Value < 100) Or ("$100 - $200" in Concat(
            ComboBox3.SelectedItems,
            Value
        ) && Start_Value >= 100 && Start_Value < 200) Or ("Above $200" in Concat(
            ComboBox3.SelectedItems,
            Value
        ) && Start_Value >= 200)) && Item_Status = "Ready for Display" && !IsBlank(AuctionEventID) && checkBoxVal && LookUp(
            Auction,
            Status = true,
            Start_Date
        ) <= Now()&& LookUp(
            Auction,
            Status = true,
            End_Date
        ) >= Now()
    )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi @Iantaylor2050,

I am not surprised that is taking a while - first we can seperate the Delegable bit and also move all the calculations out of the filter. I am wondering however what exactly you are doing with the last two items adding another list filter into the equation.
If( myfavselected, With( { _Data: Filter( Items, Item_Status = "Ready for Display" ), _Cat: Filter( Favorites, Title = User().Email ) }, Filter( _Data, ID in _Cat.CatalogID && !IsBlank(AuctionEventID) && checkBoxVal ) ), With( { _Data: Filter( Items, Item_Status = "Ready for Display" ), _CB3: Concat( ComboBox3.SelectedItems, Value ), _CB6: Concat( ComboBox6.SelectedItems, Value ), _Status: LookUp( Auction, Status ) }, Filter( _Data, ( Len(searchText) = 0 || searchText in 'Item Name' || searchText in Description || searchText in 'Unit Price' || searchText in 'Item Category' ) && ( IsEmpty(ComboBox6.SelectedItems) || 'Item Category' in _CB6 ) && ( IsEmpty(ComboBox3.SelectedItems) || "Under $50" in _CB3 && Start_Value >= 1 && Start_Value < 50 ) || ( "$50 - $100" in _CB3 && Start_Value >= 50 && Start_Value < 100 ) || ( "$100 - $200" in _CB3 && Start_Value >= 100 && Start_Value < 200 ) Or ( "Above $200" in _CB3 && Start_Value >= 200 ) ) && !IsBlank(AuctionEventID) && checkBoxVal && _Status.Start_Date <= Now() && _Status.End_Date >= Now() ) ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report

Hi @Iantaylor2050,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No