web

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

News and Announcements icon

Power Platform CommunityForums Power Apps CountIF the Student na...

Power Apps

Answered

CountIF the Student name based on their status.

(1) Share

Report

Report

Posted on by Smm1 Microsoft Employee

i have a student table in excel sheet and I am using this formula (CountIf(Attendance,Status="Present" && 'Name '=Gallery5_1.Selected.'Name ')) to count the number of students based on their status which is "present" inside of a gallery. but it does not work correctly. So, could someone help me please.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

madlad 2,637 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi!

Referencing Gallery5_1.Selected will just reference the item in the gallery you have selected - the top one by default.

Since this is a text box inside the gallery, try something like:

CountIf(Attendance,Status="Present" && 'Name '=ThisItem.'Name ')

Hope this helps!

Was this reply helpful? Yes No
Smm1 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you so much it works now.

Was this reply helpful? Yes No

Join the conversation