Hi, i have six textsearchboxes, and in last i want search and filter records by date.
How can i search items in TextSearchBox6 by date. This is my code:
I create two data pickers DataPicker1 and DataPicker2 and write code but, it dosen't work
Filter( Shortages, ( IsBlank(TextSearchBox1.Text) || TextSearchBox1.Text in crd55_item ) && ( IsBlank(TextSearchBox2.Text) || TextSearchBox2.Text in crd55_mco ) && ( IsBlank(TextSearchBox3.Text) || TextSearchBox3.Text in crd55_productionline ) && ( IsBlank(TextSearchBox4.Text) || TextSearchBox4.Text in crd55_typeno ) && ( IsBlank(TextSearchBox5.Text) || TextSearchBox5.Text in crd55_vendor ) && ( (ShortageDate >= DatePicker1.SelectedDate Or IsBlank(DatePicker1.SelectedDate) ) And (ShortageDate < DateAdd(DatePicker2.SelectedDate, 1, Days) Or IsBlank(DatePicker2.SelectedDate) ) ) && ( IsBlank(TextSearchBox7.Text) || TextSearchBox7.Text in crd55_comments ) && ( IsBlank(ComboBox1.Selected.Value) || Status = ComboBox1.Selected.Value ) )
Solved! Go to Solution.
Is shortage date a date field or is it text?
If you take the Date filter piece out, does the rest of the filter work correctly?
When I am working with an issue like this, what I do is to just work with the problem piece. Then when I have fixed that, I put it back together. So my suggestion to you is to save your filter text in a notepad temporarily and only filter on the date. Work with the date filter until you get it working.
I tried to debug the code this way, but unfortunately it didn't work. My date is entered via date only but displayed in the gallery via label, where the value of label is ThisItem.'Shortage Date' . Maybe this has some effect?
Is the gallery showing the data source directly or is it a collection from the data source?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.