Answered

Sharepoint list form in Sharepoint - showing previous used values

(1) Share

Report

Posted on by TrulsB

144

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
TrulsB 144 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Using your solution works well! Thank You!

Was this reply helpful? Yes No
nikitamobile85 86 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ralfie234 8 on at

Like
a
(0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ahmad-uzair 8 on at

Like
a
(0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No