This might make a good Live Stream demonstration. 🙂

Thanks Ru, I wasn't able to make that work. So, I opted to break the process apart. I move the Collection query to run with App_OnStart then filtered the Collection like this: Filter( Student_col As SC, LookUp(Student As S , SC_Email_Link = S.Email_Link, S.State in "Active") ) This solves the removal of the "Inactive" participants. (Dropped students.) Thank you again and have a great day. - Merry

Works in the Pacific Northwest.

Greetings from the Pacific Northwest, Being an Expert Excel user, I naturally migrated to the Power BI tool set and have produced some very advanced reports and tool sets for my team members for a few years. Lately the Power BI work has been fulfilling its function, so I was asked to move into Power Apps and help the Development team out with their backlog. (My company is amazingly patient about resource upskilling.) I am not what I would call a developer, but I'm learning by the seat of my pants, and I've been given access to a couple great resources that know their stuff to get me over the humps. I've joined Skool about a month ago and found much of the content to be useful. The downloaded file example is great for a reference tool. However, I've found I needed to find my own solutions as I am building a process gamification application from scratch. It would be cool to see this group do a similar demonstration leveraging the Dataverse tables since the rules seem to be different for Dataverse than for other data resources. Wish I had bandwidth to participate in the Excelleration program. But alas there are only so many hours in a day.

I was able to resolve this leveraging an AddColumn with the following code: SortByColumns( AddColumns(Students As S , AcummulatedPoints, Sum(Filter(Classes, FK_Attending_Student = S.Student) ,Points) ),"AcummulatedPoints", SortOrder.Descending, "Lastname" , SortOrder.Ascending)