#PowerPlatformTip 43 – ‘With function’

💡 Challenge

Complex calculations and expressions in PowerApps can lead to code that’s hard to read and maintain, especially when implementing formulas like the Haversine distance calculation which require multiple variable declarations.

✅ Solution

The With function in PowerApps allows defining multiple variables in a single block, streamlining complex expressions like the Haversine formula for improved readability and maintainability.

🔧 How It’s Done

Here’s how to do it:

1. Use the With function to define all necessary variables for the calculation.
   🔸 Declare variables for Earth’s radius, latitude difference, and longitude difference.
   🔸 Compute intermediate values used in the Haversine formula.
2. Reference defined variables directly in your formula.
   🔸 Avoid repeating expressions like variable computations.
   🔸 Make the Haversine formula cleaner and more maintainable.
3. Apply the With function syntax.
   🔸 Use With({var1: value1, var2: value2, ...}, YourFormulaHere)
   🔸 Place your formula within the same With block for concise code.

🎉 Result

Your PowerApps formula becomes more concise and organized, as With centralizes variable declarations within a single block. Complex calculations like the Haversine formula are now easier to read, update, and maintain.

🌟 Key Advantages

🔸 Improved Readability: Groups variable declarations in a single block to reduce clutter.
🔸 Ease of Maintenance: Only one location to update variables or logic ensures straightforward changes.
🔸 Enhanced Performance: Streamlined expressions can lead to better app performance.

---

🛠️ FAQ

1. Can I nest multiple With functions within each other?
Yes, you can nest With functions, but for better readability, consider using a single With function with multiple variables instead.

2. What’s the difference between With function and Set function for variables?
With creates local variables within its scope only, while Set creates global variables accessible throughout the app. Use With for temporary calculations.

3. Can I use With function with complex data types like collections or records?
Yes, With works with all data types including collections, records, and tables, making it versatile for complex calculations and data manipulations.

---