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

Using SUM in a Gallery

I have a data source with 5 columns, A through E. In these columns there can be numerical values. I wish to sum all the values that may be in the columns and display them in a Gallery. The gallery should have five rows, with each row showing the number of values in the columns. 

 

I have a formula that resembles this one: 

Sum(Filter(...;...selected.value="...");fieldname) 

If I write "ColumnA" to fieldname it works for that one case. But if I try to add a variable which changes from ColumnA, B, C depending on which row of Gallery it is in nothing is shown from the Sum. 

Can I have a variable for the fieldname of the SUM function in Power Apps? Or is there another way of doing this?

 

Thank you, 
 

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@Anonymous 

Have you considered replacing this

fieldname

 

With a SWITCH function?

Swtich(
    ThisItem.SomeColumnName,
    "A",fieldNameA,
    "B",fieldNameB,
    "C",fieldNameC,
    "D",fieldNameD,
    "E",fieldNameE
)

 

Link to Official MS Documenation for SWITCH

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-if

 

---
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."

View solution in original post

1 REPLY 1
mdevaney
Super User
Super User

@Anonymous 

Have you considered replacing this

fieldname

 

With a SWITCH function?

Swtich(
    ThisItem.SomeColumnName,
    "A",fieldNameA,
    "B",fieldNameB,
    "C",fieldNameC,
    "D",fieldNameD,
    "E",fieldNameE
)

 

Link to Official MS Documenation for SWITCH

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-if

 

---
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."

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,097)