11. What is the Coalesce() Function in Power Apps?

In Power Apps, the Coalesce() function is used to return the first non-blank value from a list of arguments. If all values are blank, it returns blank.

👉 Think of it as a fallback mechanism – when the first value is missing, it automatically checks the next one until it finds a valid value.

Syntax
Coalesce( Value1, Value2, Value3, … )

where Value1, Value2, Value3… are expressions or values you want to check in order. The function evaluates each value from left to right and returns the first one that isn’t blank.

Coalesce function in Power Apps.

 

Example :

Coalesce(txtMobileNo.Text, txtEmailAddress.Text, "No contact info available") 

In this example :

Coalesce checks values in order:
If Mobile No is entered → it displays that.
If Mobile is blank but Email Address is entered → it shows that.
If both are blank → it shows “No contact info available”.

👉 In short, Coalesce() picks the first non-blank value from the list, ensuring your app never displays an empty field.
It’s commonly used to provide default values or fallbacks when fields are empty.

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top