Answered

Internal error in the AddColumns function: ,,,ReferenceError: result26 is not defined."

(0) Share

Report

Posted on by ksestrada

Hi! I am adding a column to a collection but it seems to be not working. My collection shows 12 rows, but when I view it, there is no data reflecting.

Here is the code:

UpdateContext({Team: LookUp(Teams, ID=gloTeamID)});
UpdateContext({Period: LookUp(SurveyPeriods, ID=gloPeriodID)});UpdateContext({rowscnt:CountRows(Filter(TeamResponse, TeamID=gloTeamID))});ClearCollect(TeamRes, Filter(TeamResponse, TeamID=gloTeamID));

ClearCollect(TeamResponse1,
AddColumns(TeamRes,
"Level", LookUp(Levels,ID=TeamRes[@LevelID], Level),
"Team", LookUp(Teams,ID=TeamRes[@TeamID], TeamName),
"Period", LookUp(SurveyPeriods,ID=TeamRes[@PeriodID], Name),
"Segment", LookUp(Segments, ID = LookUp(Teams,ID=TeamRes[@TeamID], SegmentID), SegmentName)
)
);

//Group by and sum column code
ClearCollect(
periodsColl,
DropColumns(
AddColumns(
GroupBy(TeamResponse1, "Period", "Team","TeamID","grouped"),
"Score",Round(Average(grouped,Score),1)
),
"grouped"
)
);

Attached is the columns tab

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ksestrada ,

A bit difficult without something to test this on, however I notice you have both a Variable and a field name called Period (so naming protocols are important here. I have also tidied the code up a bit so there is a base to work on, but try this. Also do you have any blank values in Score as this will definitely error.

UpdateContext( { varTeam: LookUp( Teams, ID = gloTeamID ), varPeriod: LookUp( SurveyPeriods, ID = gloPeriodID ), varRowscnt: CountRows( Filter( TeamResponse, TeamID = gloTeamID ) ) } ); With( { _TeamRes, Filter( TeamResponse, TeamID = gloTeamID ) }, With( { _Response: AddColumns( _TeamRes, "Level", LookUp( Levels, ID = LevelID ).Level, "Team", LookUp( Teams, ID = TeamID ).TeamName, "Period", LookUp( SurveyPeriods, ID = PeriodID ).Name, "Segment", LookUp( Segments, ID = LookUp( Teams, ID = TeamID ).SegmentID ).SegmentName ) }, ClearCollect( periodsColl, DropColumns( AddColumns( GroupBy( _Response, "Period", "Team", "TeamID", "grouped" ), "Score", Round( Average( grouped, Score ), 1 ) ), "grouped" ) ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
ksestrada 3 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked! Thank you very much!