web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Adding a Value to an e...
Power Automate
Suggested Answer

Adding a Value to an existing value in an Excel sheet

(0) ShareShare
ReportReport
Posted on by 643
I have the flow below that I would like to sum up column values and if a threshold is hit it raises an item in SP and then I would like it to update a cell value in the sheet.
 
 
I would like to add the "SERVICE INTERVAL" value to the "FORGE SHOTS" value on the "Update a Row" action. How can this be achieved?
 
 
Categories:
I have the same question (0)
  • Suggested answer
    Nandit Profile Picture
    1,568 Moderator on at
     
    Couple of questions:
    Which column values do you want to sum up and use a threshold for?
    You wish to sum the Service Interval and Forge Shots columns in the update a row and save it in a different column?
     
    To sum up values of a column,
    1. You an use "Intialize Variable" to first initialise a variable of type Int
    2. Then in your first "Apply to Each" you will add a "Increment Variable" action, select your variable and add the column to be summed as the Value. 
     
    Then you can add a condition to your flow with the Variable and the static threshold value (choose the Greater Than operator)
    If Variable > than threshold value, Execute the Add a Row action.
     
    To sum up Service Interval and Forge Shots columns, simply select the two columns in the column input field of the action and put a + sign in between. 
     
    Hope this helps. 
     
    Kind regards, 
    Nandit
     
    If this answers your query, please mark this response as the answer.
    If its helpful, please leave a like. Thanks!
     
  • jamescosten Profile Picture
    643 on at
    Thank you.
     
    For the:
     
    To sum up Service Interval and Forge Shots columns, simply select the two columns in the column input field of the action and put a + sign in between
     
    This didnt work as its put the following in the Excel table.
     
     
    That should say 80.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard