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

25 Comments
Oldest
Newest
Inline Feedbacks
View all comments
Akbar Alam
Akbar Alam
2 years ago

This is very helpful indeed

Ninett Hesse
2 years ago

Just what I was looking for this last month!

Juli
Juli
2 years ago

Very timely! I just needed it today

Jeeten Kumar
Jeeten Kumar
2 years 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
2 years ago

How would you filter by Name and weekly date range ?

Andre
Andre
2 years 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
1 year ago
Jez Holland
Jez Holland
1 year 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
1 year ago

Wonderful – thanks so much!

Iyanuoluwa samson
Iyanuoluwa samson
1 year ago

how do i filter a gallery by todays and upcoming date by clicking on a button

Luke Chalmers
Luke Chalmers
9 months ago

How would I filter by today’s day and month but ignore the year. I want to use this for a sharepoint list named EmployeeBirthdays where the date column is named Birthday. Each employees birthday is entered in mm/dd/yyyy format. I need the gallery to return anyone in the list with todays month and day.

Luke Chalmers
Luke Chalmers
9 months ago

Thank you. I’ll give it a try today and let you know.

Pradipta
Pradipta
9 months ago

any luck for Large list ? When we use filter with Date in Large list Delegation issue is comming.

Kerim
Kerim
1 month ago

Hi Matt,

I have the following situation :

a first gallery with Items set to : ForAll(Sequence(4),{itemLine:Value})
a nested gallery with items set to : ForAll(
  Sequence(13),
  {weekNumber: (ThisItem.itemLine – 1) * 13 + Value}
)

I’d like to show projects with end date occurring in the sequence of the second gallery but I can’t manage to add the filter function to Sequence in Gallery 2.

Any suggestions?

Thank you in advance