title: Filtering a PowerApps gallery based on multi-choice SharePoint list items and sort said items in gallery
body: <p>hoping someone can point me in the right direction because I can't seem to make this work.</p>
  
  <p>I've got a vertical gallery in my Canvas app that's connected to a customer list in SharePoint Online and I've got a text input box that I want to filter all customers that are in specific deployment phases (phase column is multiple choice in the SP list), I can get the filter to work like so:</p>
  
  <pre><code>Filter(
  [@'MASTER SLM Customer Listings'],
  DeploymentPhase.Value = "Phase 0 - Initiation" ||
   DeploymentPhase.Value = "Phase 1 - Planning" ||
   DeploymentPhase.Value =  "Phase 2 - Build &amp; Test" ||
   DeploymentPhase.Value = "Phase 3 - Tune &amp; Train" ||
   DeploymentPhase.Value = "Phase 4 - Transition to Operational")
  </code></pre>
  
  <p>However, that doesn't achieve my end goal. When I try to do something like this, all sorts of errors are thrown and I can't work out the correct syntax. Also, I am very new to coding/developing apps of any sort.</p>
  
  <pre><code>"SortByColumns(
      Filter(
          [@'MASTER SLM Customer Listings'], StartsWith(DeploymentPhase.Value, searchBox.Text)), "Modified",Ascending)"
  </code></pre>
  
  <p>Ideally, This gallery will be searchable by Customer Name, only show customers in phases 0 - 4, and then sort them starting at Phase 0 and ascending to Phase 4. Any help in making this work would be greatly appreciated. </p>