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 / Add rows into a table ...
Power Automate
Answered

Add rows into a table and then sum up values

(0) ShareShare
ReportReport
Posted on by 19

Hi everyone, I have a flow that adds rows into excel file. I want the flow to sum up values after adding rows to show total amount and count at the end
How to do this?

BenWadeZ_0-1706269804900.gif

BenWadeZ_1-1706269842449.png

 

Categories:
I have the same question (0)
  • Bartelli Profile Picture
    75 on at

    I would add two steps: 1-get rows from the table you just created using "list rows present in a table" 2-add a row into a table and add an expression to add a sum and a count to amount and receipts, respectively. You'll need to make sure you have a table created.

     

    Let me know if this helps.  Thanks!

  • Verified answer
    BenWadeZ Profile Picture
    19 on at

    I just manually added in excel file =sum([Amount]) and =count([Amount]) and it worked like a charm.

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 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard