Filter without a part?

(0) Share

Report

Posted on by TimmyBoy

997

Hello,

I was wondering how i can filter without showing a status
But only collect the rest?

I like to filter all records without the status "HOLD"
But no idea how to manage it
I get the status from field_15 but no idea what to add
By the way field_15 is a list in our SharePoint list

SortByColumns(
 If(StatusHideHold=true;
 Filter(
 colMyList2; field_3="GET" && field_15=;
 
 Dropdown1_21.SelectedText.Value & " " &Dropdown1_22.SelectedText.Value in MonthValue

 )
 ;
 Filter(
 colMyList2; field_3="GET";
 
 Dropdown1_21.SelectedText.Value & " " &Dropdown1_22.SelectedText.Value in MonthValue

 )
 ); 
 "ENDDATE"; 
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!
I tried
SortByColumns( If(StatusHideHold=true; Filter( colMyList2; field_3="GET" & Concat(field_15;Value) <> "HOLD"; Dropdown1_21.SelectedText.Value & " " &Dropdown1_22.SelectedText.Value in MonthValue ) ; Filter( colMyList2; field_3="GET"; Dropdown1_21.SelectedText.Value & " " &Dropdown1_22.SelectedText.Value in MonthValue ) ); "ENDDATE"; )
But didn't work

Was this reply helpful? Yes No
Verified answer

TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!
Got it solved,
Thanks
Solution:
SortByColumns( If(StatusHideHold=true; Filter( colMyList2; field_3="GET" & && If( Not(Concat(field_15;Value) exactin "HOLD"); false; true )&& Dropdown1_21.SelectedText.Value & " " &Dropdown1_22.SelectedText.Value in MonthValue ) ; Filter( colMyList2; field_3="GET"; Dropdown1_21.SelectedText.Value & " " &Dropdown1_22.SelectedText.Value in MonthValue ) ); "ENDDATE"; )

Was this reply helpful? Yes No