I have an app connected to a SharePoint list. I have a form that is in Edit Mode, and loading from a Gallery via .Selected property. After submitting changes successfully, the Edit Form control is changing the .Selected value to the first record in the data source set. This should not be happening, it should just load the currently selected record. I noticed this change today and last worked on the app late last week. Anyone know why this would happen? I haven't changed anything in the code since last week :(.
Solved! Go to Solution.
For what it's worth, this is still an issue in early 2020, almost 4 years later.
I have a filtered gallery and when using Patch on a form, if using Gallery.Selected the form or fields in question will patch correctly but then the data refreshes or reloads the first record in the gallery, not the selected record.
The work-around of setting gallery.selected to a global variable and then referencing that everywhere (Item property and Patch function) works but was a pain to research and resolve.
It's not actually a problem, which is why it's not been 'fixed'.
You shouldn't use gallery.selected to keep track of an item you're changing. If you want the same effect, you should store the ID of the item you are editing in a variable, and do a lookup for the item matching that ID instead of using gallery.selected, which is intentionally transient.
Thanks for the replay @davidstone
I have a gallery and a form and actually use a variable instead of Gallery.Selected to look up the item. But once the form is submitted, the gallery jumps to the first row.
Ah yes, there's sadly no control over the scroll position of a gallery, which can be a real pain. Additionally, if you update a record on which the gallery is based, then the gallery has to reload to get your new changes, and thus the current scroll position is lost. ☹️
@JoshHoughton - thanks for the suggestion. It's not working for me
Scenario: I have a sharepoint list based powerapp where on selection of gallery item the edit form page display the selected record. With Gallery.selected it's working perfectly fine. however, when I reach to the item # where I do not have data for the columns display in form, on submission of form it throws back to 100th item of gallery. I tried with custom variable, however, it's not even displaying a record for my form.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.