cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
da_1299
Helper I
Helper I

Count the overdue date in gallery

Hi All,

 

I am making a PowerApp with the overdue date in the gallery. I would like to count the number of date that is overdue in the gallery. May I know how can I achieve it?

 

da_1299_0-1623211010922.png

 

Thank you.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @da_1299 ,

 

I did a test for you.

Add a label control and set its Text property to:

CountRows(Filter(Gallery1.AllItems,MyDate<Today()))

 

v-xiaochen-msft_0-1623218878670.png

v-xiaochen-msft_1-1623218888491.png

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

View solution in original post

4 REPLIES 4
v-xiaochen-msft
Community Support
Community Support

Hi @da_1299 ,

 

I did a test for you.

Add a label control and set its Text property to:

CountRows(Filter(Gallery1.AllItems,MyDate<Today()))

 

v-xiaochen-msft_0-1623218878670.png

v-xiaochen-msft_1-1623218888491.png

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

View solution in original post

CNT
Super User
Super User

@da_1299 Try this,

CountIf(yourGallery.AllItems, DateDiff(yourDate, Today())>0)

I would like to ask what should be Mydate? Thank you.

v-xiaochen-msft
Community Support
Community Support

Hi @da_1299 ,

 

This is column name.

Please replace it with your column name.

 

Best Regards,

Wearsky

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,972)