Adding Values in Added Rows and Populating Sum in a Message

[mpark93]

Hi all! Beginner PowerAutomate user who is struggling to get added values.

I've create a basic flow that takes form responses and adds a new row in an Excel sheet with those response values. What I'm trying to achieve is summing some of those values (which can vary from 1-3 responses) and having that sum be posted on a Teams Approval. I'm not really understanding how variables work which is why I'm suspecting I've been having so much trouble, but this is a basic idea of what I'm trying to achieve:

Form:

 

These fields are then populated to an Excel sheet like so:

I've added a "Total Cost of Items" Column with a simple multiplication formula that gives me the grand total for the line item (i.e. 4 packets * $3.99 per packet = 15.96).

I'm trying to have the sum of the total cost of items that were request to show up on a Teams message (see below):

The output I'm trying to achieve in the highlighted "Total:" space is 15.96 + 44.95 = 60.91. Not quite sure where to start, but any feedback is appreciated!

Thank you 😁

[MarconettiMarco]

Hello @mpark93 ,

you should follow these steps:

1. Initialize a Float variable:

2. Add an Excel "List rows present in a table" selecting your spreadsheet and the table:

3. For each value grabbed from the previous array, Increment the variable previously initialized. Please provide the following expression:

float(items('Apply_to_each')?['Total Cost of Items'])

4. Add the "Format number" action:

- Number: put the variable;

- Format: 1,234.00

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

[mpark93]

Thank you so much, unfortunately I'm still running into an issue...when I follow the steps, this is the message that I get:

"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Increment_variable' at line '1 and column '15482' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Increment_variable' to be referenced by 'repeatItems' or 'items' functions.'.'."

Could it possibly be because my "Total Cost of Items" column is a formula and not a number value?