Skip to content

Performance

Loading Data

Try to do as much as possible on the server-side. ‘Lazily load’ only what is required in the current tab onto local collection for repeated operations, such as fuzzy search.

sequenceDiagram
autonumber
actor u as User
participant a as App
participant c as Current_View_Data_Collection
participant il as List

u ->> a: Open App
a ->> u: View Login page with countries
u ->> a: Login into a single country

u ->> a: Select View (Tab - eg: Active, Completed)

a ->> il: Request data of current 1) region 2) view
il ->> c: Download
c ->> a: Status filter options
c ->> a: Return Current View Data
a ->> u: View

u ->> a: Select Status / Search Name, ID, Code
a ->> c: Filter
c ->> a: Return filtered Current View Data
a ->> u: View
          flowchart LR
          onvisible --> refresh_button --> t["TabGallery>Button>OnSelect"]

TabGallery>Button>OnSelect

Set(
    data_loading,
    true
); // this is for toggling any loading animations you have
Set(
    new_tab_selected,
    ThisItem.ID
);
If(
    new_tab_selected = varTabSelected,
    Blank(),
    Reset(Status_Dropdown)
);
Set(
    varTabSelected,
    new_tab_selected
);
// repetition of filter() is required to overcome delegation issue
ClearCollect( // non-delegable
    current_view_data,
    Switch( // non-delegable
      varTabSelected,
      1,
      Filter(
        my_list,
        Region.Value = country,
        Status.Value = "Active"
      ),
      2,
      Filter(
        current_region_data,
        Region.Value = country,
        Status.Value = "Cancelled"
      )
    )
);
Set(
    data_loading,
    false
);

Refresh Button

Select(
    Tab,
    varTabSelected,
    Tab_Button
);

Avoid unnecessarily data requests

// Onvisible of page
If(
  !loadapp,
  ClearCollect(collection,Filter(datasource,condition));
  UpdateContext({loadapp: true})
)
  • Never use Refresh(). Data sources are already refreshed on start
  • Forms & patch() connected to a data source (not collection) will automatically refresh that same data source (not collection)
  • Even a designated refresh button does not require this. Just use ClearCollect()

Concurrent Execution

Concurrent(
  function_1(),
    function_2(),
    ...,
    function_n()
)

// function can be Set(), clear(), collect(), ...

Delegable in

Ungroup(
  ForAll(
    Selectbox.SelectedItems, // list of column values
    {
      ItemsGroupedByFilterValue: Filter(
      ListWithDelegationIssues,
      County.Value = CurrentFilterValue
      )
    }
  ),
  "ItemsGroupedByFilterValue"
)
  • Set DelayItemLoading to true
  • Set LoadingSpinner to LoadingSpinner.Data or LoadingSpinner.Controls

  • Eliminate multi-screen dependency

  • This will prevent Powerapps from load everything from other screen

  • For example: Use global variable instead of gallery.selected for form

    row selection: Onselect will be Set(current_item, ThisItem)

Settings

Enable DelayedLoad

Speed up your app's start time by setting on-demand screen expression calls.

Enable Keep recently visited screens in memory

Enable Enhanced performance for hidden controls

Hidden controls will not be created until they become visible

Misc

  • Use components wherever possible
  • Use Lookup() instead of First(Filter())
  • Lookup() is delegable, First(Filter()) is non-delegable, First(Filter()) will load all the data into memory then perform the Filter(), then perform the First()
  • Lookup will stop at first match, First(Filter()) will search the entire data even after first match and then return the first
  • Change order of filters to further optimize logic
  • Use Named Formulas
  • Go to App property
  • Formula
  • Use Formula checker -> Performance Warnings - Unused Variables troubleshooting and some unused controls in the app
  • Disable onstart
  • Move things from onstart to onvisible to improve initial load
  • Delay Output of text control
  • Progress Message
2024-05-12

Comments