filter gallery using string date ranges

(0) Share

Report

Posted on by _sourcecod3_

407

Hi all,

I'm trying to filter a gallery from start date to end date (date pickers). I don't want to run into the delegation issue so i've created a 'strCreated' single line column to use instead. how can i filter the gallery using this field? This is what i have so far but nothing comes up:

Filter(colItems, strCreatedDate >= dpStartDate.SelectedDate && strCreatedDate <= dpEndDate.SelectedDate)

Any clues what I could be missing?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@_sourcecod3_

What is the format of your text date you are storing? It must be stored in the yyyymmdd format.

Then your formula will be:

Filter(colItems, strCreatedDate >= Text(dpStartDate.SelectedDate, "yyyymmdd") && strCreatedDate <= Text(dpEndDate.SelectedDate, "yyyymmdd") )

I hope this is helpful for you.

Was this reply helpful? Yes No
_sourcecod3_ 407 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes i tried your suggestion but it looks like it's looking for a number value. This is the error i get:

When i change the Text to Value instead there are no errors but nothing it being pulled in the gallery.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@_sourcecod3_

Usually PowerApps will cast the value for you, but not always, so give this a try instead:

Filter(colItems, (Value(strCreatedDate) >= Value(Text(dpStartDate.SelectedDate, "yyyymmdd"))) && (Value(strCreatedDate) <= Value(Text(dpEndDate.SelectedDate, "yyyymmdd"))) )

Was this reply helpful? Yes No
_sourcecod3_ 407 on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes This is perfect!! thank yo so much

Was this reply helpful? Yes No
VP2021 24 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
How would you apply the filter to both weekly date range and groupby items ?

Was this reply helpful? Yes No