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.
Solved! Go to 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!
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!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
72 | |
51 | |
42 | |
30 |
User | Count |
---|---|
268 | |
121 | |
94 | |
90 | |
81 |