Power Apps

Collection showing how many records per Created By value

(1) Share

Report

Posted on by CCEP_Mike

219

Hello,

If i have a sharepoint list called "Assignments" and within the list i have the following data fields/records

Sharepoint List = Assignments
ID	User_Email	Assigned_Outlet
1	my@email.com	12
2	jack@jack.com	64
3	my@email.com	85
4	my@email.com	578
5	jack@jack.com	83
6	me@microsoft.com	2345

How would i best create a collection which will look at the records, and will count how many records there are PER "User_Email" value? for example, based on the above I'd have a collection which looks like the following:

User_Email	Count
my@email.com	3
jack@jack.com	2
me@microsoft.com	1

Any help would be much appreciated. Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

timl 36,774 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
The following formula will create the collection that counts how many records there are per 'User_Email'.

ClearCollect( EmailCounts, AddColumns( GroupBy(AssignedOutlets, User_Email, UserGroup), Count, CountRows(UserGroup) ) );

Was this reply helpful? Yes No
Suggested answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hey,

timl's way will work perfectly fine here's just another way to do it.

ClearCollect( CountAssignment, AddColumns( Distinct( Assignments, User_Email ), Count, CountRows( Filter( Assignments, User_Email=Value ) ) ) )

If this post helped you consider accepting it as a solution. Don't forget that you can accept multiple posts as solution.

Was this reply helpful? Yes No
CCEP_Mike 219 on at

Like (0)

Report
Copy link

Link copied!

Hi both of you,

Thank you very much for your support on this, Timl I've managed to implement your suggestion into my app and I've got it working as expect. Unfortunately I'm trying to mark your answer as the solution but I'm just getting an endless spinner when i mark it.

If you both don't mind, I've asked a similar question but with a little more complexity to it. If you dont mind helping me on how to do that that'd be much appreciated.

https://community.powerplatform.com/forums/thread/details/?threadid=bc8cc904-2f5e-ef11-bfe2-6045bdef4e0d

Thank you both of you :-)

Was this reply helpful? Yes No