Automated Time Reports

[Bengood]

I am trying to build a flow that will grab all the hours for a specific employee for a 2 week pay period from the attached spreadsheet, and email them a custom excel sheet with their hours for that pay period. The only ways I can think of doing this are extremely labour intensive and would have to be done for each separate employee. Any suggestions?

[Yutao]

Hey @Bengood ,

One question here, when you send out the report to a specific employee via email, does it have to be an Excel workbook as an attachment to the email? Can it just be a table in the email body?

I feel if the above approach is acceptable, it can greatly simplify the problem.

Sending an workbook attachment is probably still doable, but might be much more complicated IMO.

Yutao

[Bengood]

 Thanks for the reply Yutao, a table in the body would work perfectly.

[Yutao]

I guess the key steps are:

1. Get a list of distinct names from the workbook
2. Loop through the distinct name list:
   1. Get rows by filtering the table with each name and the cutoff date (two weeks back)
   2. Generate HTML table for the rows
   3. Send email to the person with the generated HTML table

Specifically, here is how my test flow builds a distinct name list:

Here is the expression used in the above "Build distinct names array" step:

intersection(body('Select_to_make_names-only_array'), body('Select_to_make_names-only_array'))

Then for the loop:

Hope this helps!

Yutao