Refresh form data with new data after submit without leaving the form

[skylitedave]

Hi

I have a form on a canvas and I have a button on the screen that lets the user edit the data in the form ( changes the form mode from view to edit) .  Once the user is happy with the edits, they hit a button that has a Submit form in it and it changes the form mode back to Display. The data is stored in a SharePoint List.  

Here is the issue, the data saves fine to the SharePoint but does not appear  in the form unless I close the form and then return to it by selecting the screen that holds the form from a gallery.  I tried issuing a Refresh in the Save button but no luck.  I also tried Gallery.Selected from the save button on the screen holding the form.  Again no luck...

Is there a trick to get the data submitted to form to show up in the form without exiiting the form and then re-opening the form?

[Anonymous]

Another comment, since I have spent an inordinate amount of time on this and I'd like to spare future users the same trouble... 

Phil, when I was working on this yesterday, I didn't quite understand your second solution so I just removed the global variable from my gallery OnSelect property and my edit form's Item property.

Well, wouldn't you know I ran into another problem today where I really needed that global variable in place. 

So, I came back to this. 

Turns out Phil's second solution is even better than the first (so extra kudos to you)! 

As usual, this most infuriating problem had a simple solution -- and the trick was just to find it. 

For anybody who runs into this problem later...
IF you are running into a problem where you submit a form but changes don't show up until you re-select the item from the gallery...
AND you are using a global variable instead of the default Gallery.Selected method of choosing and editing gallery records...
THEN the easy solution is to add a clause to your submit button, before the navigate property, wherein you update the value of the global variable (using SET). This basically elbows PowerApps and reminds it that when it goes back to the view screen, it should show you information from the updated global variable item. 

Easy peasy. 

For what it's worth, my solution was slightly different than what Phil wrote above. 

Instead of Phil's suggestion:

Set(Globalvariablename,Galleryname.Selected);

I put: 

Set(Globalvariablename,Editformname.LastSubmit);

Seems to be working fine now. 

Thanks for getting to this first, Phil!

[Sooner703]

Thank you all for the posting! Definitely helped me out! 

[MVemba]

I am having the same issue:
I update the edit screen, the data is updated on the SharePoint list, but the update does not show on the "detail" screen.
It only shows if I close the app and log in again.

[john_dawson]

I had the same, or similar problem; I got round it by putting an UpdateContext on the OnChange property of the field; I think maybe the problem occurs because I'm using an external value as the Default for the field, so I have to update its context on change, like this: UpdateContext({<name of external value>: <card value>.Text}) - if that makes sense? Was very simple to implement ...

[Anonymous · Accepted solution]

I just solved this issue by adding this line to the EditDetails screen's OnVisible property:

Refresh('SP List Name')

[john4]

Your solution worked great for me. I spent waaaaay to long trying to figure it out. Thanks again!

OnSelect: 

Set(Globalvariablename,Editformname.LastSubmit);

[abcrandy]

How would this work if I'm using a collection instead of a global variable?

[Anonymous]

Hi there @skylitedave 

 , I found another solution you might want to try.

You don't specifically mention it in your post but must likely you pass the record you are trying to modify through a variable you pass with the Navigate function:

Navigate(FormScreen ,TransitionEffect, {datarecord: datarecord})

On the OnVissible function of the form Screen, I assigned the Data record coming from the List-of-records screen to a global variable:

Set(datarecord, GLobalVariable)

Then you assign the GlobalVariable to the Item property of the Form.

Then in the OnSucces Property of the form you change the GlobalVariable to be equal to the LastSubmit of the form:

Set(GlobalVariable, Form1.LastSubmit)

That way you will always have the updated data in your form and you can update the data multiple times on the same screen and it will show always the most updated data.

[Anonymous]

Hi there @skylitedave 

 , I found another solution you might want to try.

You don't specifically mention it in your post but must likely you pass the record you are trying to modify through a variable you pass with the Navigate function:

Navigate(FormScreen ,TransitionEffect, {datarecord: datarecord})

On the OnVissible function of the form Screen, I assigned the Data record coming from the List-of-records screen to a global variable:

Set(datarecord, GLobalVariable)

Then you assign the GlobalVariable to the Item property of the Form.

Then in the OnSucces Property of the form you change the GlobalVariable to be equal to the LastSubmit of the form:

Set(GlobalVariable, Form1.LastSubmit)

That way you will always have the updated data in your form and you can update the data multiple times on the same screen and it will show always the most updated data.

[rdwhitman]

Hate to resurrect this, but having what I think is same problem.  I have a page on which I have a table (not Gallery).  Select item in table, click button to take user to page with detail form, default in view mode.  Use TableName.Selected for Item.  Have also tried setting a variable to choose recored.

Below the detail form is a Button titled "Edit".  Click that button changes it's title to "Save" and puts form in Edit mode.  Make change, click save button, executes "submit", SharePoint list is updated, but form, after briefly showing new value reverts to old value.  If you navigate back to the page with the table and then back to the detail page, you see the change.

And this only seems to happen in published app.  When running in development environment it works as expected.  Very frustrating, have tried all (ok most) of suggestions in this thread.  No luck.  

???

Thanks