Dear Community
I need your help.. 🙂
Problem
I want to display a total of all entries in a calculated column (Amount)
Setup:
SP List: Report:
Title | Hours | Price |
Text | Text | Text |
Hans | 2 | 5 |
Max | 2 | 10 |
SP List: Customers
Title | Price |
Text | Text |
Hans | 5 |
Max | 10 |
Powerapp: Gallary1:
Title | Hours | Price | Amount |
Text | report.hours | Lookup(Customers, ThisItem.Title = Title).Price | Hours * Lookup(Customers, ThisItem.Title = Title).Price |
Hans | 2 | 5 | 10 |
Max | 2 | 10 | 20 |
Now i want a Text Label who SUM all Items in the Gallary Row "Amount" (10+20 = 30)
I cant do SUM(Gallary1.Allitems,Amount) because the Amount row has no Name ist calculatet (Hours * Price)
Thanks !
Levin
Solved! Go to Solution.
I think I have an idea of what you are asking, and that this example should help you figure it out
In the above gallery I have the items from TestColl which is a test collection I made with this as its items
Collect(TestColl,{Value1:1,Value2:10},{Value1:4,Value2:7},{Value1:3,Value2:20})
the third label in the gallery is just the two items multipled.
In the label off to the right of the screenshot above you have the sum of all the multiplications in the gallery, achieved like so
Sum(
ForAll(
Gallery5.AllItems,
Value(ThisRecord.Title7_1.Text)
),
Value)
where gakllery5 is my gallery, and Title7_1 is the control where the multiplication takes place
I think I have an idea of what you are asking, and that this example should help you figure it out
In the above gallery I have the items from TestColl which is a test collection I made with this as its items
Collect(TestColl,{Value1:1,Value2:10},{Value1:4,Value2:7},{Value1:3,Value2:20})
the third label in the gallery is just the two items multipled.
In the label off to the right of the screenshot above you have the sum of all the multiplications in the gallery, achieved like so
Sum(
ForAll(
Gallery5.AllItems,
Value(ThisRecord.Title7_1.Text)
),
Value)
where gakllery5 is my gallery, and Title7_1 is the control where the multiplication takes place
@Premium Gallery' main function is to display data from the source.. now in your case the Amount that you are calculating is on the fly.. what's the Gallery' Items Property.?
Thanks @TheRobRush this is exactly what I needed.It's really extreme how quickly help is given here, and probably voluntarily... That's very nice to see
greetings from Switzerland
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |