cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TrulsB
Advocate II
Advocate II

Sharepoint list form in Sharepoint - showing previous used values

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
v-xida-msft
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

Using your solution works well!  Thank You!

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. 

 

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 ?

 

 

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,141)