Hi,
I'm having some trouble using the GroupBy function to group some data that I have. For context I have multiple submissions for a step challenge and I want the app to show a total steps leader board based on the data fed to it by the SharePoint list. I've used the following Microsoft article to gather the syntax for this:
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-groupby
the code I used is the following:
ClearCollect(
SimplifiedSteps,
ShowColumns(
'Walking Month Step Count',
"Full_x0020_Name",
"StepCount",
"ID"
)
);
ClearCollect(
PersonalSteps,
GroupBy(
SimplifiedSteps,
"Full_x0020_Name",
"StepsTaken"
)
);
ClearCollect(
PersStepSum,
AddColumns(
PersonalSteps,
"TotalSteps",
Sum(
"StepsTaken",
"StepCount"
)
)
);
SimplifiedSteps gives the following table from the SharePoint list 'Walking Month Step Count':
PersonalSteps (grouped by name) gives:
and so far it has worked to give grouped tables of all the names that are the same with all the attributed step count data:
however, when I go to do the number aggregation like the article states (last part of the code) I get the following:
Its driving me crazy as I can see anything wrong with my syntax ( Sum("StepsTaken", "StepCount") ) and I'm 100% sure that the numbers are in number format (its a numbers column on the original list.
Can anyone who has done this offer any insight to what my be wrong? going crazy here! 😄
