Power Platform Community Forum Thread Details

Hello everyone,

Currently, I am building a flow that sends reminder emails to all assigned users whose tasks have been overdue for the last 7 days. Since it's a huge planner (several in parallel triggers as well) with many tasks and a project pipeline, I don't want to send a Mail for each task. I want to build an array that always adds a task title, DueDate and TaskDetails to it and checks beforehand if the array already has the user included or not.

The current flow works fine to filter out all tasks with the given criteria → task not completed, has a due date / time, and is overdue, min. 7 days. After that, I get the task details and user profiles with the filtered task ID.

How can I properly create an array that is built like this for each user?

{
    "UserId": "currentTaskAssignedUserId",
    "Tasks": [
        {
            "Title": "Task Title",
            "Details": "Task Details"
        }
    ]
}

If the user is already in the array, just add the task to the array and the user. Therefore, I can send one mail to each user with a list of all open tasks. Is it even possible or is there another work around?

Thank you very much and best regards,
Leander

Categories:

Building flows