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.

Canvas App showing loading icon on Dynamics 365 CE forms – Power Platform

Hi Everyone,

Today I was working on simple Canvas App and I have to show it on Model Driven Form on Dynamics 365 CE. I have published the Canvas App, copied the URL and did set to the IFrame on the form. Here is the configuration of the same.

I have saved the Form, Published and navigated to the Account page. To my surprise, it started showing only loading icon.

I was thinking something going at the Canvas App side but when I play, it is working fine. Came to the conclusion that certainly some thing from Dynamics side is blocking the content. And finally, it is Cross-frame Script which is blocking the content. After un-checking “Restrict cross-frame scripting, where supported. ” checkbox everything started working.

Hope this helps.

—
Happy 365’ing
Gopinath.