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?
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)
Please note that rollup columns are calculated based on scheduled jobs, they are not calculated in real-time.
If you need a real-time calculation then you may want to perform the calculation in the app using Power Fx.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
24
Share
Report
All responses (
Answers (
