Question

A canvas app's OnStart currently calls ClearCollect to load the current user's employee profile record from Dataverse into a collection named colProfile, and screens reference First(colProfile).Department. A senior developer asks you to reduce startup overhead and simplify formulas, since only a single record is ever needed and it should be cached in memory for the session. What is the most appropriate change?

Accepted Answer

Replace the ClearCollect with a Set that stores the LookUp result in a global variable, then reference the variable's Department field directly.

Answer

Keep the ClearCollect but wrap it in a Concurrent function to force parallel evaluation.

Answer

Move the ClearCollect to the App.OnVisible property so it only runs when a screen loads.

Answer

Replace ClearCollect with Collect so the record is appended rather than cleared and recreated each session.