I have a list that has a Category Field and a Count Field
There will be 5 Categories in the List.
I will like to create a Summary Screen in the APP, where the Count of Each Category is Displayed.
So:
Cat1: Total
Cat2: Total -etc.
Solved! Go to Solution.
Hi @Canadiansal,
Based on the issue that you mentioned, do you want to sum the scores of each grouped team?
Could you please share a bit more about the scenario?
I have a test on my side, please take a try as below.
In my scenario, I have the SPList1 as my data source, a Choice column Team and a Number column YourPts.
Add a Gallery and set the Items property as below:
AddColumns(
GroupBy(
AddColumns(
SPList1,
"NTeam",
Team.Value
),
"NTeam",
"GTeam"
),
"SumPts",
Sum(
ForAll(
GTeam.YourPts,
YourPts
),
Value
)
)
Set the Text property of the Labels within the Gallery as below:
ThisItem.SumPts
Regards,
Qi
Insert a Gallery and on the Items Property put:
AddColumns(GroupBy(MyList,"CategoryField","GroupedColumn"),"CountColumn",CountRows(GroupedColumn))
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Consider Checking My Youtube Channel
Does not work
AddColumns(GroupBy(Compete,"Team","YourPts"),"CountFunction",CountRows(YourPts))
Is complete the name of your Table and Team the name of tour column?
If you have errors can you show a screen shot?
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Thanks. Here is the Table. Team is a Choice Column. And YourPts is a Numerical score.
I am trying to create a leaderboard which will show the Points grouped by Team,
Hi @Canadiansal,
Based on the issue that you mentioned, do you want to sum the scores of each grouped team?
Could you please share a bit more about the scenario?
I have a test on my side, please take a try as below.
In my scenario, I have the SPList1 as my data source, a Choice column Team and a Number column YourPts.
Add a Gallery and set the Items property as below:
AddColumns(
GroupBy(
AddColumns(
SPList1,
"NTeam",
Team.Value
),
"NTeam",
"GTeam"
),
"SumPts",
Sum(
ForAll(
GTeam.YourPts,
YourPts
),
Value
)
)
Set the Text property of the Labels within the Gallery as below:
ThisItem.SumPts
Regards,
Qi
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 |
---|---|
256 | |
126 | |
85 | |
85 | |
68 |