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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-micsh-msft on at

Like (3)

Report

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

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (4)

Report

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

Was this reply helpful? Yes No
jdelacrettaz 54 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Enz0 4 on at

Like (0)

Report

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!

Was this reply helpful? Yes No