cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cchan000
Level: Powered On

sharepoint powerapps form doesn't refresh data automatically after saving

I have a basic form created using PowerApps. If I edit an existing record using my form, hit save and then that record again the change I just made does not display.

 

i read somewhere to do a refresh expression code where the SAVE button is... but i'm confused. the save button is part of sharepoint, i can't acess that.

 

a.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: sharepoint powerapps form doesn't refresh data automatically after saving

Hi @cchan000 ,

Do you mean that the changes does not take effect when you save and edit an record again?

 

I have made a test on my side, and don't have the issue that you mentioned. Please consider edit your PowerApps form app, set the OnSave property of the SharePointIntegration control to following:

 

SubmitForm(SharePointForm1);
Refresh('YourSPList')             /* <-- Add this formula */

Set the OnNew property of the SharePointIntegration control to following: 

 

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

Set the OnEdit property of the SharePointIntegration control to following: 

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

Set the OnView property of the SharePointIntegration control to following: 

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

 

Please take a try with above solution, 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
Super User
Super User

Re: sharepoint powerapps form doesn't refresh data automatically after saving

I had the same problem. Check and see if the cache timeout feature is enabled and if it is disable it. 

 

File > App settings > Advance settings > Experimental features and make sure "Use longer data cache timeout and background refresh" is turned off.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
cchan000
Level: Powered On

Re: sharepoint powerapps form doesn't refresh data automatically after saving

sorry didn't work. after i click save and it goes back to the sharepoint list. if i click on the entry again it shows the form but not updated. i have to manually refresh the page to see the results.

Super User
Super User

Re: sharepoint powerapps form doesn't refresh data automatically after saving

Did you refresh your browsers a few times to make sure SharePoint was using the version of the app you just publish. I ask because i had this same issue and turning off that feature is what fixed it for me. I also find sometimes after publishing a change to the PowerApps custom form for SharePoint that my SharePoint list is till using the previous version of the form and I have to Ctrl+F5 a couple of times to get the new version to load.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
cchan000
Level: Powered On

Re: sharepoint powerapps form doesn't refresh data automatically after saving

sorry i appreciate the help but it didn't resolve the issue. it doesn't reload the form.

Community Support Team
Community Support Team

Re: sharepoint powerapps form doesn't refresh data automatically after saving

Hi @cchan000 ,

Do you mean that the changes does not take effect when you save and edit an record again?

 

I have made a test on my side, and don't have the issue that you mentioned. Please consider edit your PowerApps form app, set the OnSave property of the SharePointIntegration control to following:

 

SubmitForm(SharePointForm1);
Refresh('YourSPList')             /* <-- Add this formula */

Set the OnNew property of the SharePointIntegration control to following: 

 

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

Set the OnEdit property of the SharePointIntegration control to following: 

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

Set the OnView property of the SharePointIntegration control to following: 

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

 

Please take a try with above solution, 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

cchan000
Level: Powered On

Re: sharepoint powerapps form doesn't refresh data automatically after saving

i did what you wrote and it worked, BUT i think it's causing ghosting? you can see my new problem here. let me know if you think this is causing the issue.

 

https://powerusers.microsoft.com/t5/General-Discussion/When-opening-NEW-form-sometimes-some-fields-a...

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 356 members 7,015 guests
Please welcome our newest community members: