Power Apps Count Row by Date

[whissi]

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.

[RussellXDamali]

Hey @whissi ,

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

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

[whissi]

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

[Drrickryp · Accepted solution]

@whissi 

CountRows(
              Filter(

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

)

[whissi]

@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:

[Drrickryp]

@whissi 

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