Power automate: How to sum colum for distinct IDs

[pesnoslen]

Hi Everyone,

Hope you're all fine and safe.

I'm a newbie with power automate and I try to do something equivalent as sumifs in Excel.  So I need you support and skills to achieve my needs.

please see below an example of my need.

I have a sharepoint site with the follow items.

In the column "Cumul", I would like the result of the sums from "Machines_activées" for every the disctinct id of column "C4C"

I've tried to get this by a power automate flow, but I don't know how to proceed.

I'm stuck with the below outputs. If I sum those datas, set on a variable using an "add" expression, I get back an addition of all the data in the column.

So I would like to know how to sum data for every distinct ID and then update the column "Cumul".

You're support will be greatly appreciated.

Best regards

[CheckMate]

@pesnoslen 

just curious, are the ID's standard in the list or would there be new ids, if they can be hard-coded in switches.

[pesnoslen]

Hi CheckMate,

the IDs are standard, these will be identifiers with 5 or 6 numeric characters provided by a CRM.

[pesnoslen · Accepted solution]

Hi,

I've found a workaround to do this.

I'll close this request.