title: Power Apps Gallery Filter based on two values
body: <p>I am busy creating my first power app and have hit a snag when trying to filter a gallery (SharePoint Linked) based on multiple values. I have three formulas for now as follows:</p>
  
  <pre><code>Filter([@'Demo Stock']; StartsWith('Part Number'; txt_ItemSearch.Text)
  Filter('Demo Stock';Warehouse.Value=WarehouseFilter.SelectedText.Value)
  Filter('Demo Stock';'Item Status'.Value="Available")
  </code></pre>
  
  <p>Each of these work independently. What would the syntax be to use all of these filters together?</p>
  
  <p>This does not work:</p>
  
  <pre><code>SortByColumns(Filter([@'Demo Stock']; StartsWith('Part Number'; txt_ItemSearch.Text);'Demo Stock';Warehouse.Value=WarehouseFilter.SelectedText.Value;'Demo Stock';'Item Status'.Value="Available");"Part Number";Ascending)
  </code></pre>
  
  <p>Thanks,
  Steven</p>