Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
In Power Automate, most of the common scenario is to verify null values and default to a specific value, in Power Automate it can be achieved easily using Coalesce Function as an example and Plan Object is considered.
Login to the required Power Apps environment using URL make.powerapps.com by providing user name and password and click on Flows on the left hand side as shown in the below figure.
After Step 1, Click on New Flow and select instant cloud flow and provide the trigger as Manually trigger a flow and click on Create as shown in the below figure.
After Step 2, name the flow as Coalesce to hold Plan Object we must click on + New Step and Choose an operation and in text box type Initialize Variable and select Initialize variable and provide the following
step name as Initialize variable – Plan Object
as shown in the below figure.
After Step 3, click on + New Step and Choose an operation and in text box type Compose and provide step name as Compose – Coalesce and select inputs and in the below popup select expression and type the following as expression
Coalesce (object_1: any) which returns the first non-null object in the arguments passed in
Example : if plantype is null then false will be defaulted as value otherwise non null value specified in Plan Object , Step 3 will be returned
after specify value then click on Ok/Update as shown in the below figure.
After Step 4, click on Save -> Test -> Manually and click on Test then Run flow .If no errors click on Done and observe the result false will be returned as shown in the below figure.
After Step 5, provide the input object as
click on Save -> Test -> Manually and click on Test then Run flow .If no errors click on Done and observe the result that true will be returned as shown in the below figure.
Conclusion: In this way one can easily handle null values using Coalesce function in few minutes and use it for required scenarios.
Business Applications communities