Unanswered

Setting a variable to count the number of records that meet a criteria

(0) Share

Report

Posted on by peter5164

I am wanting to set a variable (trncount) that counts the number of records that have a particular text the same as that in my dropdown box. Can you help me with the syntax? It keeps telling me that I am trying to compare a table to a record.

Set(trncount,CountIf(Training, Training.Description = Dropdown4.SelectedText))

Any help much appreciated

Peter

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

shoog 2,164 on at

Like (0)

Report
Copy link

Link copied!
You should remove the table name in the second parameter like this:
Set(trncount,CountIf(Training, Description = Dropdown4.SelectedText))

Was this reply helpful? Yes No
peter5164 on at

Like (0)

Report
Copy link

Link copied!
No, it still comes up with the same error. I actually had it that way before and changed it trying to fix it. But I worked it out. It seems I needed to create a collection (colTrain) and apply the formula to that,

ClearCollect(colTrain,Training);Set(trncount,CountIf(colTrain, Description = Dropdown4.SelectedText.Value))
Thanks for your help

Was this reply helpful? Yes No