Filter items beetwen two dates

(0) Share

Report

Posted on by Karolina776

133

Hello ,

I want to filter items in the gallery in power apps to find items created, for example, in one month.

I created two data picker, and I want to choose two dates, and find items between them.

I wrote formula in items properties of the gallery:

Filter(
'Instrukcje Tymczasowe',
Created < DatePicker2_1,
Created > DatePicker2_2
)

But it doesn't not work. How should I do that ?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

gcmfaizan 1,022 on at

Like
a
(1)

Report
Copy link

Link copied!
@Karolina776 your logic is almost fine you just missing one thing which is = sign here is the right formula:
Filter( 'Instrukcje Tymczasowe', Created >= DatePicker2_1.SelectedDate, Created <= DatePicker2_2.SelectedDate )

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like
a
(0)

Report
Copy link

Link copied!

The answer above is not correct.

Using an = will slightly modify the criteria but it's not the cause of your issue. The = sign will include the date selected, the > sign on it's own will not.

e.g.
02/09/2023 > 02/09/2023 = false. Records created on 02/09/2023 would not be included.
02/09/2023 >= 02/09/2023 = true. Records created on 02/09/2023 would be included.

The way your formula is written, DatePicker2_1 MUST be the future date, and DatePicker2_2 MUST be the past. Check this is correct? The function looks fine.

Was this reply helpful? Yes No
Karolina776 133 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, it works but...
Now I am trying to add it to rest formulas. It looks like that :
Search(
Filter(
'Instrukcje Tymczasowe',
IsBlank(Dropdown2_1.Selected.Value) ||
Status.Value=Dropdown2_1.Selected.Value,
IsBlank(Dropdown2.Selected.Value) ||
Dział.Value=Dropdown2.Selected.Value),
IsBlank(DatePicker2.SelectedDate) ||
Created >= DatePicker2.SelectedDate,
IsBlank(DatePicker2_3.SelectedDate) ||
Created <= DatePicker2_3.SelectedDate
)
SearchBox.Text, "Title")

Without formulas including date everything worked. Do you have an idea what the problem is ?

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like
a
(0)

Report
Copy link

Link copied!

You're missing a comma after the Filter() statement.

Was this reply helpful? Yes No
Karolina776 133 on at

Like
a
(0)

Report
Copy link

Link copied!

Like this ?
Still not working 😞

Was this reply helpful? Yes No
Karolina776 133 on at

Like
a
(0)

Report
Copy link

Link copied!

Formula which was working looks like this:

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
@Karolina776 can you try this formula there:
Search( Filter( 'Instrukcje Tymczasowe', (IsBlank(Dropdown2_1.Selected.Value) || Status.Value = Dropdown2_1.Selected.Value) && (IsBlank(Dropdown2.Selected.Value) || Dział.Value = Dropdown2.Selected.Value) && (IsBlank(DatePicker2.SelectedDate) || Created >= DatePicker2.SelectedDate) && (IsBlank(DatePicker2_3.SelectedDate) || Created <= DatePicker2_3.SelectedDate) ), SearchBox.Text, "Title" )

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
Karolina776 133 on at

Like
a
(0)

Report
Copy link

Link copied!

I think I got it:

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like
a
(0)

Report
Copy link

Link copied!
You don't need to use those IsBlank statements.

IsBlank( Value) || Value = 3 If Value is blank: true || Value = 3 What is true? If Value is not blank: false || Value = 3 What is false? The answer to both question is nothing, because it's not related to any column in the data.

You can simplify by removing the IsBlank() statements. If the fields are blank the Filter just won't return records.

Was this reply helpful? Yes No
Karolina776 133 on at

Like
a
(0)

Report
Copy link

Link copied!

OK, you are right. Thank you.

Do you have any idea how to add to my formula : sort Descending ?

Search(
Filter(
'Instrukcje Tymczasowe',
IsBlank(Dropdown2_1.Selected.Value) ||
Status.Value=Dropdown2_1.Selected.Value,
IsBlank(Dropdown2.Selected.Value) ||
Dział.Value=Dropdown2.Selected.Value,
Created >= DatePicker2.SelectedDate,
Created <= DatePicker2_3.SelectedDate),
SearchBox.Text, "Title")

Was this reply helpful? Yes No