Data Pipeline Expression Language – Check if field exists, handling non-existent properties

Hi sean,

Indeed the pipeline expression builders equips us with an ability to use dynamic functions and parameters.However ,i came across an issue while building the folder path to the sftp server dynamically with the concat function.

Hardcoded path for example is '/Directory_name/folderName' .Now i want to dynamically pass the folderName from the the previous filter activity output which is filtering the latest folder.In the pipeline expression builder I wrote '

@concat('Directory_name/',activity('Filter1').output.Value[0].name).But getting "Expression of type: 'String' does not match the field: 'folderPath'. Expected type is 'object'." error.

I need this logic to build incremental pipeline to get the latest folder in the lakehous.

This is the filter activity payload {
"ItemsCount": 6,
"FilteredItemsCount": 1,
"Value": [
{
"name": "New_Extract_2*****64_1*************",
"type": "Folder"
}
]
}

 

Any idea on how to fix errors like these?