Question

A canvas app screen has an OnVisible property that must load three independent collections from Dataverse (ClearCollect calls to Accounts, Contacts, and Opportunities) before the gallery renders. Users report the screen takes several seconds to appear. Each ClearCollect currently runs one after another on separate lines. You need to reduce the perceived load time with the least amount of formula rework. What should you do?

Accepted Answer

Wrap the three ClearCollect calls in a single Concurrent() function so they execute in parallel.

Answer

Move all three ClearCollect calls to the App.OnStart property instead of OnVisible.

Answer

Replace the three ClearCollect calls with a single With() function referencing all three tables.

Answer

Combine the three tables into one collection using AddColumns() and a single ClearCollect.