Search Filter and Sort Gallery

(0) Share

Report

Posted on by marczh

107

I tried searching, filtering and sorting my gallery and almost suceeded 😉

I get the text box, the sort functions and one drop down filter to work, but when i try to include the second drop down filter, I fail.

With this code, the first drop down is working just fine.

SortByColumns(
 Search(
 If(
 DropdownStatus.Selected.Result = "Alle";
 'Reporting Vermietung';
 Filter(
 'Reporting Vermietung';
 'Status Text' = DropdownStatus.Selected.Result
 )
 );
 TextSearchBox1_1.Text;
 "Objekt";
 "PFM";
 "Status_x0020_Text";
 "Mieter"
 );
 SortColumn;
 If(
 SortDescending1;
 Descending;
 Ascending
 )
)

I tried to include the second filter drop down like this, but it's not working properly:

SortByColumns(
 Search(
 If(
 DropdownStatus.Selected.Result = "Alle" || DropdownPFM.Selected.Result = "Alle";
 'Reporting Vermietung';
 Filter(
 'Reporting Vermietung';
 'Status Text' = DropdownStatus.Selected.Result || PFM = DropdownPFM.Selected.Result
 )
 );
 TextSearchBox1_1.Text;
 "Objekt";
 "PFM";
 "Status_x0020_Text";
 "Mieter"
 );
 SortColumn;
 If(
 SortDescending1;
 Descending;
 Ascending
 )
)

Many thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @marczh

Please try this
With( {_Item: 'Reporting Vermietung'}; SortByColumns( Search( If( DropdownStatus.Selected.Result = "Alle" || DropdownPFM.Selected.Result = "Alle"; _Item; Filter( _Item; 'Status Text' = DropdownStatus.Selected.Result || PFM = DropdownPFM.Selected.Result ) ); TextSearchBox1_1.Text; "Objekt"; "PFM"; "Status_x0020_Text"; "Mieter" ); SortColumn; If( SortDescending1; Descending; Ascending ) ) )

Was this reply helpful? Yes No
marczh 107 on at

Like
a
(0)

Report
Copy link

Link copied!

When I select the first dropdown nothing happens when I select the second drop down it is filtering something in a wrong weird way. The search box is working finde. Eventough there is no error message from the code.

I think the problem is maybe in the Or Statement for the two filters?

Was this reply helpful? Yes No
marczh 107 on at

Like
a
(0)

Report
Copy link

Link copied!
with this code

With( {_Item: 'Reporting Vermietung'}; SortByColumns( Search( If( DropdownStatus.Selected.Result <> "Alle" Or DropdownPFM.Selected.Result <> "Alle"; Filter( _Item; 'Status Text' = DropdownStatus.Selected.Result Or PFM = DropdownPFM.Selected.Result ); _Item ); TextSearchBox1_1.Text; "Objekt"; "PFM"; "Status_x0020_Text"; "Mieter" ); SortColumn; If( SortDescending1; Descending; Ascending ) ) )

The Dropdowns are working but just if One of them is set to "Alle"

Is there a way they work both dynamically together despite the value of the other?

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @marczh

Both Dropdown selection is optional now.
With( {_Item: 'Reporting Vermietung'}; SortByColumns( Search( Filter( _Item, (DropdownStatus.Selected.Result = "Alle" || 'Status Text' = DropdownStatus.Selected.Result) && (DropdownPFM.Selected.Result = "Alle" || PFM = DropdownPFM.Selected.Result) ); TextSearchBox1_1.Text; "Objekt" "PFM"; "Status_x0020_Text"; "Mieter" ); SortColumn; If( SortDescending1; Descending; Ascending ) ) )

Was this reply helpful? Yes No
marczh 107 on at

Like
a
(0)

Report
Copy link

Link copied!

@StalinPonnusamy Thank you very much, this works out just fine! Even if don't understand a 100% of the syntax 🙂

Was this reply helpful? Yes No