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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (63,586)