Getting all tasks in a Group

[Firefly1]

Hi there,

I am looking for a way to get all the taks in a group. The problem we face is that we have variable Plan ID's because so i cannot us the ID of a standard plan in the group. That's why i need the tasks on group level.

Other option could be the get all tasks with a certain word in it. 

Hope someone can help.

Robert

[Expiscornovus]

Hi @Firefly1,

You can combine a couple of Graph API requests. I would suggest to use the List plans in a group and the list plan tasks methods. 

I tried combining them into one with an expand, but Graph API does not seem to support that. Also filtering on tasks seems to be not supported. That's why I am using a Filter array action instead.

Below is an example

1. First Send an HTTP request action (groups connector) uses the uri below to retrieve all plan ids of a group:

https://graph.microsoft.com/v1.0/groups/@{variables('GroupId')}/planner/plans?$select=id

2. Apply to each uses result from the value property

outputs('Send_an_HTTP_request')?['body']['value']

3. Second HTTP request action retrieves the tasks per plan id

https://graph.microsoft.com/v1.0/groups/@{variables('GroupId')}/planner/plans/@{item()['id']}/tasks

4. Filter Array filters for tasks with a title which contains a certain word (Stored in a string variable called CertainWord)

From

outputs('Send_an_HTTP_request_-_Tasks')?['body']['value']

Filter Criteria

@contains(item()['Title'], variables('CertainWord'))

[Firefly1]

@Expiscornovus thanks for the input so far step 1 until 3 works, when i try to save step 4 i get the following error:

Flow save failed with code 'InvalidVariableOperation' and message 'The inputs of workflow run action 'Filter_array' of type 'Query' are not valid. The variable 'opgeleverd' must be initialized before it can be used inside action 'Filter_array'.'.

This is the filter criteria i added:
@contains(item()['Title'], variables('opgeleverd'))

[Expiscornovus]

Hi @Firefly1

I have added an Initialize variable action at the beginning of my flow. Forgot to add that to the screenshot, my bad 😅.

Please add that action as well, with in your case the name opgeleverd.

[Firefly1]

Hi @Expiscornovus ,

That worked, as initialize variable type is used string.

When i tested the step, the last step failed:

Any idea why?

[Expiscornovus]

Hi @Firefly1,

I used the value property nested within the body of the Send an HTTP request 2 action response. Can you make sure you also used the value property?

Try to add it as an expression in the From field of the filter array:

outputs('Send_an_HTTP_request_2')?['body']['value']

[Firefly1]

When i use this value in Apply to each:
outputs('Send_an_HTTP_request')?['body']['value']

I cannot save it, flow checker gives the following notification:
outputs('Send_an_HTTP_request')?['body']['value']

Is it possible for you to export your flow so i can import it and try?

[Firefly1]

@Expiscornovus the problem seems to be cause by the ['value'] of the outputs('Send_an_HTTP_request')?['body']['value']

Or do i have to insert a specific value to replace ['value'] with?

[Expiscornovus]

Hi @Firefly1,

Can you please use the code snippet I shared earlier? The name of the action needs to exactly match whatever name you are using in that outputs function.

Since your action name in your screenshot of the HTTP request action within the apply to each loop is 'Send an HTTP request 2' the expression should be:

outputs('Send_an_HTTP_request_2')?['body']['value']

Your expression refers to the first HTTP action which only retrieves the plans and is outside the loop. 

[Firefly1]

@Expiscornovus my apologies for the confussion, your solution worked!

Thanks.

The next challange we face is the following:
- We now have access to all the tasks in the group. The task "Project opgeleverd" can be found in several projects inside this group.
- When the task "Project Opgeleverd" is marked completed, we want to create a new task in this specific plan/project in which the task "Project Opgeleverd" is assigned to.

Do you know how to establish this?

[Expiscornovus]

Hi @Firefly1,

In the Filter array you can add a second condition to check if the percentComplete field is equal to 100 (aka completed).

Use the below expression instead:

@and(contains(item()['Title'], variables('opgeleverd')), equals(item()['percentComplete'], 100))

After that action you can add another apply to each, which can loop through the body of the Filter array. If that Filter Array does not return any completed tasks, it will simply skip it.

Within that apply to each you can add a Create a new task action. Make sure you use the items function to refer to the plan id:

items('Apply_to_each')['id']

Below is an example

[Firefly1]

@Expiscornovus your input has been very helpful, thanks again!

The flow runs without any errors however when i test it by completing the task 'Project Opgeleverd' in the group Projecten, no new task is created.

When i check the run, the percentagecomplete of the task is changed from 0 to 100.

As a trigger we have Recurrence timer that runs every day at certain hours. As extra input to prevent old tasks from being used for this flow i have added to check the date of today to the Filter Array string:

equals(formatDateTime(items('apply_to_each')?['completedDateTime'], 'yyyy-MM-dd'), formatDateTime(utcNow(), 'yyyy-MM-dd'))

The complete line:
@and(contains(item()['Title'], variables('project opgeleverd')), equals(item()['percentComplete'], 100), equals(formatDateTime(items('apply_to_each')?['completedDateTime'], 'yyyy-MM-dd'), formatDateTime(utcNow(), 'yyyy-MM-dd')))


Do you have any idea why the no new task is created? 

[Expiscornovus · Accepted solution]

Hi @Firefly1,

I noticed you renamed your variable a couple of times already in the expressions? Just to be sure, in the expression we use the name to refer to the correct variable name of the initialize variable action.

However, the text we are using to find the correct tasks (in this case Project opgeleverd) is in the value field of that Initialize variable action.

And for the complete line can you try something like below?

@and(and(contains(item()['Title'], variables('CertainWord')), equals(item()['percentComplete'], 100)), equals(formatdatetime(item()['completedDateTime'], 'yyyy-MM-dd'), utcNow('yyyy-MM-dd')))

[Firefly1]

@Expiscornovus the solution worked, thanks!