Filter Collection with multi dropdown, search and NOT()

(0) Share

Report

Posted on by StuCundy

377

Hi there,

My Gallery for "colSearchHost" is Filtered with the below. I want the result Items in ColSearchHost only if they are NOT in another list called HostSearch list.
Note "And Not(ID in HostSearch.HostsID

Search(
If(
//All
 TyepOfStayDropdown.Selected.Result="All" ,colSearchHost,
//Selected Stay Types
TyepOfStayDropdown.Selected.Result<>"All" , 
Filter(colSearchHost, TypeOfStay = TyepOfStayDropdown.Selected.Result And Not(ID in HostSearch.HostID))),
//SearchBox by Surname
TextInput1.Text,"HFsurname")

The above does not work but does not give an error so Im close I feel.
I need to have the same "NOT" set for the //All and //SearchBox functions and I was hoping someone could help me. I have tried many ways but just get errors.

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

StuCundy 377 on at

Like
a
(0)

Report
Copy link

Link copied!
I managed to solve it myself. Just needed a filter on the All and the search does not need NOT as it just searches from within the Filtered results.

Search( If( //All TyepOfStayDropdown.Selected.Result="All" , Filter(colSearchHost, Not(ID in HostSearch.HostID)), //Selected Stay Types TyepOfStayDropdown.Selected.Result<>"All" , Filter(colSearchHost, TypeOfStay = TyepOfStayDropdown.Selected.Result And Not(ID in HostSearch.HostID))), //SearchBox by Surname TextInput1.Text,"HFsurname")