TL;DR: Coalesce returns the first non-blank value from a list of parameters – the one-line replacement for nested If(IsBlank()) checks in Power Apps, and available as coalesce() in Power Automate.

💡 Challenge

In PowerApps and Power Automate, managing multiple potential blank values often results in complex, nested If statements. This complexity hinders readability and efficiency.

✅ Solution

Implement the Coalesce function. It scans through a list of parameters and returns the first non-blank value, significantly simplifying formula complexity.

🧩 Syntax and Examples

Coalesce( Value1 [, Value2, ... ] )

// Returns the nickname, otherwise the first name, otherwise "Unknown"
Coalesce( txtNickname.Text, txtFirstName.Text, "Unknown" )

// Fallback when a SharePoint column is blank
Coalesce( ThisItem.DisplayName, ThisItem.Title )

// Label with a default for empty lookup values
Coalesce( LookUp(Employees, ID = varID).Email, "no-email@company.com" )

Power Automate equivalent – the coalesce() expression works the same way in flows:

coalesce(triggerBody()?['email'], variables('fallbackEmail'), 'noreply@example.com')

⚖️ Coalesce vs. If(IsBlank())

Approach Formula Drawback
Nested If If(!IsBlank(a), a, If(!IsBlank(b), b, c)) Every value appears twice, hard to read with 3+ fallbacks
Coalesce Coalesce(a, b, c) None – same result, one function call

Both return the same result. Coalesce(a, b) is simply the short form of If(!IsBlank(a), a, b) – each value is only written (and evaluated) once.

🔧 How It’s Done

  • Instead of using multiple nested If statements to check each value, list the values as parameters in the Coalesce function.

  • The function evaluates each parameter in order and returns the first non-blank value it encounters.

🎉 Result

This streamlines your formulas, making them easier to read and maintain, improving both development and future maintenance of the app or flow.

🌟 Key Advantages

🔸 Enhanced readability.

🔸 Reduced complexity.

🔸 Easier maintenance.

🔸 Improved performance in certain scenarios.

🎥 Video Tutorial

🛠️ FAQ

1. What is the difference between Coalesce and If(IsBlank())?

Coalesce(a, b) is the short form of If(!IsBlank(a), a, b) – same result, but each value is only written once. With several fallbacks this keeps formulas dramatically shorter and less error-prone.

2. Does Coalesce exist in Power Automate?

Yes, as the expression coalesce(), e.g. coalesce(triggerBody()?['email'], 'noreply@example.com'). It returns the first non-null parameter.

3. How many parameters can I pass to the Coalesce function?

Coalesce can handle multiple parameters, but for optimal performance and readability, limit to 5-10 parameters.

4. Does Coalesce work with different data types?

Yes, but ensure all parameters are compatible data types or use conversion functions like Text() or Value() when needed.

5. What’s considered a “blank” value in Coalesce?

Blank values include empty strings (“”), null values, and the Blank() function result. Zero (0) and false are not considered blank.

Need Help with Your Power Platform Project?

Get expert guidance through personalized workshops, consulting, and training tailored to your specific needs.

Request Workshop

Consulting and process automation for SMBs is delivered by KMUpower. Prefer structured, German-language courses? The Power Platform Academy offers live Power Platform Schulung and hands-on Power Platform courses for Power Apps, Power Automate and Copilot.