Building a GroupBy Gallery to show average score

(1) Share

Report

Posted on by NathanFra

183

Hey all, I'm working on a gallery from a SharePoint data source.

My organization is doing a survey of all coworkers and wants a Power App dashboard built to review the data. The survey consists of 10 questions based on a strongly disagree to strongly agree scale. I've gone ahead and given point values to each of the choice optoins from 1 to 5.

I want to take a local collection I've created within the PowerApp, and group by all of the responses by their work location. Then ultimately get the average for each work location using all 10 questions in a single new AddColumn.

I keep trying to use the GroupBy function, but I keep erroring out.

ClearCollect(groupedData, GroupBy(colProviderData, "ProviderLocation", "GroupData"));
ClearCollect(finalData, AddColumns(groupedData, "TotalScore", Sum(GroupData, QuestionTwoValue + QuestionThreeValue)));

Any help or insight would be greately appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
hey

can u try this approach:

ClearCollect( groupedData, GroupBy(colProviderData, "ProviderLocation", "GroupData") ); ClearCollect( finalData, AddColumns( groupedData, "AverageScore", Sum( GroupData, QuestionOneValue + QuestionTwoValue + QuestionThreeValue + QuestionFourValue + QuestionFiveValue + QuestionSixValue + QuestionSevenValue + QuestionEightValue + QuestionNineValue + QuestionTenValue ) / 10 ) );

if it worked please mark as verified answer,

cheers

Was this reply helpful? Yes No
NathanFra 183 on at

Like (1)

Report
Copy link

Link copied!

@mmbr1606,

I tried that, but the original ClearCollect on the groupedData is throwing an error.

It is saying "expected identified name" to both of the strings.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,496 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
@NathanFra
Just adding a clarification - you do not need quotes "" around the parameters and you can do it all in one action. Please mark @mmbr1606's post as the solution as the calculation was your main question.
ClearCollect( finalData, AddColumns( GroupBy( colProviderData, ProviderLocation, GroupData ), TotalScore, Sum( GroupData, QuestionOneValue + QuestionTwoValue + QuestionThreeValue + QuestionFourValue + QuestionFiveValue + QuestionSixValue + QuestionSevenValue + QuestionEightValue + QuestionNineValue + QuestionTenValue ) / 10 ) );

Was this reply helpful? Yes No