cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

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
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,152)