cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
3R-Automation
Helper I
Helper I

Grouping Employee Hours in a Flow

So I have a SharePoint App that allows the company employees to enter their weekly hours.  The app has a data integrator that exports the hours to a SharePoint List.  Each week, I would like to email our accountant an HTML list of all the employee hours grouped by the Employee name, Project and Task with totals.  

 

I already have an MS Flow that schedules and emailed the total hours, but frankly, the list is rather confusing, and it would be nice to group out the hours by employee. 

 

Any suggestions on how to get started to group the list?

 

 

1 REPLY 1
mahoneypat
Solution Sage
Solution Sage

This would be easier with Power BI and a paginated report (set up subscription with formatted report), but it could be done in a Flow too.  See if these two articles help you get started.

Solved: Get Items from SharePoint list, compose email body... - Power Platform Community (microsoft....

Group By and Sum in Power Automate / Flow (flyingpolymath.com)

Pat

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (47,023)