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

(0) Share

Report

Posted on by JEVANSAP

101

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

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

Sort by

TylerPA 201 on at

Like
a
(1)

Report
Copy link

Link copied!
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) )

Was this reply helpful? Yes No
JEVANSAP 101 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TylerPA 201 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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))

Was this reply helpful? Yes No
JEVANSAP 101 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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"))

Was this reply helpful? Yes No
JEVANSAP 101 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TylerPA 201 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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"))

Was this reply helpful? Yes No
JEVANSAP 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TylerPA

I tried this formula "Search(collectHistory,TextInput4.Text,"NameIn")"
And instead of getting all the errors i am just getting it in that 1 column. ( i don't know why this is)

I am still getting this message: The Function Search 'Search' Has some invalid Arguments.

My Date Colum is a date picker and my Name in and Name out is a person Picker.

Thanks for looking into this

Justin

Was this reply helpful? Yes No