Incorrect behavior in dropdowns - Wrong choices while using in Gallery

(0) Share

Report

Posted on by DB-23071841-0

Hi All, (sorry for the long email)

I have a serious control/UI problem,

Im creating an app with a gallery as a form (where you can update the information in the first screen).

The gallery has 3 independent dropdowns (less than 8 options each) with a Patch function during onChange, so everytime you change the dropdown it sends the Patch to a sharepoint list.

The app works like a charm (on a database level), but is having an error ramdomly (Some times when you change too much the selections or sometimes when you start for the first time).

Error description:

When I use one of the dropdowns in an specific record, the other records in the screen change the selected options ramdomly (not afecting the database, a.k.a. not triggering the Patch onChange) but causing confusion to the user.

A workaround It's helping is a message for the USER "If you notice a weird behavior in the dropdown, please click on the icon "REFRESH DATABASE" [Icon with a Refresh()].

Im using this properties in each Dropdown:

-Items: Table(record,record)

-Onchange: Patch(Database,thisItem,"Field":Dropdown.Selected.Value)

-Default: If( IsBlank(ThisItem."Datafield),"Option 1",Lookup(Database, ID = ThisItem.ID,"Datafield")

-Reset: False

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report

Hi @DiegoB ,

This is a known issue when triggering an action from within a gallery from an unbound control. It causes unbound controls in other records to reset.

One solution is to save one record at a time, but it can be overcome by binding the control to a field in the gallery source, Patching to this field and making the field the Default of the control. This is relatively simple if you are using a collection as the gallery source as you simply use AddColumns to temporarily store the data as above.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report

Hi @DiegoB ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
DB-23071841-0 16 on at

Like (0)

Report

Hi @WarrenBelz ,

Thank you very much for the help,
It was solved with your solution, now its working perfectly!

Was this reply helpful? Yes No