Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
It would appear that Data Factory doesn't recognise [] as an array, you have to createArray(1,2,3...)
Array contains
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 77%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Ryan Abbey
1,186
Reputation points
The below is getting a "Unable to parse expression" error, anyone can tell me what is wrong?
@if(contains([1,2,3,4,5,6,7], item().PipeRoute), 'PC', 'PC2')
Basically, item().PipeRoute is a number, if it is between 1 and 7, I want the result to be "PC" else "PC2"
Azure Data Factory
Answer accepted by question author
-
Ryan Abbey 1,186 Reputation points
2021-08-24T03:21:02.45+00:00 -
Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator2021-08-24T03:51:59.587+00:00 Hey Ryan,
When I tried creating a parameter/variable and calling it in Set variable activity ; ADF executes properly :
@if(contains(pipeline().parameters.Ar, pipeline().parameters.Test), 'PC', 'PC2') -
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator2021-08-24T06:58:00.573+00:00 Hi @Ryan Abbey ,
Thank you for posting on Microsoft Q&A Platform.
Could you please mark your above answer as
Accepted Answer? Accepted answers helps community as well.Yes, you are right, expression language directly will not recognize [] as array, we should utilize createArray() function.
There two ways to overcome this problem,
Option 1: As you mentioned use createArray() function.
Option 2: Create one variable of array type and save your array in to that variable. Use that array in your expression as below.
@if(contains(variables('arrayVar'), 1), 'PC', 'PC2')Here, "arrayVar" is variable to store your array
Sign in to comment -