cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdelacrettaz
Level: Powered On

How to sum numeric fields inside a browsegallery

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to sum numeric fields inside a browsegallery

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.

96.PNG

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: How to sum numeric fields inside a browsegallery

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.

96.PNG

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Meneghino
Level 10

Re: How to sum numeric fields inside a browsegallery

Hi @jdelacrettaz

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

jdelacrettaz
Level: Powered On

Re: How to sum numeric fields inside a browsegallery

The formula that worked for me was:

Sum(BrowseGallery3.AllItems;Body2_2)

thanks you so much for help me!!

 

Enz0
Level: Powered On

Re: How to sum numeric fields inside a browsegallery

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!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 338 members 5,655 guests
Please welcome our newest community members: