Sharepoint list form in Sharepoint - showing previous used values

[TrulsB]

I have created Power apps form on a Sharepoint list. No edition on the form, just save and publish. (The form is autocreated). 

• When i create a item, everyting works well, including save. Correct data is saved in the form. 
• When i change an existing item, (ex changing date, dropdown value and text value) i see that correct values is written back in the Sharepoint list. 
• When i re-open/edit the item i changed the old values is displayed, the values before the change. 
• When i refresh (F5) the screen, and then re-open/edit the changed item, everything works well and the values displayed in the form is correct.

As far as i can remember, this has not been an issue earlier.  Any idea why the values before the last change is displayed.

[Pstork1]

This is some kind of caching issue that Microsoft is currently working to fix.  It seems to be related to timing since some people have reported that it occasionaly stops happend and works as expected.  Try clicking on a different item before clicking on view the seond time. Its a bug and should be fixed at some point.

[v-xida-msft · Accepted solution]

Hi @TrulsB ,

Could you please share a bit more about your issue?

Do you create a custom form using PowerApps in your SP List?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned.

Please consider take a try with the following workaround:

Edit your custom form (created via PowerApps) in your SP List, then set the OnNew property of the SharePointIntegration control to following:

Refresh('YourSPList');    /* <-- Add formula here */
NewForm(SharePointForm1)

Set the OnEdit property of the SharePointIntegration control to following:

Refresh('YourSPList');     /* <-- Add formula here */
EditForm(SharePointForm1)

Set the OnView property of the SharePointIntegration control to following:

Refresh('YourSPList');    /* <-- Add formula here */
ViewForm(SharePointForm1)

Please consider take a try with above solution, then re-publish your custom form app, then check if the issue is solved.

Best regards,

[TrulsB]

Yes, it is a Sharepoint custom list, and it is created from "PowerApps" menu in Sharepoint. 

Using your solution works well!  Thank You!

[nikitamobile85]

Dear @v-xida-msft , 

we experience similar issue with our Power Apps form. We have recently implemented Share Point list form (Power Apps) to automate internal approval process. After receiving of a notification via Teams an approver is able to access SharePoint list form via link and check the request details. From time to time an approver sees attachments from a different previously submitted request instead of the actual data related to submitted list item. At the same time other participants and initiator can see proper data while accessing the same list item.   

It is not happening all the time and list page refresh solves the issue. However approvers get confused and sometimes reject requests thinking that wrong attachments have been applied by initiator. An important point is that wrong attachments which appear in the form are always from the very first list item. 

The solution you proposed doesn't fix in our case. We have tried both refresh and reset options. Your advice would be much appreciated. 

[ralfie234]

We get exactly the same behaviour as you describe above @nikitamobile85 

Its very random and shouldnt happen as using 'ThisItem.Attachmen't so how it could ever display the attachment(s) from another form feels like a bug in certain situations.

As Shane says in this video, 99% of the time we shouldnt be using 'Refresh (SPlist)'.

https://www.youtube.com/watch?v=gmYlJIjHS2M

MS how do we address this the correct way ?

[Anonymous]

Is there any way to correct this using JSON? I did not use PowerApps to create my form, but I did use JSON to format. Thank you for any help you can provide.

[ahmad-uzair]

Hello @TrulsB

I fixed it by using Revert function on OnView and OnEdit like 

Revert(your_sharepoint_list,SharePointIntegration.Selected)

This will refresh the selected row data and get you the updated values

Hope this helps!