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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Gallery By Two ...
Power Apps
Answered

Filter Gallery By Two Date Pickers

(0) ShareShare
ReportReport
Posted on by

Hi all (again!),

 

I seem to have had a mind blank and cannot get the following to work; can anyone help?

 

I have a Gallery of records formed from an SP list. I also have two Date Pickers. I would like the gallery to filter the records down to those which have been created between (and including) the two dates selected. I am trying to use the Created column in SP for this.

 

How is this possible? I can't seem to get it to work at all.

 

Many Thanks

 

 

Categories:
I have the same question (0)
  • Verified answer
    Sofie_D Profile Picture
    260 on at

    To compare dates you should use the DateDiff function: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff

    Formula will be something like this:

    Filter(dataSource, DateDiff(date1, Now()) < 0 && DateDiff(Now(), date2) > 0)

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard