Unanswered

Excessive Load Time Issues with Gallery

(2) Share

Report

Posted on by anjiyu

I have been having an issue where there is sometimes excessive load time whenever I switch between galleries using the radio component (seen in attachments). The radio dictates the "visible" property of the different galleries & gallery filters. The page will freeze, and the little loading dots will appear at the top of the screen.

The database used is SharePoint lists and the code and database schema are also attached. I am struggling to figure out if there is a way to optimize the code or if it is simply a limitation of PowerApps/SharePoint Lists. I am also trying to avoid using "Collect" so that I don't have to patch both to the database, then refresh&recollect the collection upon changes, but if it massively improves speed, I am willing to reconsider.

(still really wish that there was a way to do selective refresh by line item - would solve a lot of runtime issues while still allowing data to be as recent as possible)

Categories:

Building Power Apps

Gallery Code.txt

PowerApp Gallery.png

Database Schema.png

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi

So you have 2 galleries but you are making them visible/invisible depending on which one is selected by the Radio button.

What triggers the galleries to refresh?

1) Have you made sure that your Columns Explicit is on so it only grabs what you want? And that you have Views setup to limit data width?

2) I am not sure why swapping between Galleries is refreshing it. I don't see any details on how the 2 galleries work together

3) If you want to refresh a single item, Use a LookUp to grab it and Patch the Collection, don't grab them all again.

4) If the process of making them visible invisible is making them refresh, it shouldn't but if it does then do this

a) Don't make them invisible

b) Make it so that the Radio button switch determines which one is on the screen and which one isn't

c) Make them both be off the screen but 100px or something on the X Axis

Then when you flip the Radio, dont change whats visible, change the X position, so that the one you see is not OFF the screen and the other is on.

Do this back and forth. Faster and won't refresh.

Was this reply helpful? Yes No
Verified answer

anjiyu 15 on at

Like (1)

Report
@FLMike no idea why they took away the ability to respond to specific responses

ECS is automatically turned on and I don't have it disables, unless you are referring to using ShowColumns(). Also not sure what you mean by "Views setup to limit data width".

It didn't make sense to me either until I realized that the issue was something else entirely. I had another gallery with a calculated label. That label calculation was dependent on the selected gallery à la "if radio.selected.value = Log, countrows(filter(log))". I was originally thinking that it was due to the manner in which I was using the With() function to calculate the galleries
With( { withLog: Sort, filter, and AddColumn "ID-"&ID# to SharePoint List "Log" , withDetails: Sort & filter SharePoint List "Details", withActions: Sort & filter SharePoint List "Actions", }, Filter( Search( AddColumns( withLog, columnPN: Concat values found in a column of Details using 1-to-many relation from withLog to with Details columnActions: Concat values found in a column of Actions using 1-to-many relation from withLog to with Actions ), filter specific columns by text input ), filter by various other controls relating to specific columns ) )

While that would allow a collection to refresh a specific value, I would need to still double my code - once to update the database and another to update my collection. Also I prefer to recollect just in case another user made changes to the database as well.

I did try this prior to figuring out the real issue. I may end up using this for something else in the future

Thanks!

Was this reply helpful? Yes No
Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

Nice I am glad you have it how you need it.

Sorry for the delay the spammer came in.

If you have any follow ups feel free to ping me.

Was this reply helpful? Yes No