web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Gallery using D...
Power Apps
Unanswered

Filter Gallery using DateRange filter

(0) ShareShare
ReportReport
Posted on by Sampath_Kumar 16

Hi All,

 

I am facing an issue when filtering the gallery (Large dataset from CDS) using a date range.


1. I tried like date range of single column and its working fine
             Filter(DataSets,'Valid From'>=DatePicker1.SelectedDate && 'Valid From'<=DatePicker2.SelectedDate )
2. Same like above I want to filter data based on two columns like below, but it's not working

             Filter(DataSets,'Valid From'>=DatePicker1.SelectedDate && 'Valid To'<=DatePicker2.SelectedDate )
Note: Max Date of Valid To column is 12/31/9999 (I updated end year like Today()+10000)

If anyone has any idea please help me with this.

 

Thanks 🙂

Scenario_2.png
data.png
Scenario_1.png
Categories:
Building Power Apps
  • eka24 Profile Picture
    eka24 20,925 on at

    The two formulas are the same. The one working and the one not working. Please which other column do you want to add.

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Sampath_Kumar Profile Picture
    Sampath_Kumar 16 on at

    Hi,

    Thanks for the reply.
    scenario 1 I used both "Valid from" column only, but in second scenario I changed to "Valid To"
    1.  Filter(DataSets,'Valid From'>=DatePicker1.SelectedDate && 'Valid From'<=DatePicker2.SelectedDate )
    2. Filter(DataSets,'Valid From'>=DatePicker1.SelectedDate && 'Valid To'<=DatePicker2.SelectedDate )

  • eka24 Profile Picture
    eka24 20,925 on at

    Try

    Filter(DataSets,Text('Valid From',ShortDate)>=Text(DatePicker1.SelectedDate,ShortDate) && Text('Valid From',ShortDate)<=Text(DatePicker2.SelectedDate,ShortDate))

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Sampath_Kumar Profile Picture
    Sampath_Kumar 16 on at

    Tried below ones 

    error_1.png
    error_2.png

  • eka24 Profile Picture
    eka24 20,925 on at

    Filter(DataSets,Text(Value('Valid From'),ShortDate)>=Text(DatePicker1.SelectedDate,ShortDate) && Text(Value('Valid From'),ShortDate)<=Text(DatePicker2.SelectedDate,ShortDate))

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Sampath_Kumar Profile Picture
    Sampath_Kumar 16 on at

    Hi, Thanks for ur patience and reply.
    When I am using the query in the "gallery.Items", it's not working


    error_5.png


    If I use the same query to display in label its working fine, can you please tell me what will be the issue.


    error_3.png

     

    Thanking you in advance 🙂

  • v-siky-msft Profile Picture
    v-siky-msft Microsoft Employee on at

    Hi @Sampath_Kumar ,

     

    I feel confused with the logic of the second condition, the date of Valid To column is 12/31/9999 which is much greater than selected date, so nothing will return if the condition is 'Valid To'<=DatePicker2.SelectedDate.

    Am I misunderstand something?

    BTW, The Text does not support greater than and less than comparisons.

     

    Sik

  • Sampath_Kumar Profile Picture
    Sampath_Kumar 16 on at

    Hi,

     

    I want to get the data between a selected date range, in that my "Valid To" column max date is 12/31/9999.
    So if I give "valid To"=12/31/2050, I should get all records between dates right?
    so how can I filter the gallery (large datasets) using date range?

  • v-siky-msft Profile Picture
    v-siky-msft Microsoft Employee on at

    Hi @Sampath_Kumar ,

     

    Your filter code is correct, and works properly in my test.

    Snipaste_2020-05-20_11-27-22.png

    If you select the 'Valid To' data picker to 12/31/2050, you can only get the records that the valid to is less than 12/31/2050.

    Please make sure it does exist records that valid to is less than 12/31/2050.

     

    If you just want to return all records when selecting 12/31/2050 (since it is the maximum date we can select), please try this:

    If(DatePicker2.SelectedDate=DateValue("12/31/2050"),
Filter(DataSet,'Valid From'>=DatePicker1.SelectedDate && 'Valid To'<=DateValue("12/31/9999")),
Filter(DataSet,'Valid From'>=DatePicker1.SelectedDate && 'Valid To'<=DatePicker2.SelectedDate)
)

    Hope this helps.

    Sik

  • Sampath_Kumar Profile Picture
    Sampath_Kumar 16 on at

    Sorry for late reply. As I am out of station unable to reply to the msgs.

    I tried the method which you mentioned still i am unable to do.

    I added my data in excel and attaching here. can anyone help me please.

     

    Thank you all 🙂

    TestData.zip

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 397 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 354

#3
WarrenBelz Profile Picture

WarrenBelz 232 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans