web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Suggested Answer

Combining Rows

(1) ShareShare
ReportReport
Posted on by 2
Hello all,
 
I'm needing help with how to combine rows to have it return one value in a gallery.
I'm building an app for award nominations. In the app anyone can nominate anyone else, but only the senior team can score the nominations. There are 10 senior team members. The issue I ran into is if Person A nominates the same person as Person B, the nominee shows up twice. My goal is to combine rows that have the same nominee's name, then show the scores from each senior team member and add them together so no one has to go in and manually add up the scores.
 
The name of the Sharepoint list I am using is 'ABCD Scoring' with columns 'Nominee' for the nominee name, 'Senior Member' for the senior member name, then a column for each criteria the senior team scores.
Categories:
I have the same question (0)
  • Suggested answer
    Nandit Profile Picture
    1,568 Moderator on at
    Combining Rows
     
    Can you try the following please. 
    ClearCollect(finalScore,  
        AddColumns(
                GroupBy('ABCD Scoring', "Nominee","subgroup"),
                    "SumA",
                    Sum(subgroup,CriteriaA),
                    "SumB", Sum(subgroup,CriteriaB),
                    "SumC", Sum(subgroup,CriteriaC)
            ) 
    );
    This should give you a list of Distinct winners with aggregated score. 
     
    Hope this helps. 
     
    Kind regards, 
    Nandit
     
    If this answers your query, please mark this response as the answer.
    If its helpful, please leave a like. Thanks!
     
  • Nandit Profile Picture
    1,568 Moderator on at
    Combining Rows
    Hi,

    Following up to check if you were able to solve this issue using my suggestion?

    Kind regards,
    Nandit

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard