title: How to pass values in ForEach in Azure Data Factory?
body: <p>I would like to create ForEach loop and need advice:</p>
  <ol>
  <li>I have &quot;Fetch&quot; Lookup with &quot;Select CustomerName, Country From Customers&quot;.</li>
  <li>It return rows like &quot;Tesla, USA&quot; and &quot;Nissan, Japan&quot;. There are total 10 rows.</li>
  <li>I would like to run ForEach loop for 10 times and use CustomerName and Country value in pipeline.</li>
  <li>ForEach settings values are current set: @activity('Fetch').output (something wrong here?)</li>
  <li>I would like to create new Lookup inside ForEach. I would like in Lookup query &quot;SELECT * FROM Table WHERE CustomerName = 'CustomerName' and Country = 'CountryName'&quot;</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/uaQRM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uaQRM.png" alt="enter image description here" /></a></p>
  <p>Error of ForEach:</p>
  <pre><code> The function 'length' expects its parameter to be an array or a string. The provided value is of type 'Object'.
  </code></pre>