Power Platform Community Forum Thread Details

Hi community

need some help with filtering a data table with text input control & dropdown controls. I would like to combine all possibilities of the search. So textinput & dropdown together or each alone.
The textinput search works so far. Only in combination with dropdown it does not work properly.

I am grateful for any help.

Filter(Demo_Vertragsmanagement; 
  StartsWith(
    Titel;
    TextInput1.Text
  ) || StartsWith('Verantwortlicher Mitarbeiter'.DisplayName;
  TextInput1.Text
  ) && ( Lieferant.Value = Dropdown1.Selected.Value || Dropdown1.Selected.Value = Blank() = Dropdown1.Selected.Value || Dropdown1.Selected.Value = Blank() )
   && ( Status.Value = Dropdown1_1.Selected.Value || Dropdown1_1.Selected.Value = Blank() )
   && ( VertragArt.Value = Dropdown1_2.Selected.Value || Dropdown1_2.Selected.Value = Blank() 
   )
)

Categories:

Building Power Apps

Hi bob_taylor_pp

You need a couple of extra brackets and you also had an error in the first drop-down filter. Also Len() is better as it covers both IsBlank and IsEmpty.

Filter(
   Demo_Vertragsmanagement;
   (
      StartsWith(
         Titel;
         TextInput1.Text
      ) || 
      StartsWith(
         'Verantwortlicher Mitarbeiter'.DisplayName;
         TextInput1.Text
      )
   ) && 
   ( 
      Lieferant.Value = Dropdown1.Selected.Value || 
      Len(Dropdown1.Selected.Value) = 0 
   ) && 
   ( 
      Status.Value = Dropdown1_1.Selected.Value || 
      Len(Dropdown1_1.Selected.Value) = 0 
   ) && 
   (
      VertragArt.Value = Dropdown1_2.Selected.Value || 
      Len(Dropdown1_2.Selected.Value) = 0
   )
)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee