Answered

Calculating a Total Within a Column

(0) Share

Report

Posted on by RSCYK

Hi, I've set up a successful process where I can transfer values from a SharePoint list to a distinct Excel sheet. I need some guidance to finalise this process. In a Microsoft Teams channel, I have a SharePoint list with a "points used" column. Whenever this column is updated with a new value, a corresponding row is added to an Excel sheet in a different team's channel. My goal is to deduct the newly added "points used" value in the Excel sheet from the existing "points remaining" column to maintain a continuous total. Here's an example for clarity:

My flow consists of the following at the moment, but I am receiving errors at the list rows present in a table to stop the flow:

I am new to power automate, so any help and advice would be gratefully appreciated.

Thanks,

I have the same question (0)

All responses (3)

Answers (1)

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Calculating a Total Within a Column

Hi @RSCYK

Could you pls share the screenshot of the error? Also, share the details of actions in "Yes" block, if you share the screenshot(s) in edit mode.

Thanks

Was this reply helpful? Yes No
RSCYK 5 on at

Like (0)

Report

Re: Calculating a Total Within a Column

Syntax error at position 16 in 'Points Remaining'.
inner exception: Syntax error at position 16 in 'Points Remaining'.
clientRequestId: 2e74ca49-91b2-475b-985d-57da8ff9deef

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (1)

Report
Re: Calculating a Total Within a Column

Hi @RSCYK

If the first row always holds the "Point Remaining" value, then you don't need to set the order by parameter in "List rows present in a table". The top 1 will fetch the first row which you have already set.

In compose, you need to write an expression to calculate the difference. It wouldn't evaluate the formula when enter directly in textbox.

I have also converted the values into integers to perform subtraction operation in the expression, pls try using the below expression:

sub(int(first(outputs('List_rows_present_in_a_table')?['body/value'])?['Points Remaining']),int(outputs('Add_a_row_into_a_table')?['body/Points Used']))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No