Runing a CountIf with a yes/no column on dataverse

(0) Share

Report

Posted on by FGRODRIGUEZ

129

So, I'm trying to count the active tasks a person has on a data verse table, I'm using this expression

CountIf(tm_Tareas, Asignado.Nombre = ThisItem.Nombre && Completado = false)

Where Asignado = The assigned person to the task

Nombre = Their Name

Completado = Yes/No if the task is completed

The first part of the expression seems to work as intended, it returns the total of rows under that name, but the second part seems to not work, and I'm not sure what I'm doing wrong.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@FGRODRIGUEZ

Try

CountRows(Filter(tm_Tareas, Asignado.Nombre = ThisItem.Nombre && Completado.Value= false))

Was this reply helpful? Yes No
FGRODRIGUEZ 129 on at

Like (0)

Report

It does not seem to work, I get this error

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

Like (0)

Report

@FGRODRIGUEZ

It's more complicated than I thought. See https://www.spguides.com/power-apps-dataverse-yes-no-field/

Was this reply helpful? Yes No
Verified answer

FGRODRIGUEZ 129 on at

Like (0)

Report
In case someone else is having this issue in the future, I found the solution for my own dataset model

CountIf(tm_Tareas, Asignado.Nombre = ThisItem.Nombre) - CountIf(tm_Tareas, Completado, Asignado.Nombre = ThisItem.Nombre)

Where
tm_tareas = dataverse table
Asignado.Nombre = Assigned persons name
Completado = The true state of the true/false switch

Was this reply helpful? Yes No