Power Apps Filter A Gallery By Date Range Examples

Power Apps Filter A Gallery By Date Range Examples

Welcome to my Power Apps guide on how to filter a gallery by a date range.

Inside you will find 26 examples of common scenarios filtering a Power Apps gallery by date range. Each page contains code and visuals to show what the code is doing. COPY + PASTE code from the guide into your own app.  Just change the datasource name and column names to match your own.


This guide will grow as I add more examples so be sure to bookmark it!


Basics


Filter A Date Range By Day


Filter A Date Range By Week


Filter A Date Range By Month


Filter A Date Range Quarter


Filter A Date Range By Year




Did You Enjoy This Article?

Subscribe at the bottom of this page to have new articles sent directly to your inbox the moment I post them.


Questions?

If you have any questions or feedback about Power Apps Filter A Gallery By Date Range Examples please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion.

Subscribe
Notify of
guest
18 Comments
Oldest
Newest
Inline Feedbacks
View all comments
Akbar Alam
Akbar Alam
1 year ago

This is very helpful indeed

Ninett Hesse
1 year ago

Just what I was looking for this last month!

Juli
Juli
1 year ago

Very timely! I just needed it today

Jeeten Kumar
Jeeten Kumar
1 year ago

Awesome. This definitely helps. Thank you!.
I have a quick question. How do I get the week number for the current week in canvas app?

moyura
moyura
1 year ago

How would you filter by Name and weekly date range ?

Andre
Andre
11 months ago

I have 2 lists.
1 has the list of cars information about the car with registration plate etc.
2 has a startdate and endate and the selected car numberplate when booked.

I want to have users select a startdate and an enddate. then the gallery should shown only the cars that are available for booking during that datetime period. .

Jacob Swann
Jacob Swann
5 months ago
  • I am trying to use this formula Dates In Previous ‘N’ Months and then have it sort newest items at the top. Having trouble placing the sort function so that it will work.
Jez Holland
Jez Holland
2 months ago

Here is an interesting challenge i am trying to resolve.

I would like a gallery to produce a meeting agenda, the gallery will pull up the form of that specific item and a decision can be added to it directly in the meeting. I have set up the form and the gallery. However filtering that gallery by the current meeting is proving tricky.
I would like a drop down that says something like current meeting, last meeting and next meeting. This then populates a date range to look between so the gallery only populates items for the current meeting.

I have a SP list with the meeting dates in. I am just struggling with the actual doing of it. Any help would be useful.

Dan Vas
Dan Vas
2 months ago

Wonderful – thanks so much!