Need help with filtering

(0) Share

Report

Posted on by iiSmitty

Hi guys,

I am new to Power Apps and busy developing an application for a client.

I am stuck with a filter not working:

XmThRiR

When "Any" is selected in the Document Controller Name, it does not display data but works perfectly fine when you select a DC.

Here is my code for it:

Search(
 Filter(
 'DummyData',
 If(
 varCurrentTab = "All Projects",
 true,
 varCurrentTab = "Active",
 Status = "Active",
 varCurrentTab = "On Hold",
 Status = "On Hold",
 varCurrentTab = "Complete",
 Status = "Complete",
 varCurrentTab = "Terminated",
 Status = "Terminated",
 varCurrentTab = "Funding Request",
 Status = "Funding Request",
 varCurrentTab = "Pipeline",
 Status = "Pipeline",
 varCurrentTab = "Unknown",
 Status = "Unknown"
 ),
 DC = dc_dropdown_1.Selected.Result
 ),
 search.Text,
 "Name",
 "Site",
 "Code"
)

How can I fix this problem? Any assistance will be much appreciated.

Thanks,
Andrew

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!
Can you try:

Search( Filter( 'DummyData', (varCurrentTab = Status || If(varCurrentTab = "All",true)), DC = dc_dropdown_1.Selected.Result ), search.Text, "Name", "Site", "Code" )

Was this reply helpful? Yes No
iiSmitty 14 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the reply, close but no cigar!

I tried running the code but sadly it is just outputting nothing.

Tweaked the code a bit but am still stuck on the same problem, doesn't show all data when 'Any' is selected for DC:

Search( Filter( DummyData, varCurrentTab = Status || If(varCurrentTab = "All Projects",true) || If(dc_dropdown_1.Selected.Result = "Any",true), DC = dc_dropdown_1.Selected.Result ), search_1.Text, "Name", "Site", "Code" )

For what it is worth, I made a collection for the DCs on the screen (OnVisible property):

ClearCollect( collectDC, {Result: "Any"} ); Collect( collectDC, Distinct( DummyData, DC ) ); Set( varCurrentTab, "All Projects" );

Not sure if this is perhaps where the error can be or contributed from?

Was this reply helpful? Yes No
iiSmitty 14 on at

Like
a
(0)

Report
Copy link

Link copied!
Managed to get the code working. Unfortunately, the date does not filter at all.

Search( If( // NO FILTERING dc_dropdown.Selected.Result = "Any" And varCurrentTab = "All Projects", DummyData, // FILTER FOR TABBING dc_dropdown.Selected.Result = "Any" And varCurrentTab <> "All Projects", Filter(DummyData, varCurrentTab = Status), // FILTER FOR DC dc_dropdown.Selected.Result <> "Any" And varCurrentTab = "All Projects", Filter(DummyData, DC = dc_dropdown.Selected.Result), // FILTER FOR TABBING AND DC dc_dropdown.Selected.Result <> "Any" And varCurrentTab <> "All Projects", Filter(DummyData, DC = dc_dropdown.Selected.Result And varCurrentTab = Status), // FILTER DATE Filter(DummyData,'Start' >= dte_StartDate,'End' <= dte_EndDate) ), search.Text, "Name", "Site", "Code" )

The confusing part for me is that I can see it has the correct result but not displaying it?

Was this reply helpful? Yes No
Verified answer

iiSmitty 14 on at

Like
a
(0)

Report
Copy link

Link copied!
So I figured out the problem. The date filter was in the else statement and of course the if statement was true so was never executed.

Here is the final code that works flawlessly:

Search( If( // DATE FILTER dc_dropdown.Selected.Result = "Any" And varCurrentTab = "All Projects", Filter(DummyData, Start >= dte_StartDate, End <= dte_EndDate), // NO FILTERING dc_dropdown.Selected.Result = "Any" And varCurrentTab = "All Projects", DummyData, // FILTER FOR TABBING dc_dropdown.Selected.Result = "Any" And varCurrentTab <> "All Projects", Filter(DummyData, varCurrentTab = Status, Start >= dte_StartDate, End <= dte_EndDate), // FILTER FOR DC dc_dropdown.Selected.Result <> "Any" And varCurrentTab = "All Projects", Filter(DummyData, DC = dc_dropdown.Selected.Result, Start >= dte_StartDate, End <= dte_EndDate), // FILTER FOR TABBING AND DC dc_dropdown.Selected.Result <> "Any" And varCurrentTab <> "All Projects", Filter(DummyData, DC = dc_dropdown.Selected.Result And varCurrentTab = Status, Start >= dte_StartDate, End <= dte_EndDate) ), search.Text, "Name", "Site", "Code" )

Was this reply helpful? Yes No