How to sum numeric fields inside a browsegallery

[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

[v-micsh-msft · Accepted 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

[Meneghino]

Hi @jdelacrettaz

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

[jdelacrettaz]

The formula that worked for me was:

Sum(BrowseGallery3.AllItems;Body2_2)

thanks you so much for help me!!

[Enz0]

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!