HI
There are loads of example of how to do this, yes its easy to do.
1. Create a Reoccurring Flow (whatever timing you want)
2. Use a Get Items to get all the rows that you want
--Add a filter if you need it (by date or whatever)
3. Add a Select Action
For the input use the Dynamic Property (body/value) from the Get Items in step 2
In the Map field, Put the term Resource (since thats your column name)
In the Value put item()['Resource']
this will create an array of Resource names. Now the name will be duplicated since they can have multiple Tasks, but what you want is to
group BY the Resource
So we have to create a Unique Version of our Resource array from the Select
4. Add a Compose Method
-lets assume you have NOT renamed your select action, its name will be Select in the header of that action
-Click inside the Box of the Compose
-Type this
union(body('Select'),body('Select'))
What the above does is does a Union on itself, which removes the duplicates
5. Add an Apply to Each Condition
Input = the Output of the #4 Compose methods
6. Inside the Apply to each now we want to get all the values for just them, so we are now looping through them, but not we have to
use a Filter action to Filter the output of step #2 above, using the Resource Email or Name.
--NOTE I don't know if Resource is their full name or email or what??????
Add a Filter Action
The input is the body/value of #2
Then left side put Resource
in the middle equals
Right is item()
Ok.. now that will make our loop grab only the data for the current Resource
Now to build our HTML REport and email it
7. Add Another Select
Input is the output of #6
For each Column you want in the report you would put (on the right) the column name and in the left put expression item()and then ['COLUMNNAME'] in the dynamic window
#8 Add a Create HTML Table action
the input is the output of #7
#9 Add an Email Step
1 for the email address... i dont know if thats the resource field or what
2 put the subject as whatever you want or generate it via expressions
3. Add the body (in which cause you would use the Output of the step 8 as part of the body)
4. add the To value (which is the resources email
and you are done.
