title: PowerApps Filter gallery based on input text lookup from relational sharpoint list
body: <p>here I'm working on PowerApps I have 2 SharePoint lists one is challan list and one is challan details and I combine both in one gallery using the lookup function Eg:
  <code>LookUp('Challan List',ID=ThisItem.CListID,Title)</code>
  so for that I user multi filtering functionality, it used perfectly with combo box with pending challan and product name but now I want to search by challan list where i can search record by title and customer name my gallery item look like this for filtering.
  <strong>eg:</strong></p>
  <pre><code>    If(
    //this is for all and all
          ComboBox2.Selected.Result = &quot;All&quot; And DisplayDD.Selected.Value = &quot;All&quot;,
          'Challan Details',
      //this is for all product and selected challan status
          ComboBox2.Selected.Result = &quot;All&quot; And DisplayDD.Selected.Value &lt;&gt; &quot;All&quot;,
          Filter(
             'Challan Details',
              DisplayDD.SelectedText.Value = &quot;Pending&quot; in Text(IsBlank(Remarks))
          ),
      //this is for selected product and all challan status
          ComboBox2.Selected.Result &lt;&gt; &quot;All&quot; And DisplayDD.Selected.Value = &quot;All&quot;,
          Filter(
              'Challan Details',
              Title = ComboBox2.Selected.Result
          ),
      //this is for selected product and selected challan status
          ComboBox2.Selected.Result &lt;&gt; &quot;All&quot; And DisplayDD.Selected.Value &lt;&gt; &quot;All&quot;,
          Filter(
              'Challan Details',
              Title = ComboBox2.Selected.Result &amp; DisplayDD.SelectedText.Value = &quot;Pending&quot; in Text(IsBlank(Remarks))
      //this for searchbox 
          )),
      &quot;Created&quot;,
      Descending
  )
    
  </code></pre>
  <p>so could you please tell me how to implement a filter gallery based on the search box using this code or another?<a href="https://i.stack.imgur.com/pGy3f.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pGy3f.png" alt="enter image description here" /></a></p>