Question

A canvas app's OnStart property sequentially loads five independent Dataverse tables into collections using ClearCollect, then sets three global variables that do not depend on those collections. Users report that the app takes over 12 seconds to open. You must reduce startup time with minimal code changes while keeping all the same data loaded. What should you do?

Accepted Answer

Wrap the five ClearCollect calls and the three Set calls inside a single Concurrent function in OnStart.

Answer

Move all five ClearCollect calls to the OnVisible property of the first screen so they run after the app opens.

Answer

Replace each ClearCollect with a Collect call so the collections load incrementally as the user navigates.

Answer

Combine the five tables into one collection using a series of nested AddColumns and lookups.