Unanswered

Summary of Sharepoint List to another sharepoint list

(0) Share

Report

Posted on by JohnKenneth

I have a project that requires to summarize the data from List1 to List 2 every time there's a new data created in List1.

List1: Raw data

TransactionDate	Branch	Amount
10/16/2020	Branch 1	500
10/17/2020	Branch 1	400
10/17/2020	Branch 2	600
10/17/2020	Branch 2	400

List2: Summary from List1

TransactionDate	Branch	Amount
10/16/2020	Branch 1	500
10/17/2020	Branch 1	400
10/17/2020	Branch 2	1000

I tried to read other related problem but other post are using 2 variable.
In my case, I need to consider 3 factor.

Thank you in advanced for those who are willing to help.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Ed Gonzales 4,531 Most Valuable Professional on at

Like (1)

Report

@JohnKenneth

Hi there. I did something similar in this article:

Group By and Sum in Power Automate / Flow

Except, in yours, it looks like you want to group by on two different levels, right? (Date and Branch). To group on that, you could probably either add another level, or concatenate the two, group, and then split.

Either way, that article should get you started. Good luck, and keep us posted.

-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.

Was this reply helpful? Yes No
JohnKenneth 12 on at

Like (0)

Report

Thank you very much @edgonzales for the input.
Yes you are correct, my data is in 2 levels summary.
I will try to follow your steps to create a summary.
But if found sample as well doing a 2 level summary will be much appreciated.

-Kenneth

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @JohnKenneth ,

Have your issue been solved according to @edgonzales 's solution?

If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

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.

Was this reply helpful? Yes No