title: How to do a OData query filter for a path in the Azure Logic App "Get Files" action?
body: <p>The action &quot;Get files (properties only)&quot; is returning the properties of all files in a certain directory of a SharePoint document library. And when checking the output, I see that in the ODATA json is a field:</p>
  <p><code>&quot;{Path}&quot;:&quot;Report/xxx/Finalized_Reports/2014/2014_01/&quot;</code></p>
  <p>With this Filter Query setting:
  <a href="https://i.stack.imgur.com/faBsI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/faBsI.png" alt="enter image description here" /></a>
  I get this warning:</p>
  <pre><code>{
  &quot;status&quot;: 400,
  &quot;message&quot;: &quot;Column 'Path' does not exist. It may have been deleted by another user.&quot;
  }
  </code></pre>
  <p>If I do <code>substringof('text', {Path})</code> the error is</p>
  <pre><code>{
  &quot;status&quot;: 400,
  &quot;The expression \&quot;substringof('test', {Path})\&quot; is not valid. Creating query failed.&quot;
  }
  </code></pre>
  <p><code>substringof('test', ''{Path}''</code> gives me also the &quot;expression is not valid&quot; error.</p>
  <p><code>substringof('test', '{Path}')</code> this gives me this error</p>
  <pre><code>{
    &quot;status&quot;: 400,
    &quot;message&quot;: &quot;The function operator 'substringof' is not supported or its usage is invalid.&quot;
  }
  </code></pre>
  <p>If I do <code>susbstringof('text', Author)</code> the query does not fail. So, the function seems to be supported.</p>