Answered

How to sum numeric fields inside a browsegallery

(1) Share

Report

Posted on by jdelacrettaz

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

Sin título.png

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!

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
Meneghino 6,949 on at

Like
a
(4)

Report
Copy link

Link copied!

Hi @jdelacrettaz
As an alternative you can also use Gallery1.AllItems, so something like Sum(Gallery1.AllItems.Precio)
jdelacrettaz 54 on at

Like
a
(2)

Report
Copy link

Link copied!

The formula that worked for me was:
Sum(BrowseGallery3.AllItems;Body2_2)
thanks you so much for help me!!
Enz0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there,
@v-micsh-msft ,
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!