For Each Loop in Data Factory @item() not working

Question

I am trying to loop over an array of IDs and executing an ADX/ KQL query for each ID.

I have defined the IDs in an array (partly censored).
And I want to then execute an ADX query for each element in the array as defined as follows:

within the loop I have an ADX query block that gives me the following feedback

And if I execute the statement the query looks as follows in the JSON:

And as you can see the @item dynamic content/ variable is not transformed and can therefore not be executed properly. I am just missing something small but I cannot find out what.

Thank you.

Answer 1

Hi Oliver,

Thank you for posting query in Microsoft Q&A Platform.

Here you are writing expression inside string, so you need to use string interpolation syntax to write expressions. Click here to know more about it.

Kindly consider writing your query as below. Please note, for expressions here I am using @{}.

ProductRam
| where deviceid == 
| take 10

Hope this helps. Please let me know if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.