Sum of column of SharePoint list

(0) Share

Report

Posted on by FG1323

hi everyone,

I just started with PowerApps and am currently building my first one. I'm struggling with a simple Issue.

I have a SharePoint list 'Test'. One column is a calculated on called 'CO2' and I want to have a text field in my app which gives me the sum of this column. I'm conviced that Sum('Test', CO2) should do the job but it doesn't.

Apparently the table is an unvalid argument type and a number value is expected. I have no clue why it's not working. Maybe it has something to do with the calculated column?

Thank you so much in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FG1323 ,

It is everything to do with the calculated column - these are a historical SharePoint function designed to interact with SharePoint and InfoPath interfaces and really (in my humble opinion) are not suitable for Power Apps as you can do exactly the same calculation there with AddColumns().

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
FG1323 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Strang thing is, if I use another clomun, which is a normal number column, I get the same error?!

Was this reply helpful? Yes No
WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FG1323 ,

The syntax

Sum( ListName, NumericFieldName )

is valid and will produce a result, however is not Delegable (you will get blue lines under it).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No