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.
Solved! Go to Solution.
@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:
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!