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
Solved! Go to Solution.
just curious, are the ID's standard in the list or would there be new ids, if they can be hard-coded in switches.
Hi CheckMate,
the IDs are standard, these will be identifiers with 5 or 6 numeric characters provided by a CRM.
Hi,
I've found a workaround to do this.
I'll close this request.
User | Count |
---|---|
22 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
45 | |
29 | |
25 | |
24 | |
24 |