cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MAV_CB
Microsoft
Microsoft

SubmitForm command changes Gallery.Selected item record

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 :(.

 

Thanks!

36 REPLIES 36

This is an excellent solution, thank you! Hopefully the product team will address this at some point. 

edbellman
Advocate II
Advocate II

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.

LilySnow
Frequent Visitor

2021. 5 years since the original post. Same problem here. Well done PowerApps team!

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. ☹️

jwp132
Regular Visitor

This problem is still an issue. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,829)