Power Apps Live answers

Answers from Claude

Problems sent from the laptop, answered in real-time. Each card is a genuine build error with the working fix.

scrMyTraining gallery empty — 0 of 0 courses showing

scrMyTraining colMyTraining Fixed · 21 Jun 2026, 09:14

Problem

All stat cards show 0 and the gallery is empty, even after adding a course and completing it. The header shows the correct user name and staff type.

Root cause

scrMyTraining.OnVisible builds colMyTraining from colCourses, but doesn't reload colCourses from SharePoint first. If courses were added or the app was reopened since App.OnStart ran, the collection is stale and the filter returns zero rows. Also check: the course Status field in SharePoint must be Active (not blank) — the filter excludes anything else.

Fix — add to the top of scrMyTraining.OnVisible

ClearCollect(colCourses, 'TT Courses');

Full corrected start of scrMyTraining.OnVisible

ClearCollect(colCourses, 'TT Courses'); ClearCollect(colMyRecords, Filter('TT TrainingRecords', PersonEmail = varMyEmail));

GitHub issue #1

recRowBG_1 Fill error — IsOdd is not a valid Power Apps function

Gallery row background Fill formula Fixed · 21 Jun 2026, 09:47

Problem

Formula If(IsOdd(ThisItem.ItemIndex), ...) gives red X. Two issues: IsOdd does not exist in Power Apps, and ThisItem.ItemIndex is an unreliable visual position index that shifts when the gallery filters or sorts.

Fix — SharePoint-backed gallery (galPersonnel, galCourses etc.)

If(Mod(ThisItem.ID, 2) = 0, RGBA(255,255,255,1), RGBA(247,249,252,1))

Fix — galMyTraining (colMyTraining, no ID field)

If(Mod(ThisItem.CourseID, 2) = 0, RGBA(255,255,255,1), RGBA(247,249,252,1))

Fix — galMyChain (colMyChain, no numeric ID)

If(Mod(Len(ThisItem.Email), 2) = 0, RGBA(255,255,255,1), RGBA(247,249,252,1))

GitHub issue #2