How to add another Filter option when you already have a Date Picker

[JEVANSAP]

Hi All

I have a gallery in which i have already got a Date Picker that i am able to Filter by using the Formula in the Items in the gallery. 

If(IsBlank(DatePicker1.SelectedDate),'Harbour House Key History',Filter('Harbour House Key History', 'Date Out' = DatePicker1.SelectedDate))

I now want to add a Text input search function that will be able to filter on another column. also with the function that if the text input is blank i can see all results. 

Data Source: 'Harbour House Keys'

Column: 'Name in'

Text Input: TextInput1

Kind Regards

Justin 

[TylerPA]

Try setting up your filter this way; should allow you to add more options as needed

Filter(
'Harbour House Key History',
If(IsBlank(DatePicker1.SelectedDate), true, 'Date Out'=DatePicker1.SelectedDate),
If(IsBlank(TextInput1), true, 'Name in'=TextInput1.Text)
)

[JEVANSAP]

Hi Thank you for your reply 

I Tried this Formula and unfortunately this formula doesn't bring back any results for me in my gallery.  

I also got back a delegation warning on the date picker line. 

Kind regards

Justin

[TylerPA]

Can you check if the column is 'Name in' vs 'Name In'?

If you are trying to avoid delegation issues, I would recommend collecting the 'Harbour House Key History' during OnVisible

Clear(collectHistory);

Collect(collectHistory, 'Harbour House Key History');

And then filter collectHistory, instead of the source

[NandiniBhagya20]

Hi @JEVANSAP ,

If 'Name in' is of type choice, then you can use - 

Filter('Harbour House Keys', (IsBlank(DatePicker1.SelectedDate) || StartDate > DatePicker1.SelectedDate) And StartsWith('Name in'.Value, TextInput1.Text))

[JEVANSAP]

I have added a collection as suggested 'CollectHistory' and done some testing on different variations of the formulas from the both of your reply's unfortunately these are still coming up with errors.

I think i might have to do it differently, instead of filtering on both, maybe i could do it where i can either Search Via date or Via Name.  

f(IsBlank(DatePicker1.SelectedDate),collectHistory,Filter('Harbour House Key History', 'Date Out' = DatePicker1.SelectedDate) Or Search(collectHistory,TextInput3.Text,"NameIn","NameOut"))

This is the formula i came up with but whatever i change i still get the message: The Function Search 'Search' Has some invalid Arguments. 

[NandiniBhagya20]

Hi @JEVANSAP ,

Try using below formula - 

If(IsBlank(DatePicker1.SelectedDate), collectHistory, Search(Filter('Harbour House Key History', 'Date Out' = DatePicker1.SelectedDate),TextInput3.Text,"NameIn","NameOut"))

[JEVANSAP]

Hi @NandiniBhagya20 

I tried this formula and it still dosnt work. If i just have the formula for the date picker it works, but as soon as i want to add the text search in i get red X everywhere. I think i might have to just have the date picker as my only filter function. 

Kind Regards

Justin

[TylerPA]

Justin,

We should be able to figure this out; taking a step back

- What are the column types from your source for date, name?

- If you just put the text input as your filter, no date - what's the error message?

With the column types, I can try to build it out fully later

[NandiniBhagya20]

Try removing the collection and directly use the list name as data source - 

If(IsBlank(DatePicker1.SelectedDate), 'Harbour House Key History', Search(Filter('Harbour House Key History', 'Date Out' = DatePicker1.SelectedDate),TextInput3.Text,"NameIn","NameOut"))