Unanswered

SharePoint list - Sum data from columns for single record

(0) Share

Report

Posted on by piazya

Hello!

I am looking for the solution to sum data from few columns for one records (to compare with given value) as below:
Is it possible in PowerApps (Canvas)

thank you in advice!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

Sum(DataSource,'FTE saving' + 1/2022 + 5/2022)

Was this reply helpful? Yes No
piazya 2 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @C-Papa,
It sums columns for all the records.

1. Is it possible to sum values only for one (selected) record?
2. Is it possible to sum 'All columns' without naming all columns?
I need to compare the sum from all the columns to 'FTE saving' value.

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

Within your gallery, add Set(var_selected,ThisItem) to the button OnSelect that you want to select the item with. then use the Sum function to display the value: Sum(var_selected.col1, var_selected.col2, var_selected.col3 etc etc)

You always need to specify the column to summarise. you could add a calculated column to your database that summaries all of the required columns, then you would only need to refer to this column

Was this reply helpful? Yes No