In this blog, we will show how to use Coalesce function in Power Automate
The most common case in Power Automate is to verify null data and default to a certain value. It is simple to achieve with Power Automate by using the Coalesce Function.
The most common case in Power Automate is to verify null data and default to a certain value. It is simple to achieve with Power Automate by using the Coalesce Function.
Create an instant cloud flow and provide a trigger for that as Manually trigger a flow and click Create, as seen in the figure below.
Next click on “+New Step” and take initialize variable and provide the values like showing in the below image
Next take a Compose action and use the below formula in the expression
Note: If the fee is null, the value will be false; otherwise, a non-null number given in the Student Object will be used.
Note: If the fee is null, the value will be false; otherwise, a non-null number given in the Student Object will be used.
coalesce(variables(‘Student’)?[‘Fee’],false)
Next, Click on save then test and run the flow and observe the results.
we can see false is returned because we set fee as null
Now change the fee as true in initialize variable and see the results
Here is how the Coalesce function makes handling null values simple.
For any Help or Queries Contact us on info@crmonce.com or +918096556344
