cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pesnoslen
Regular Visitor

Power automate: How to sum colum for distinct IDs

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"

Pic_26072021_2154.png

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

Pic_26072021_2155.png

You're support will be greatly appreciated.

Best regards

1 ACCEPTED SOLUTION

Accepted Solutions
pesnoslen
Regular Visitor

Hi,

I've found a workaround to do this.

I'll close this request.

 

View solution in original post

3 REPLIES 3
CheckMate
Resolver I
Resolver I

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

Hi CheckMate,

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

 

 

 

pesnoslen
Regular Visitor

Hi,

I've found a workaround to do this.

I'll close this request.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,595)