cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JACK_LAI
Level: Powered On

how can I sum all rows value

Hello , my excel file has four column , and one column is number ( like 2,50,9,0,33.....etc) , I want to sum all rows and put it in to a string variable  .

 

So how can I get it ??

1 ACCEPTED SOLUTION

Accepted Solutions
StefanR
Level 8

Re: how can I sum all rows value

Hi @JACK_LAI ,

 

ich have put the following File to my OneDrive:

 

FlowHelpFile.png

 

The flollowing Flow will iterate through the Rows and increment the Variable "Sum".

 

FlowHelpPicture.png

 

The Varibale Sum will now have the value of the sum of the Col1.

 

Hope that helps!

 

Best regards

Stefan

View solution in original post

2 REPLIES 2
StefanR
Level 8

Re: how can I sum all rows value

Hi @JACK_LAI ,

 

ich have put the following File to my OneDrive:

 

FlowHelpFile.png

 

The flollowing Flow will iterate through the Rows and increment the Variable "Sum".

 

FlowHelpPicture.png

 

The Varibale Sum will now have the value of the sum of the Col1.

 

Hope that helps!

 

Best regards

Stefan

View solution in original post

JACK_LAI
Level: Powered On

Re: how can I sum all rows value

@StefanR 

 

Thank you for your help 

 

Now I can get the result what I need 

 

Heart

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 274 members 5,347 guests
Please welcome our newest community members: