Answered

Fields not viewing correctly using Modern View and a SharePoint Customized Form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I started a thread last week regarding a Status field wasn't updating when an Automation updated the field (https://powerusers.microsoft.com/t5/Building-Power-Apps/Field-value-doesn-t-show-correct-value-after-Automate-updates-it/m-p/446936#M132819).
The View would show the correct value, but when opening the form the "old" status was cached. If I did a Ctrl+F5 and then reopened the form everything was correct.
The Solution given, add Refresh(sharepoint form) to the OnNew, OnEdit & OnView for the Form worked, as long as I continued to open the same form.

Unfortunately, what I have found is if I submit a couple forms, wait for Automate to update the Fields and Status, using Modern View, the Old cached value still shows on the form.
In the image below you can see that when I open Request#2259 it shows a status = to Draft, whereas in the view itself it is "IDE Approver":

A Ctrl +F5 fixes it... as well as if I go to the view, switch to Classic Experience and open/edit/add new forms everything updates fine.
This seems to point to an issue with Modern View, which is the default setting for our environment. If anyone has any other ideas I'm open to suggestions, otherwise I'll look to open an incident with Microsoft.

Thanks!!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

kidvallejo 100 on at

Like
a
(0)

Report
Copy link

Link copied!

Two options that I use:
1) insert a timer control set it to say 600000 (its in milliseconds) or ten minutes, set autostart reset and repeat properties to true and set the on timer end to - refresh(datasource);reset(timer1) - and usually would make this not visible
2) add refreshes for your datasource to the on success for your forms
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Spoke with Microsoft.. There are some known delay issues using a SharePoint Customized Form, submitting an item and that data showing correctly when you open the another item in Modern View without refreshing the view. This is something they are aware of and looking into, but no ETA.. The only know resolution is Refresh the view in between each edit.