How to handle null value in logic app condition module
I have a logic app where i use a condition expression on to two variables, displayName and accountName.
Sometimes a variable will not exist. which will cause this error:
InvalidTemplate
Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Null'.'.
How do i handle this error? I want the condition to treat the null value as if the variable is a empty string
Is it possible to write a expression thats like iff(accountName is empty(), '', accountname)?
Solution
You can do so by using coalesce() function.
I am using below given expressions to achieve this.
coalesce(variables('accountName'),'')
coalesce(variables('displayName'),'')
This works if one variable is not exist. Here I am only passing the value of account name but not display name.
- How to handle null value in logic app condition module
- Add properties to an object in a variable in Azure Logic Apps
- Workflow Validation Failed Error: The function cannot be called from a logic app. It must not have a custom route
- In an AZURE Function how to throw an error to be caught in the Azure Logic AP
- Cannot get AAD auth token in Logic Apps
- Parameterising connections.json in Azure Logic Apps(Standard) for deployment via Azure DevOps
- Logic Apps: How to use create a new watchlist with data (raw content) module
- Add extra attribute to object Logic app
- How to hide or change legend in "Run query and visualize results" logic app function?
- Azure Logic App Authorization Policy set via Bicep
- Azure Event Grid Graph API SharePoint Event info useful?
- Azure Logic App Function call for non json body
- Publish Failure Reporting Add or Build Definition File
- Azure Logic App returns metadata instead of SQL query results when invoked via HTTP trigger
- Azure Logic App is only inserting 100 rows into SQL Server table
- Unable to open the workflow in designer using vs code
- How to Pass SAS Token as Header in Azure Logic App HTTP Trigger?
- Azure Logic Apps with Form Recognizer - Get Array definition in optional settings entry
- logic app ( power automate) extract checklist items from a task from a planner plan
- Power Automate Get Filename if Contains Special Character
- Task AzureAppServiceSetting@1: Application Settings object is not a valid JSON while deploying with YAML file from Azure Devops
- unable to delete or move first step from logic app?
- Azure Logic App HTTP Request Authentication Scope
- Enabling minimum apiVersion to 2021-08-01 in Azure API Management causing saving issues or deployment errors for existing logic apps
- Azure Logic Apps: Set condition to False when SQL query returns no rows of data
- Send alert/Logic apps if Azure ML pipeline Completed with Azure ML Pipeline Outputs attached to email
- How to output URL of Azure Logic Apps with Terraform?
- Trouble Passing Boolean Values in Azure Data Factory JSON Template
- Azure Logic App - For Each Key/Value Pair (Answered!)
- how to create new json object using compose connector in logic app without change in order?