We have creagted a flow that once a day lists that tasks that are assigned to different employees in the company in the Task Management module in Dynamics 365 Human resources. We filter out the tasks that are completed and canceled, and we only look for tasks that are due in 10 or 3 days, or that is due today or is overdue.
By using Vitual Tables in Dataverse to gather this data, we’ll have the flow looking up the data we need in other tables than the table for tasks, as we of course want the email to be sent to the assigned employee, with the information the employee needs to perform the task:
It finally works like a charm, as we now in Dynamics 365 Human Resources have 1 overdue task, and no tasks falling due in 10 or 3 days or today, and the flow sends 1 email with the correct information: