Answered

PowerApps - Using CountIf on a column of dates to find text

(0) Share

Report

Posted on by RyanParker

Hi,

It might be that I just have to tidy up my spreadsheet. I have a list of dates that is 90% dates and 10% text in my RegClinicDate column. If a patient books a clinic, I put a date; if they don't I put No Response; if I am still waiting, I put a dash "-".

I'm trying to count patients who we are waiting for and am using this formula:

CountIf(PatientTable,RegClinicDate="-")

But I get an error message saying Data Type: Number

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @RyanParker ,
where do you get this error?
if you put this formula as text property of label,
there should not be any issue.

Was this reply helpful? Yes No
RyanParker 46 on at

Like (0)

Report
Copy link

Link copied!

I'm getting a yellow explanation point saying DateTime and Text can't be compared. The result is also 0 but I should have 17. I think I have to put Text() in there somewhere but I'm not getting far

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You will be able to put '-' and 'No Response' only if RegClinicDate is of type single line of text.

Was this reply helpful? Yes No
RyanParker 46 on at

Like (0)

Report
Copy link

Link copied!

That doesn't work either I'm afraid. My column is a mix of dates and text. I might just separate the column instead

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Not sure how would your RegClinicDate column accepts non-date values.
what is the datasource of your List? is it SharePoint?

Was this reply helpful? Yes No
Verified answer

uwenagel 382 on at

Like (1)

Report
Copy link

Link copied!

You should be successful by changing your formula as follows:

CountIf(PatientTable,Text(RegClinicDate)="-")

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.

Was this reply helpful? Yes No