Sum a column from one sharepoint list with a condition to another Sharepoint list.

[Anonymous]

Hi,

I have to seperate sharepoint lists. "List A" show all the orders I get in from different customers:

And sharepoint "List B" show all my customers as a single item in the list.

So "List A" has alot of orders not only from different customers, but also from the same customer. What I would like to do is to sum all the order values from "List A" to "List B", matching the customer name. I am simply trying to create a sharepoint list (List B) that show the total amount or result of all the orders a customer placed in Sharepoint "List A"

This is similar to what I do in excel when I use the function Sumif.

I have been trying to make this happen for a couple of days now, but I have not found any good solution to it.

Thanks

[IzzyWizz]

Hi,

As I remember I just gave up with Flow and used a Powerapp with a bit of simple maths in the Patch function in the end. 

As it's so long ago perhaps there is a better way of doing it now? I would post a new question on the forum if I were you. I am not very good at Flow/Power Automate so you might get an answer from someone who knows what they are doing!

Izzy.

[GuyBoswell]

Hi Agnieszka,

You question raises so many questions for me!  Why?  lol Don't answer that one - I would then have to answer my why questions and sometimes it is just impossible.  But seriously...

Where is the data coming from?  Is it starting in a list or somewhere else?  Are you using a PowerAutomate approval process or something much more bespoke?  If the later, it might be worth looking at the former.  How stable is the data structure?  By which I mean, do you always have 5 approvers or could that number go up and down?  If it never EVER changes the solution may be much simpler than if you need to allow for the vaguries of management restructuring.  Manually adding up the approved and rejected lines in list 1, I don't come up with the answers you have in list 2 - so I think you will need to describe in a lot more detail what you are trying to achieve?  This looks like a pivot table.  The solution might involve using Power Automate to copy data from a Sharepoint list to a spreadsheet, then call a TypeScript in Excel to process the data, then copying the results back to update your second list.  I have found processing in Excel is more familiar and runs at about ten times the speed.  It will matter if you want something that is updated once a day or updated with every transaction? Maybe you don't need the second list, you just calculate the results from the first list and send a summary email or notification to the approvers or their boss, or whoever wants to know?  There is no right or wrong answer.  There are answers that are better than others.  And often the best answer for you will depend on which packages you know best?  I am not yet a great fan of Co Pilot but it might be worth asking Co Pilot for help - Microsoft seem to want us to use it for everything