cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Sum gallery column values

Hello,

I have a dataset from Excel which I display in the gallery, every gallery row has a number column, and I would like to display the sum of all items number column in a label as a text.

How this could be done? 

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Microsoft
Microsoft

Hi @Anonymous 

 

I believe you can do this with Sum as follows, albeit I wonder if you will have problems on larger datasets.

 

Sum(Gallery.AllItems,lblYourExcelLabel)

 

Damien

View solution in original post

2 REPLIES 2
DamoBird365
Microsoft
Microsoft

Hi @Anonymous 

 

I believe you can do this with Sum as follows, albeit I wonder if you will have problems on larger datasets.

 

Sum(Gallery.AllItems,lblYourExcelLabel)

 

Damien

Anonymous
Not applicable

Hey @DamoBird365 !

It worked perfectly thank you!

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,165)