Display count when item visibility is = true

(0) Share

Report

Posted on by Angry_Sys_Admin

181

Hi all.

Ok bear with me on this one as its has been annoying me for a while.

Every employee has a review with a line manager at 6 months and 12 months and a final review at 24 months. I have created a dashboard to show the status of these reviews however I need help with the formula to filter out staff who are not due their reviews, so if an employee has been with us for 18 months they should not show as outstanding on our 24 month review label because they have not yet reached the required date.

The App - a filtered gallery based on a users Office Location, they can only view staff where the office location matches their own.

The SharePoint List = One of the columns (Yes/No - named 24MonthFlag) calculates the employees start date + 730 days, if they are on or over the date the value is 'Yes'. This is working as it should do.

=[EmploymentStartDate]+730>[24 Month Review]

The dashboard = A simple text box with the following code:

"Complete" & " = " & CountRows(
 Filter(
 StaffGal.AllItems, '24 Month Review Status'.Value = "Not Complete"
 )
)

I need the above counter to show the total count of staff who have a 24MonthFlag status = true, AND a 24 month Review Status. value of "Not Complete"

Hope this makes sense.

Many thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCBuizer 22,746 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Angry_Sys_Admin ,

For this you can try simply adding a condition to your filter:

"Complete" & " = " & CountRows( Filter( StaffGal.AllItems, '24MonthFlag', '24 Month Review Status'.Value = "Not Complete" ) )

Since the value in the column should be a boolean by itself, you don't need to use any operators.

Since '24MonthFlag' is a calculated column, this may cause issues (sorry, can't test to be sure), in which case you should replace the new condition with something similar to what you have for the calculated column:

"Complete" & " = " & CountRows( Filter( StaffGal.AllItems, EmploymentStartDate > Today()-730, '24 Month Review Status'.Value = "Not Complete" ) )

Was this reply helpful? Yes No
Angry_Sys_Admin 181 on at

Like (1)

Report
Copy link

Link copied!
@BCBuizer

Thanks for the reply, the second solution worked although I just needed to reverse the > on the Today value so the working code reads:

"Complete" & " = " & CountRows( Filter( StaffGal.AllItems, EmploymentStartDate < Today()-730, '24 Month Review Status'.Value = "Not Complete" ) )

Was this reply helpful? Yes No