Azure Logic Apps - Check if a field is empty in the Create CSV table

Siddharth Kumar 71 Reputation points

I have a logic flow app where I am downloading data from a salesforce object. After downloading the data, I follow that by a create CSV table action


The CSV column 'ParentTerritory1Id__c' needs to be prepended by a client constant(in this example XXX) for some downstream processing - if and only if the value from salesforce is not null. The first 3 fields are required in salesforce - so they will always have a value.

How can i create an expression in the CVS table to check if the value of the field is null before i prepend the client constant.


Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,904 questions
0 comments No comments
{count} votes

Accepted answer
  1. Bruno Lucas 4,411 Reputation points MVP


    I don't have a column named 'ParentTerritory1Id__c' but I tried another sales force field (AccountNumber)

    try to add this on that Column: if(equals(item()?['AccountNumber'],null ),'',concat('XXX',item()?['AccountNumber']))

    on your case

    try to add this on that Column: if(equals(item()?['ParentTerritory1Id__c'],null ),'',concat('XXX',item()?['ParentTerritory1Id__c']))

    for XXX just use a logic app variable


    is this what you want to acomplish?


    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful