Array contains

Ryan Abbey 1,186

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"

0 comments

Answer accepted by question author

Ryan Abbey 1,186

It would appear that Data Factory doesn't recognise [] as an array, you have to createArray(1,2,3...)

Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator

2021-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,631 Reputation points Microsoft Employee Moderator

2021-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

0 additional answers

Your answer