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.

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 (4,573)