Unanswered

Filter within a date range

(0) Share

Report

Posted on by JamtMaster

140

Hello, I need the gallery to only show me the information within a range of dates that the user will select and then filter what he wants within that date range, if I use both codes separately it filters me by date or by the box of text but if I try to make it filter what the user writes inside the text box in the range that is selected then it does not work, what would be the correct way? I leave the code that I am trying to use:

Filter(CarReport;Date>=DTPStart.SelectedDate;Date<=DTPFin.SelectedDate)
&&
SortByColumns(Filter([@CarReport];StartsWith(Lote;txtsearch.Text));"Date";Ascending)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

timl 36,377 Super User 2025 Season 2 on at

Like (2)

Report
Hi @JamtMaster

You can combine the the date and text input in your search like so:

SortByColumns(Filter([@CarReport]; StartsWith(Lote;txtsearch.Text) && Date>=DTPStart.SelectedDate && Date<=DTPFin.SelectedDate) ); "Date"; Ascending )

Was this reply helpful? Yes No
Verified answer

JamtMaster 140 on at

Like (0)

Report
That code gave me an error (it says that an argument was placed and I expected more than 1) but looking at the way you organized it I put it in the following way and it worked for me so I mark it as valid, thank you very much.

SortByColumns (Filter ([@ CarReport]; StartsWith (Batch; txtsearch.Text); Date> = DTPStart.SelectedDate; Date <= DTPFin.SelectedDate); "Date"; Ascending)

Was this reply helpful? Yes No