Use With() to stop repeating LookUps

1 min read Level: Beginner

Use With() to evaluate LookUp() once and reuse the result in Power Fx formulas.

Click image to enlarge

Stop calling LookUp() three times in the same formula. Wrap it in With() — it evaluates once and you reuse the result. Cleaner code, better performance. 🚀

Did this tip help you?

Vote once and classify what made this tip valuable.

Try this now

Quick checklist to apply this tip immediately.

Find one formula where LookUp() appears more than once.
Move the repeated lookup into With() and reuse the variable in the same expression.
Test performance and readability in preview before publishing the change.

💬 Comments & Suggestions

Share your thoughts, tips, or drop a useful link below.

Enable JavaScript to view comments via Giscus.

Share this tip

Did this tip help you?

Try this now

Related tips

Add Microsoft Clarity to Power Apps to see how users really use your app

You can vibe-code a full Power App — just describe what you need

Did you know the “?” is a help feature?

💬 Comments & Suggestions