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

Question

Hi
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.

Regards
Sid

Answer 1

Hi,

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?