Filter Gallery by 4 dropdowns/Text Box with &&& combined

(0) Share

Report

Posted on by RSST-SOR

Hello all,

I have an connection to a database and I want to Filter by:

2 text boxes
1 radio
1 drop box

I am looking not for an "OR" filter I am looking for and AND/&& filter like:

Screenshot 2024-06-28 141819.jpg

SortByColumns(
 If(
 IsBlank(ProjectNo.Text);
 Dokumentenverwaltung;
 If(
 IsBlank(DokuPrefixDrop.SelectedText.Value);
 If(
 IsBlank(DocumentNo.Text);
 If(
 IsBlank(Radio1.Selected.Value);
 Dokumentenverwaltung;
 Filter(
 Dokumentenverwaltung;
 ProjectNo.Text = Auftragsnummer
 )
 );
 If(
 IsBlank(Radio1.Selected.Value);
 Filter(
 Dokumentenverwaltung;
 DocumentNo.Text in DokuNummer
 );
 Filter(
 Dokumentenverwaltung;
 ProjectNo.Text = Auftragsnummer

Is there an easy fix ?

Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @RSST-SOR ,
To achieve the desired AND filter functionality, you can use nested If statements to check the conditions for each filter. If all conditions are met, the data should be filtered accordingly. If any of the conditions are blank, it should not filter based on that condition

SortByColumns( Filter( Dokumentenverwaltung, (IsBlank(ProjectNo.Text) || ProjectNo.Text = Auftragsnummer) && (IsBlank(DokuPrefixDrop.SelectedText.Value) || DokuPrefixDrop.SelectedText.Value in DokuPrefix) && (IsBlank(DocumentNo.Text) || DocumentNo.Text in DokuNummer) && (IsBlank(Radio1.Selected.Value) || Radio1.Selected.Value = SomeField) // Replace SomeField with the appropriate field to compare with the radio button value ), "SomeColumn" // Replace SomeColumn with the column you want to sort by )

Was this reply helpful? Yes No
RSST-SOR 19 on at

Like
a
(0)

Report
Copy link

Link copied!

THX - I have done the required modifications and it works brilliant

Was this reply helpful? Yes No
RSST-SOR 19 on at

Like
a
(0)

Report
Copy link

Link copied!
In one Dropdown I filter Distinct the items with

Distinct( Filter( DRAReport; DD_ProjectNoClient_II.Selected.Value in KundenProjektnummer ); Gefahrenursprung )

But it is not working proper due to there are to less results - only 3 and there should be 9

Whats wrong?

Please help

Was this reply helpful? Yes No