cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Summary of Sharepoint List to another sharepoint list

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

TransactionDateBranchAmount
10/16/2020Branch 1500
10/17/2020Branch 1400
10/17/2020Branch 2600
10/17/2020Branch 2400

 

List2: Summary from List1

TransactionDateBranchAmount
10/16/2020Branch 1500
10/17/2020Branch 1400
10/17/2020Branch 21000

 

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.

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: Summary of Sharepoint List to another sharepoint list

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

Highlighted
New Member

Re: Summary of Sharepoint List to another sharepoint list

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

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (5,692)