web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Label field displaying...

Power Apps

Unanswered

Label field displaying countrow results, but need to add a date condition, if no records found, display a 0

(0) Share

Report

Report

Posted on by AdamH

580

Hi All,

I've been out of powerapps for a little while and struggling to get my head back into some of the formulas.

I've got a label, that countsrows within a SP list and displays the results, based on some criteria:

CountRows(Filter(Tickets, Department.Value = "VALUE" && TicketStatus.Value = "On Hold"))

But for this formula, I need to add:

1) for records 30 days or more (based on the date they were created)

2) if no record's found, I need to display a 0 (zero)

Any help - much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

Fredrik_A 3,644 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
If you want to filter out items created in the last 30 days it should look like this:

CreatedDate>=DateAdd(Today(),-30,Days)

It should display a 0 per-default if there are no rows matching your filter if im not mistaken.

Was this reply helpful? Yes No
AdamH 580 on at

Like
a
(0)

Report
Copy link

Link copied!

@StretchFredrik

Maybe I should have pointed out, I'm not using the SP default field 'Created' - I'm using a single line of text field that contains the date.

Was this reply helpful? Yes No
Fredrik_A 3,644 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
You could do something like this

DateTimeValue(YOURCOLUMN)

Was this reply helpful? Yes No
AdamH 580 on at

Like
a
(0)

Report
Copy link

Link copied!
@StretchFredrik

I did this in the end, it worked out ok - Thanks for the prompts!

CountRows( Filter( Tickets, Department.Value = "Clinical Practice Specialists" And TicketStatus.Value = "On Hold" And DateCreated <= DateAdd( Today(), 30 ) ) )

Was this reply helpful? Yes No

Join the conversation