Coalesce in Power apps – Power Platform

Hi Everyone,

As we all know how we Coalesce() function in SQL, it returns the first non-null value in a list.

For example : If we run the below query, will get the results as


In simple words, it just returns whatever the first non-null value.

In the same way, we can use Coalecse function in Power Apps formulas as well. Today, I have two variables which has been set from different logics and I had to write the logic to get the not null value between two of them. I used below formula to get the not null value between two variables.

Coalesce(variable1, variable2, …)

Here is more information from Microsoft Docs

Hope this helps.

Happy 365’ing

One thought on “Coalesce in Power apps – Power Platform

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s