Answered

Grouping by Employee and Weekly Hours

(0) Share

Report

Posted on by 3R-Automation

I want to build an MS Flow which would organize the List data by Employee and then tabulate the Employees monthly total hours and post the hours in an HTML table, then process the next Employee.

I already have a list that captures the Employee hours each week and captures the total hours for that week.

Might there be an example which would show how to group by Employee and then further group by total hours? I am assuming this will be two Apply to Each action which first passes in the employee as a set into the next. But I am not clear how to organize this into HTML as we have 5 employees. All the data has to appear in an email as the accountant likes that format.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@3R-Automation I tried this not sure about your list schema, I have a week column so it can be used to filter week or you can also use month values from Jan to Dec and it is needed so we don't hit the threshold limit and get only limited records

You can also format and make the table more beautiful but I leave that to you, this is just high level approach you can make changes as per your use case.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
3R-Automation 47 on at

Like (0)

Report
Copy link

Link copied!

The inserted image is what the accountant would like the report to be organized like. The employee hours data is in a list and does contain the hours for each day and the calculated total of the hours for the week. What I need to do is to build a flow which passes in the Start Date and End Date and then groups the data by Employee, organizes the Start and End dates so they correspond by the Weeks in the month. And then calculate the totals for each column based on the employee. If I had hours during the month of January for employees: Bob, John and Clint then the script should group the hours for Bob, John and Clint to do the calculations on totals and organize the hours into tables with the totals under each block.

Was this reply helpful? Yes No
Verified answer

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@3R-Automation this is what I have tried
In first Get items I have filter which is hard coded as highlighted
then I create table and in second Get items I have filter which is hard coded with Jane then I create html table and then pass to Email action. You can repeat the same for other employees as well.
You can work on formatting of email.

This is not the best approach but considering this is only for 5 employees I won't invest a lot of time/efforts. Also for total I have another flow (when item is created/updated) which would update total so in the above flow I can just extract the value of total.
The total at the bottom of table for Monday, Tues etc is not possible.

Hope this helps.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
3R-Automation 47 on at

Like (1)

Report
Copy link

Link copied!

Very nice, I never thought about using hard-coded employee names. I was off on a tangent using JSON to collect all the hours and then figuring out how I would total. But I could technically have an array of the employees and then have a loop that steps through that array and builds the HTML one at a time and emails them. The Accountant is OK with having the employee hours sent one at a time, and that might be easier for her to tabulate. I already can do a calculation of the total hours to produce a total.

Was this reply helpful? Yes No