Coalesce in PowerApps/ PowerAutomate

In this post today, let us see one of the lesser known function named Coalesce

Most of the times, the value we pass through a variable to Power Automate or PowerApps functions to process the business data may not arrive and may cause data processing failures due to NULL values.

The Coalesce function helps (Citizen) developers to avoid NULL values issues in data processing by enabling to pass default values when required.

In the below example we are passing only Name and Email values to another HTTP request.
But at the receiving end point we are trying to capture Country value too,
which is not available in the input values. Let us how can we handle this using Coalesce

coalesce(triggerBody()['country'],'India')

With the above expression, though the COUNTRY value is not received we can have it filled with
INDIA as we are using COALESCE.

AND in case if we know that data may come with empty string value instead of NULL, we can handle that using the IF condition too as below

if(empty(variables('Country')),'N/A',variables('Country'))

In the above example if the Country value is empty - we can tweak it with required default input i.e., "N/A".

Comments

Validate an email input in a Canvas Application | PowerApps

Validate an email input in a Canvas Application | PowerApps In this post let us see, how to Validate an email input in a Canvas Application UI Validations helps us to ensure, valid data is received from the End User to complete an operation helps end user to provide right information the validation action depends on the type of the input control for Text Input Control - mostly we go with "OnChange" for check box control - "OnCheck and On uncheck" for Drop Down and Combo Box Controls - "OnChange" or "OnSelect" etc., Now, let us see how can we validate an email input, a phone number input and a name input. How to validate an email input value is valid? We can leverage "Regex" (Regular Expressions) to valid user inputs. Let us consider the Email Input Control Name as - txtEmail.Text. OnChange of this Control let us i

How to create a "pop-up box" in PowerApps

in this post, let us see how to create a Pop-Up in Canvas App required controls: rectangular icon label buttons - 2 take a "rectangular icon" and make it screen size update it's "Fill" - with RGBA(175, 191, 224, 0.5) . Take another "rectangular icon" and adjust it to center Take "label" - and add required text (Eg: "do you want to proceed?") Take two buttons. Update text of Button1 to "OK" and other to "Cancel" On Click of the respective control (to open the pop-up), add this expression : UpdateContext({locOpenPopup:true}) select "cancel" and "ok" button and add UpdateContext({locOpenPopup:false}) on "OnSelect" property. add appropriate actions on "cancel&quo

Success confirmation on a record submission - Canvas Application

In this post let us see, how to show a successfully submitted record's data back on to the form, as a confirmation. Take two screens Home Screen Success Screen On Home Screen: Take a Form Control on the Home Screen and map it to respective entity. In this post we are mapping it to Registrations entity. Take a Button Control and input the below expression, to create records into Registrations Entity. SubmitForm( frmRegistration ) Now, let us implement how to redirect the user to Success Message screen to successful record submission. In order to achieve this, we are going to make use of one of the Form Control's properties - OnSuccess. So, OnSuccess we are going to implement Success Screen navigation as below Navigate(' Success Screen ') Success Screen Take a label to show - success message, as below "Registration was successful. Registration Id: " & frmRegistration .LastSubmit.'Registration Number' LastSubmit property of a From Control helps u

MS Power Assist

Search This Blog