title: Selecting property from nested JSON array stored within Logic App variable
body: <p>I am struggling to select a property from a JSON array that I've stored in a variable (as an array). I receive the following error:</p>
  <blockquote>
  <p>The execution of template action 'Select' failed: The evaluation of 'query' action &gt;'where' expression '{
  &quot;Response&quot;: &quot;@variables('UserEvents').responseStatus.response&quot;,
  &quot;trest&quot;: &quot;&quot;
  }' failed: 'The template language expression &gt;'variables('UserEvents').responseStatus.response' cannot be evaluated because property &gt;'responseStatus' cannot be selected. Array elements can only be selected using an &gt; integer index. Please see <a href="https://aka.ms/logicexpressions" rel="nofollow noreferrer">https://aka.ms/logicexpressions</a> for usage details.'.</p>
  </blockquote>
  <p>The JSON is below:</p>
  <pre><code>[
    {
      &quot;value&quot;: [
        {
          &quot;responseStatus&quot;: {
            &quot;response&quot;: &quot;notResponded&quot;,
            &quot;time&quot;: &quot;0001-01-01T00:00:00Z&quot;
          }
        }
      ]
    }
  ]
  </code></pre>
  <p>I'm trying to select the 'response' property only by using the following expression:</p>
  <p>@variables('UserEvents').responseStatus.response</p>
  <p>I have tried adding [0] to various parts of the above expression but it doesn't seem to make any difference. I am sure it's pretty simple and I'm just getting the syntax wrong, but am completely stuck!</p>
  <p>Any help appreciated - thanks.</p>
  <p>Adrian</p>