web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to sum a Gallery C...

Power Apps

Answered

How to sum a Gallery Column

(1) Share

Report

Report

Posted on by CaiChicken

119

Hello Community,

This question might be asked many times but my case is a bit complex

I need to Sum up Total Price,

The formula for Total Price is

ThisItem.'Trade Price'*SearchCart_TextInput_Quantity.Text*(100-SearchCart_TextInput_Discount)/100

Item list from this gallery is from a Collection where each items are manually added (Not a filter).

And it is a nested table (This is another issue I encounter, not very sure how to convert to normal table)

Any help appreciated,

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

CaiChicken 119 on at

Like
a
(27)

Report
Copy link

Link copied!
Solution Found!
Sum(ImportCart_Gallery_Cart.AllItems, ImportCart_Label_TotalPrice)

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(6)

Report
Copy link

Link copied!
@CaiChicken

Is the Total Price being displayed using a label called Import_Label_TotalPrice?

If yes, please put this code in the Text property of a new label to display the SUM.

Sum( AddColumns( Gallery1.AllItems, "TotalPrice", Value(Import_Label_TotalPrice.Text) ), "TotalPrice" )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
chairat 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much @CaiChicken 😍

Was this reply helpful? Yes No

Join the conversation