Dropdown Filter in Gallery not working

(1) Share

Report

Posted on by bob_taylor_pp

203

Hi community

Unfortunately, the filters in the corresponding dropdowns do not work as soon as I make a selection. The search via the text input works.

Filter(Demo_Vertragsmanagement; 
  StartsWith(
    Titel;
    TextInput1.Text
  ) || StartsWith('Verantwortlicher Mitarbeiter'.DisplayName;
  TextInput1.Text
  ) && ( Lieferant.Value = 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() )
   
   
   )  
 
 
I am grateful for any help or tips.
 
Greetings 

 

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

gulshankhurana 1,397 Moderator on at

Like (1)

Report

Hi

Sorry, marked your post as spam by mistake as I was marking hundreds of spam posts as spam so my fingers kinda went mechanical and I mistakenly marked your post as spam too. So sorry. Please could you post your query again in a new post so that it could be looked into and answered by the community members.

Kind regards

Gulshan

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

Based on what I see, you forgot to add ( ) around the to Starts With I added them in Mine, you had the II but you want that Or to be one thing, versus the &&'s.

Filter(Demo_Vertragsmanagement;

  (StartsWith(

Titel;

  TextInput1.Text

  ) || StartsWith('Verantwortlicher Mitarbeiter'.DisplayName;

  TextInput1.Text

  )) && ( Lieferant.Value = 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() )

)

Was this reply helpful? Yes No
bob_taylor_pp 203 on at

Like (0)

Report

I have adjusted the formula. Unfortunately, it still does not work. How would you build the formula? To use all relevant controls. TextBox, Dropdown, etc...

Filter(
'Demo_Vertragsmanagement',
StartsWith(Titel, TextInput1.Text) &&
(Dropdown1.Selected.Value = Blank() || Lieferant.Value = Dropdown1.Selected.Value) &&
(Dropdown1_1.Selected.Value = Blank() || Status.Value = Dropdown1_1.Selected.Value) &&
(Dropdown1_2.Selected.Value = Blank() || Status.Value = Dropdown1_2.Selected.Value)
)

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Hi Bob,

You can try splitting the search and dropdown filtering into two separate activities. Collect the records based on the search text in the textinput control then use this collection as the Data Source for your Gallery.

OnChange property of your TextInput1 control -
ClearCollect(Records, ForAll(Distinct(Filter(Split(TextInput1.Text," "), Value <> ""), Value), Search(Demo_Vertragsmanagement , Value, Titel)))

Items property of the gallery

Filter(Records, (Dropdown1.Selected.Value = Blank() || Lieferant.Value = Dropdown1.Selected.Value) && (Dropdown1_1.Selected.Value = Blank() || Status.Value = Dropdown1_1.Selected.Value) && (Dropdown1_2.Selected.Value = Blank() || Status.Value = Dropdown1_2.Selected.Value) )

I have not tried this but do let me know if you face any issues. Thanks.

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Suggested answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey

can u also try this:

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

please mark as verified if it helped

Was this reply helpful? Yes No