web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Count rows with a day

Power Apps

Answered

Count rows with a day

(0) Share

Report

Report

Posted on by sbgoh

284

Hi,

I wish to countrows of a Sharepoint list with one day i.e. Now() 00:00:00 to Now() 23:59:59. However I am unable to get the formula correct. The field I am checking against is a sharepoint datetime field. Any advise?

CountRows(
Filter(
SP_LIST,
'Issue Date' >= DateTimeValue(Now(), "dd/mm/yyyy 00:00:00.fff"),
'Issue Date' <= DateTimeValue(Now(), "dd/mm/yyyy 23:59:59.fff")
)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

UdayAdhikari 450 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@sbgoh - please give this a try. By default, DateDiff function uses "Days" to compare between 2 dates so it ignores times.

CountRows( Filter( SP_LIST, DateDiff( 'Issue Date', Today() ) = 0 ) )

Thanks

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
sbgoh 284 on at

Like
a
(1)

Report
Copy link

Link copied!

It works. Thank you!

Join the conversation