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 StatureStack.com

SELECT COALESCE(NULL, NULL, NULL, ‘StatureStack.com’, NULL, ‘mscrmtechie.blogspot.com’);

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
Gopinath.

One thought on “Coalesce in Power apps – Power Platform

Leave a Reply

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

WordPress.com Logo

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

Google photo

You are commenting using your Google 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