cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Flow to sum a group of list items and copy/update total to a column in another list linked to the Employee

Hi I am new to builing flows and have been trying to get a sum of a group total to be added in a column in another list when a new item is created.

Linked by the EmployeeName on both lists.

When item is created sum days booked by EmployeeWhen item is created sum days booked by EmployeeCopy the grouped sum by employee to TotalHolidayBooked ColumnCopy the grouped sum by employee to TotalHolidayBooked Column

So what I need in Holiday Entitlement List is the figure of what I can get in the Holiday Approved list as a View with group sum.

Eg. Employee 1 has booked 5 days in Approved list and this total of 5 needs to be added in the Entitlement list for TotalHolidayBooked in the row for Employee 1.

 

Can anyone help?

Thanks in advance

Emma

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Flow to sum a group of list items and copy/update total to a column in another list linked to the Employee

Hi @EmmaWatt ,

 

I assume that you are using EmployeeName as a grouping criterion and then calculate the sum of the groups in Holiday Approved List.

 

You could configure your Flow by referring to the following method.

  • Get all the EmployeeName by variable and then remove the duplicate values.
  • Iterate through all the EmplyeeName, get the corresponding Employee's Booked Days through Filter Query, and use the Increment variable to sum.
  • Use Get items action again to get the item corresponding to Employee in Holiday Entitlement list, and then update the value of TotalHolidayBooked field.

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Flow to sum a group of list items and copy/update total to a column in another list linked to the Employee

Hi Barry,

Thank you so much for the help, but I cant get the dynamic "Current Item" in the Get Items 3 ? Am I missing a step ?

Best regards

Emma

 

No Current Item for get items 3.PNG1.PNG2.PNG3.PNG4.PNG5.PNG

Highlighted
Frequent Visitor

Re: Flow to sum a group of list items and copy/update total to a column in another list linked to the Employee

Hi Barry,

Thank you so much for the help, but I cant get the dynamic "Current Item" in the Get Items 3 ? Am I missing a step ?

Best regards

Emma

 

No Current Item for get items 3.PNG1.PNG2.PNG3.PNG4.PNG5.PNG

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,444)