cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ericonline
Community Champion
Community Champion

DEAD performance using Gallery with Multiple Input Controls within

Hello,

Had an awesome app going then... something crazy happened. The performance turned absolutely abysmal and I can't quite figure out what is causing it. 

Scenario:

- OnStart: Create collections from SQL tables

  - ClearCollect(colStates, dbo.stateList) (~50 items)

  - ClearCollect(colStations, dbo.stationList) (~4000 items)

  - ClearCollect(colOptionSets, dbo.optionSets) (~400 items)

- On next screen, user executes a search which brings back ~50 records

  - ClearCollect(colData, Filter(dbo.dataTable, value = userSuppliedValue))

- Gallery with colData as DataSource

- Dropdown1 within gallery

  - Items property set to Filter(colOptionSets, columnName = ThisItem.sameColumnName)

  - Visible property set according to a column in colTest

- Then I added a Combobox to Gallery

  - Items property set to colStates

  - Visible property set according to column in colTest

- Then I added another Combobox to Gallery

  - Items property set to colStations

  - Visible property set according to column in colTest

- Then I added a DatePicker to Gallery

  - Visible property set according to column in colTest

Symptoms:

- The browser continually freezes when in edit mode

- NONE of the picklists load

- Its like PowerApps can't render the gallery and it CERTAINLY can't render the Dropdown/Combobox option sets

Questions:

- Has anyone else used this model successfully?

- Any tips for providing users with multiple input controls within a Gallery, each with different Items (some large)?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

The problem was actually only in the Editor/Studio. The Web Player itself had great performance! The solution to DEAD performance in the gallery... Try the Web Player, you may find there is no performance problem or at least that its at an acceptable level.

View solution in original post

4 REPLIES 4
v-yutliu-msft
Community Support
Community Support

Hi @ericonline ,

Do you mean that your gallery, drop down and combo box can not load correctly?

Firstly, do you set like this?

1)collections:

ClearCollect(colStates, dbo.stateList) (~50 items)

ClearCollect(colStations, dbo.stationList) (~4000 items)

ClearCollect(colOptionSets, dbo.optionSets) (~400 items)

ClearCollect(colData, Filter(dbo.dataTable, value = userSuppliedValue))

2)gallery's Items: colData

3)drop down's Items: Filter(colOptionSets, columnName = ThisItem.sameColumnName)
4)combo boxes' Items: colStates        colStations

 

Actually, the key problem should be about the colData collection and gallery's Items.

Since collection does not have delegation limit, so other formulas do not have problem.

But this formula: ClearCollect(colData, Filter(dbo.dataTable, value = userSuppliedValue))

You filter based on dbo.dataTable, which will have delegation problem.

Could you tell me how many records in this table dbo.dataTable?

If it is larger than 2000 record, you should pay attention to delagation problem.

Here's a doc about delegate functions of sql server for your reference:

https://docs.microsoft.com/en-us/connectors/sql/

 

What's more, do not forget to change non-delegate limit to 2000.

delegation.jpg

 

If the problem is not about delegation, maybe it's about app's performance.

Here's a doc about some tips of improving app's performance for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/performance-tips

 

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the reply @v-yutliu-msft . The data source is Azure SQL, so no delegation worries. 

I was able to track down the problem:

- Removing the Comboboxes from the gallery. 

- I'll have to place these on a separate screen as the Gallery cannot handle Comboboxes with 4k Items.

Hi @ericonline ,

I'm glad that you've found a solution.

Do you have any other problems?

If not, could you change the issue's status to "Answered"?

Thanks!

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

The problem was actually only in the Editor/Studio. The Web Player itself had great performance! The solution to DEAD performance in the gallery... Try the Web Player, you may find there is no performance problem or at least that its at an acceptable level.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,877)