Question

A canvas app screen calculates order totals in several controls. Each control repeatedly calls LookUp(Customers, CustomerID = varOrder.CustomerID) to fetch the same customer record, and then reads different fields (discount rate, region, credit limit) from the result. Users report the screen feels sluggish because the same Dataverse record is retrieved multiple times. You want to retrieve the record once and reference its fields across the calculations in a single, readable formula. Which Power Fx approach best achieves this?

Accepted Answer

Wrap the calculations in a With() function that binds the LookUp result to a named record, then reference the fields from that named record.

Answer

Wrap the calculations in a Concurrent() function so all the LookUp calls execute in parallel and finish faster.

Answer

Replace each LookUp with a Filter() call and use First() to grab the record in every control.

Answer

Move the LookUp into the screen's OnVisible and store the result in a collection with Collect().