Unanswered

"Editable Grid" bug, OnChange event of ComboBox fires when scrolling gallery !

(0) Share

Report

Posted on by RobertLHU

I've created editable grids before, but never had this problem. Any ideas would be helpful. Perhaps there's some new setting I'm not aware of.

Setup: Gallery Equipment list (10 items visible at one time)
- Items: dvEquipmentList (SQL view of multiple tables)

combobox: want to use OnChange event to run Patch statement to capture new value to Collection and store up changes for one final SaveAll Changes.
Problem:
- When loading screen - OnChange event fires for ALL visible records + ~8 of the next records. 😣
- when scrolling - OnChange event fires for 2 records with each scroll click. 😣

The "onChange" event seems to fire (only for combo boxes, not for text boxes) when the data loads (though Monitor does not track this) (double 😣 😣 ) as well as when the control is actually changed.

I've validated the trigger with this OnChange: Notify("Changing " & ThisItem.EquipID).
Any ideas what's going on and why this happening?

@RezaDorrani I know you've demonstrated editible grids, but haven't seen this bug with your demos.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (0)

Sort by

RobertLHU 50 on at

Like (0)

Report
Copy link

Link copied!

Perhaps I'm not crazy. Found this article
describing "defaultSelectedItems" property triggering the "OnChange" event. 😕
Current defaultselectedItems: LookUp(tProjectTrades, ProjectID = gvPID && TradeID = ThisItem.TradeID)
This DEFINITELY creates a an "issue". The "modern" combo box is limited to 500 rows, and I need more rows, and the drop down box does not allow searching, and I need searching 😕 This appears to be a dead end, unless I'm missing something. Anyone? Buehler ?

Was this reply helpful? Yes No
RobertLHU 50 on at

Like (0)

Report
Copy link

Link copied!

How soon before Microsoft creates a true editable grid for canvas apps ???

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RobertLHU ,

Combo box control is affected by delegation. So, you can increase items by changing data row limit to 2000:

To be honest, when using large dataset, it is always not recommended that edit data in a grid directly. Generally, we use grid to create/display/edit a collection, which will be easier and more efficient to be updated to data source.

Best regards,

Was this reply helpful? Yes No
RobertLHU 50 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-jefferni ,
thank for engaging, perhaps I didn't explain my issue clearly enough.
* for the team developing controls, as a developer, I need a combo box that is searchable and NOT limited by delegation. Sometimes the choices to pick from are > 2000 and the new fluent UI combo box creates issues with this limition.
* the data source on a grid doesn't change the fact that OnChange event fires when the default data gets populated in a combo box in a grid. It seems the OnChange event should ONLY respond to user changes, not default values, and therefore creates programming problems when events fires without there being any real changes.

Perhaps that explains the issues better ?
If you know of any design changes of these features, I welcome further understanding.
thanks,

Was this reply helpful? Yes No