Power Platform Community Forum Thread Details

I'm pretty new to PowerApps and would appreciate an idea of how to begin on this task: A school gives students points for good behaviour, which the students can then spend at a gift shop. The staff running the gift shop want an easy way to know how many points a student has to spend. I want to create an app that will show the total number of points a student has available to spend (Total points- previous transactions), and allow the user to create new transaction records. I've got a table of the students total points, and was hoping that alongside a table of transaction records, something could be created. It seems like the first two challenges are;

How can I get values from these two tables (Table 1: Student name, Table 1: Total Points, Table 2: Sum of transaction costs) displayed side-by-side?
1. I can see that Edit Forms don't permit data drawn from multiple sources
How can I aggregate/calculate these values, (Sum of transaction costs, Total points-sum of transaction costs)

Any advice appreciated

Categories:

General Questions