Announcements
Hi,
I need to be able to search across 3 columns and filter by two date boxes.
This is what I have so far.
Search('Score Shipments_1',TextInput1.Text,"BodyNumber","Packing_List_Number","field_4")
User Filter() instead of Search(), so you can have multiple search fields also, if you use Search, you can't use logic expression like getting the date range.
@nb02187,
@MMPoweR is correct. Filter will allow you to mimic the search functionality whilst also allowing you to add the DatePicker filters - within one function.
Filter( 'Score Shipments_1', //Adjust the column names accordingly TextInput1.Text in 'Body Number' || TextInput1.Text in 'Packing_List_Number' || TextInput1.Text in 'field_4', IsBlank(StartDatePicker.SelectedDate) || DateField >= StartDatePicker.SelectedDate, IsBlank(EndDatePicker.SelectedDate) || DateField <= EndDatePicker.SelectedDate )
Please note that you will have to adjust the datepicker control names and possibly the column names.
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
Thank you so much for your help! How would I go about making it so the latest record is at the top of the gallery?
You can enclose the Filter with the Sort function:
Sort( Filter( //Your code ), DateField, SortOrder.Descending )
I hope this helps!
I tried it out, but I think there is an issue with the name for my date column. I get the following error.
The Sort parameters are currently written in the Filter statement. Closing the filter function first, should resolve the issue.
Thank you for all your help! I screen shot was covering up part of the code where I have the sort parameters separated from the filter statement. Not sure if there is something else that I'm missing and that's why it's not working.
Could you remove the opening bracket before your IsBlank(dpEndDate.SelectedDate) function, that should solve the issue.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
