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!

35 REPLIES 35

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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (68,177)