Hello all,
I have developed maybe 5 or 6 different power apps from scratch this year for various purposes, and have not had any performance issues thus far. I have used a variety of gallery, form setups, nested galleries, and usually have a lot of controls on each of my screens, yet encounter little to no issues until now.
Now, I have built a new app mid-way through creating it, I suddenly started getting atrocious performance issues to the point of barely being able to work. I tried switching browsers at first with a bit of success and then tried splitting the app into two separate screens, but am still getting outrageously bad issues when I publish and then play the app. It is manageable when I use the preview feature within the actual Power Apps edit screen, but actually playtesting the app has resulted on the second screen failing to load a gallery with only 4 items after like 5 minutes...
Now within the app checker it does give a performance warning for this page saying that it has too many controls, but I have received that same warning on other apps I have built and there is literally no noticeable performance drop-off, whereas this app appears to be quite unplayable.
The app does have a lot of controls but they are all fairly simple text and input controls that shouldn't be causing heavy load times. I have also built almost this exact accordion gallery setup in another app with no issues but this one is somehow causing enormous loading problems. Also, it seems to be the nested gallery which is the source of the anguish because even in the stuck loading state in the above screenshot, I am able to click the "+ New" and get an instant response from the page, whereas the gallery is stuck loading for eternity.
I am baffled by this because compared to other formulas I have used in other galleries, these ones are very short and simple...
First I have my outer accordion gallery which just holds the expandable button controls to expand and see the invoice list, and that has this formula in its Items field:
Sort(
Filter(
'Event Tracker',
Event.Value = selectedEvent,
Category.Value <> "Invoice"
),
'Start Date',
SortOrder.Ascending
)
Then, within that gallery there is a second gallery that lists all of the invoices corresponding to those dates/event parts and it just holds this formula:
Filter('Event Tracker',
Category.Value = "Invoice",
And(
'Start Date' = Gallery1_1.Selected.'Start Date',
Event.Value = Gallery1_1.Selected.Event.Value,
'Event Part'.Value = Gallery1_1.Selected.'Event Part'.Value
)
)
That is literally it... If anyone could help me understand what is happening here I would greatly appreciate it. Again, the performance seems to be tied to this inner gallery because on the first screen of the app (which is a calendar gallery setup where the user clicks on an Event on the calendar to bring them to this second screen which shows the details of that event) there are no performance drops - it's only when a user clicks the event button and navigates to this second screen that suddenly the performance grinds to a halt and the loading starts. My ability to play the other apps I have made has not been changed as well, so it's not an issue on my PC or anything.
Here is a view from inside the edit screen with all of the inner gallery's controls visible:
Then the rest of the screens contents as you can see are just a bunch of basic text / combobox / button controls:
