Gallery sorting by Title (date) and showing Subtitle as counter

[hrivera]

Hi everyone:

I am learning to make Power Apps, and I am making an attendance app to fill up a form for COVID-19 (already made a power automate for that with Forms, Sharepoint List and Sending emails) and also the users can check who will go to the job on an specific day, in a way to control the attendance per day.

So I could make the attendance per date after checking on the net: 

Sharepoint List: Attendance

Column for attendance date: AttDate

Distinct(SortByColumns('Attendance'.'AttDate';"AttDate";If(SortDescending1;Descending;Ascending));'AttDate')

I dont know how but it works (little experience at programming), now I need to show the subtitles as a counter of how many people already filled up the forms, like this: 

28/11/2020

10 (this being the number of forms that registered that date)

And then when you select the date can show the list of users attending.

Thanks for your attention and help in advance, I am 3 months being admin of Microsoft 365, a little company gave me the chance to be IT manager and I really love tech.

[poweractivate]

@hrivera 

Try this

Count, CountA, CountIf, and CountRows functions in Power Apps

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-counts

Specifically, the CountIf might help you. You can get a count of records based on a logical condition.

There is also actually more than one possible approach.

First you can check if the CountIf and link above helps you.

[hrivera · Accepted solution]

Thanks, I could solve it and finish it, now I made my first app on power apps.

The solution was: Select the subitem on the gallery and type CountIf('Attendance'.'AttDate';'AttDate' in Title.Text) where Title.Text is the value i got from my formula above. And tadah! 

Also I could figure out how to make the results for the filters. Thanks a lot!

[askondo]

@poweractivate

 Thank you for your answer in the forum.
In the future, your answers in the forum will continue to be of great help to us.
Thank you!

@hrivera 

I'm glad your problem is solved.
Thank you also for your feedback on the solution.
I'm sure your feedback will help others in need as well.