I need to know how to add the price that is inside the browsegallery as seen in the photo and insert the result of the sum into a label
Solved! Go to Solution.
Hi @jdelacrettaz,
You could take use of the Sum function here.
For example, the formula of the BrowseGallery Items property is the following:
SortByColumns(Filter('Testing list', StartsWith(SText, TextSearchBox1.Text)), "SText", If(SortDescending1, Descending, Ascending))
Then under the Count total Label Text property, the sum formula for the Number field should be:
Sum(Filter('Testing list', StartsWith(SText, TextSearchBox1.Text)),
Number
)
Adding the code suggested by @Meneghino:
Sum(BrowseGallery1.AllItems,
Precio)
Which should be better.
Adding the function reference:
Average, mAX, mIN, stdevP, Sum, and Varp functions in PowerApps
If you need any further assistance on this, please post back.
Regards,
Michael
Hi @jdelacrettaz,
You could take use of the Sum function here.
For example, the formula of the BrowseGallery Items property is the following:
SortByColumns(Filter('Testing list', StartsWith(SText, TextSearchBox1.Text)), "SText", If(SortDescending1, Descending, Ascending))
Then under the Count total Label Text property, the sum formula for the Number field should be:
Sum(Filter('Testing list', StartsWith(SText, TextSearchBox1.Text)),
Number
)
Adding the code suggested by @Meneghino:
Sum(BrowseGallery1.AllItems,
Precio)
Which should be better.
Adding the function reference:
Average, mAX, mIN, stdevP, Sum, and Varp functions in PowerApps
If you need any further assistance on this, please post back.
Regards,
Michael
As an alternative you can also use Gallery1.AllItems, so something like Sum(Gallery1.AllItems.Precio)
The formula that worked for me was:
Sum(BrowseGallery3.AllItems;Body2_2)
thanks you so much for help me!!
Hi there,
The solution works fine, but I have an issue when I add a new element to the gallery. (I have a Form that creates a new task and adds it to a gallery - source sharepoint-)
The new task shows in the gallery and in the source, but the label where I have the formula Sum(ProjectTasksGal.AllItems,Total_Task_Price)
Doesn´t add the new task to the total... don´t know why!!!
Any hint is welcome!
Thanks in advace!
User | Count |
---|---|
183 | |
124 | |
88 | |
45 | |
43 |
User | Count |
---|---|
248 | |
157 | |
127 | |
78 | |
73 |