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

use flow to sum some row in excel

In my excel 

 

A,B

name_A,10

name_A,20

name_B,30

name_C,20

name_C,10 

 

First  I use jason and union function to let A only "name_A","name_B","name_C"  ,then I use other jason to get all excel data .

Now , I need to calculate  to show like this 

name_A,30

name_B,30

name_C,30

 

when I use condition to filter my two jason , It fail and take more than 20 min , so how can I config flow to get my goal ???

 

20191222-1.JPG

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: use flow to sum some row in excel

Hi @JACK_LAI ,

 

I have made a test on my side to create a excel table in my OneDrive for business as below:

1.png

 

You could refer to screenshot below to create the flow:

2.png

3.png

 

4.png

5.png

 

The flow would run successfully as below:

6.png

 

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

JACK_LAI
Level: Powered On

Re: use flow to sum some row in excel

ok ..... I will try it this afternoon 

 

@v-alzhan-msft  thank you very much

 

View solution in original post

6 REPLIES 6
Super User
Super User

Re: use flow to sum some row in excel

@JACK_LAI 

Hi there.  Just checking the parameters of your scope:

 

  • Is there an opportunity to have Excel do the hard work with summing the data in a fixed field and then grabbing that field from a flow?
  • Will it always be a fixed count of names?  (In your example, there were 3...will that always be so, or could that fluctuate?)

 

Keep us posted.

Thanks!

-Ed-

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Community Support Team
Community Support Team

Re: use flow to sum some row in excel

Hi @JACK_LAI ,

 

I would make a test on my side to create the flow, I would reply here when I finished.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team
Community Support Team

Re: use flow to sum some row in excel

Hi @JACK_LAI ,

 

I have made a test on my side to create a excel table in my OneDrive for business as below:

1.png

 

You could refer to screenshot below to create the flow:

2.png

3.png

 

4.png

5.png

 

The flow would run successfully as below:

6.png

 

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

JACK_LAI
Level: Powered On

Re: use flow to sum some row in excel

ok ..... I will try it this afternoon 

 

@v-alzhan-msft  thank you very much

 

View solution in original post

JACK_LAI
Level: Powered On

Re: use flow to sum some row in excel

@v-alzhan-msft 

 

My excel record has 47 rows and after duplicate "A" has 26 records , But it takes more than 17 mins to complete 

So how can I speed up my flow ???

 

20191223-2.JPG

 

Community Support Team
Community Support Team

Re: use flow to sum some row in excel

Hi @JACK_LAI ,

 

The flow is very streamlined, I'm afraid that there is no any other solution.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,459)