Unanswered

Gallery Items erased when another control value is entered

(0) Share

Report

Posted on by 55552

682

In a canvas app, I have a gallery with multiple controls. One of the controls is a dropdown control, with choices linked to an SQL table. The selection process from the SQL table works fine, selecting a Part Number (field name is PartNumber). However, after the selection, if I modify any other control on that row, the selected dropdown value is erased and becomes blank. I do not have any default or defaultselecteditems set up.

In fact, this also happens with other controls in the gallery, even text controls. They get erased when other control values are entered.

Has anyone encountered this before?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Shaheer Ahmad 2,194 Moderator on at

Like (0)

Report
Copy link

Link copied!

This happens because your datasource is refreshed whenever you patch something to your datasource

Was this reply helpful? Yes No
55552 682 on at

Like (0)

Report
Copy link

Link copied!

So what is the solution? In the text fields within the gallery, I was able to prevent the erasing of data by using UpdateIf (in the OnChange property) to update a single record and column record in a Collection with the newly entered value. Then in the default property of the same text field (or even a checkbox field), I used ThisItem.ColumnName so that the value just pushed to the Collection would return to that field. But this does not work with a dropdown field or combo box field.

Was this reply helpful? Yes No
55552 682 on at

Like (0)

Report
Copy link

Link copied!

In the end, I had to update all my other editable fields in the gallery, using their OnChange property. Within that property, I pushed the value of the field itself to a Collection, but also pushed in the selected value from the Dropdown field. This appeared to solve the issue of fields being erased when other fields were filled in.

Was this reply helpful? Yes No