Power Platform Community Forum Thread Details

I have encountered issues with formula-level prefetching on Canvas apps in several different areas:

Apps that need to submit to SharePoint, fetch new data, load that data to a local collection, and then use the local collection to store data in a variable - It appears that when formula-level prefetching is turned on the app attempts to increase performance by storing data in the variable first before submitting data to SharePoint and updating the local collection. For example, the following code submits a form to SharePoint and then uses the last item submitted to SharePoint in a local variable. However, when formula-level prefetching is on it will set the variable to the last item in the local collection prior to submitting to SharePoint:
- SubmitForm(Form1);
  Refresh(SharePointList1);
  ClearCollect(
  LocalCollection,
  Filter(
  SharePointList1,
  'Created By'.Email = User().Email
  )
  ));
  Set(LocalVariable, Last(LocalCollection).Column);
Apps that use If(Connection.Connected) to initialize local collections from SharePoint if online or load local collections from device if offline - For example, the following code initializes a local collection OnStart of the app either by pulling the data from SharePoint (if online) or by loading data from the users device (if offline). When formula-level prefetching is turned on if the user is offline they will get an error (issue with connecting to datasource). It appears as though the app is trying to preload the local collection with data from SharePoint before ever reading the conditional logic:
- If(Connection.Connected,
  ClearCollect(
  LocalCollection,
  SharePointList1
  )
  ,
  LoadData(
  LocalCollection,
  "OfflineLocalCollection",
  true
  )
  )

In both of these cases turning off formula-level prefetching solved the issues and the app ran as expected.

Is there a way to override when formula-level prefetching is performed so that we can guarantee that code is run sequentially when the user knows that order is critical for the apps function?

Categories:

Building Power Apps