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

Power Apps Count Row by Date

I have created a live dashboard that count the rows to show number of tickets with status.
I used the following formula and its working fine (CountRows(Filter('NWC - Support',Status.Value="Pendding"))

But I am not able to set it to count the tickets for Today only, it counts all the tickets regardless in my SP list.

If anyone can help I will be grateful.

nc.png

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@whissi 

CountRows(
              Filter(

                        'NWC - Support', Status.Value ="Pendding" && Text(Created, ShortDate)=Today()
             )

)

View solution in original post

5 REPLIES 5
RussellXDamali
Frequent Visitor

Hey @whissi ,

 

if you want the counts of records created today, the logic could be this

CountRows(Filter('Datasource',Created = Today())

Thanks @RussellXDamali , I used that and it show nothing that's why I am asking , maybe I missed something.

Drrickryp
Super User
Super User

@whissi 

CountRows(
              Filter(

                        'NWC - Support', Status.Value ="Pendding" && Text(Created, ShortDate)=Today()
             )

)

@Drrickryp  I guess both codes are correct but the problem is from my side, Power App is not reading my SP file correctly because my date is (date + Time) so the formula is not getting the TODAY correctly, I might be wrong.

Example how my date look on SP:

whissi_0-1664225311631.png

 

Drrickryp
Super User
Super User

@whissi 

That's why I wrapped it in a Text() function with the ShortDate option.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,631)