Powerapps gallery showing count of distinct items in a sharepoint list

[augustine2]

Hello,

I'm fairly new to Powerapps.  I have a sharepoint list (CreatedList) with a "Created By" column where different users are inputting records to the List.  I want to have a gallery in my Powerapps application that shows the different users and a count of the number records created for each user.  For example:

UserA       9

UserB       6

UserC       4

UserD       10

Preferably, I want to sort the gallery to show count in descending order (high to low).  Thanks in advance.

[Nogueira1306 · Accepted solution]

Olay. On your Gallery write this: 

Distinct(CreatedList, 'Created by')

Then, add a label in the gallery and write this:

CountRows(Filter(CreatedList, 'Created by'.Email = ThisItem.Email)) 

That will say how many lines you have from each  user.

I dont know you can do that sort...

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

[augustine2]

That works!  Thank you @Nogueira1306 -