Sending latest 24 hours completed tasks in planner for manager by mail

[drweby2]

I am trying to create a list of completed tasks in the last 24 hours to be sent by email to the manager of the employee who completes the task, the problem that I can't create the list but the data send separately to the email .. here is my flow

[v-bacao-msft · Accepted solution]

Hi @drweby2 ,

You can use multiple Filter arrays to filter the tasks. Then create the HTML table and send it as the body.

Image reference:

Hope it helps.

Best Regards,

[drweby2]

thx a lot for the great flow, I have some problems in the output I hope you can help me to fix them

1.i try to add the title of the task as a link so I add in first column value <a href="https://tasks.office.com/volaagency.com/en-us/Home/Task/@{item()?['id']}">@{item()?['title']}</a> but it does not work

2.how can i replace the user id that complete the task by his name?

3.how can i replace the bucket id by the bucket name

4.how can i add a row in the html table with the username of the user assigned to the task added to the table