Completion of SubmitForm loads first record

[Coopedup]

Hi,

I seem to have developed an odd behaviour in my app. Via a gallery view you can filter what is displayed and then select a record from the SP List to view. The record is viewed over 5 forms and pages and allow for changes and updates. 

When a changed form is submitted and successfully saves the page refreshes and then displays the first record from my filtered (or unfiltered) gallery view SP List ratter than stay on the record selected!  Has anyone ever experienced this?

example submission....very simple.

SubmitForm(newNote)

[RandyHayes · Accepted solution]

@Coopedup 

If I had to make a guess - your Item property of the form is based on a Galleryx.Selected formula.

And, further, the Items property of your gallery is more complex than just a simple datasource result (i.e. sorting, data shaping, etc.)

If that is the case, then what is happening is that your record is written from the submit form and this causes the Items property of the Gallery to re-evaluate itself - thus causing it to re-apply the Default of the Gallery (which is probably empty) which then causes the Gallery to select the first record.  Which, because your form is based on the gallery selection, causes your form to show the first record.

I would change your Gallery OnSelect action to include a snapshot variable -  Set(glbCurrentRecord, ThisItem)

Then change your Form Item property to: glbCurrentRecord

For good measure, I would add this to your OnSuccess action of the form : Set(glbCurrentRecord, Self.LastSubmit)

I hope this is helpful for you.

[Coopedup]

If that is a guess then I'd love to know when you are certain....all ticks! sorting,  shaping, filters...I'll take a look and hopefully it'll sort things out.

[RandyHayes]

@Coopedup 

Yep...this is very common.  Galleries will re-evaluate their Items formula whenever there is a change to the underlying datasource of the Items.  

So, the choices are:

1 - Use the snapshot variable of the chosen record for the form as I mentioned prior.

2 - Change the datasource to be a snapshot.  In other words, make the datasource for the core of the Items property to a variable (which has previously been populated with the real datasource).  The advantage to this method is that when you submit the form, it is submitting to the real data source - meaning that the snpashot variable datasource will NOT change and thus the Gallery will not re-evaluate.  The disadvantage is that the Gallery will not update with any new changes introduced by the submit form.  This may or may not be an issue.  AND, if you use this method, it is then best to set the variable in the OnSelect action of the gallery to be JUST the ID of the record instead of the entire record (as the gallery records will no longer reflect the underlying datasource record).  Then use the LookUp function to recall that record by ID when you need it (like in the Item property of the form).

Another method is to continue with #1 above, but work with the Default property of the Gallery to "re-select" the prior selected record even after the gallery re-evaluates its items.  This is a little trickier because you need to provide the EXACT record based on the Items property, and if you have some complexity to that formula, you certainly would not want to repeat it.  It is at this point that I usually implement a dynamic record variable in the app to supply a record table for both the Gallery Items as well as the Lookup source for the default property.

[Coopedup]

Very simple change but has worked. 😁 I had a variable already for ThisItem gallery selection, but wasn't using it. 

[RandyHayes]

@Coopedup 

Very good!  Glad that helped.

[danam]

Hi RandyHayes, 

I've tried your solution, but it only works when i create a NEW item. When I select an existing item from Gallery, it navigates to my Form Screen, but gives me a blank screen. It seems that my selected item didn't get pass to my Form.

Could you please advice what i've done silly? thanks in advance! 

[danam]

i think i got it. I set the glbCurrentRecord on the OnSelect property of my View & Edit icons, and it works!