Unanswered

Help with string for listing only active Planner tasks, and listing only active Todos

(0) Share

Report

Posted on by SimonB2020

Hi there Microsoft Community!

I am trying to build a scheduled flow to go through active (uncomplete) titles of Planner tasks, and active (uncomplete) Todo tasks.

A end of day sync as my flagged emails create Planner tasks.

Idea will be if the title/subject is the same, it will do nothing.

But if there is a mismatch, and one active title exists, it will complete either the ToDo Flagged emails folder or Planner task.

In a past flow I used on trigger

'When a to-do in a specific folder is updated (V2)':

@equals(triggerOutputs()?['body/status'], 'completed')

but this scenario is quite a bit different.

So far this is what I have, and no success.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @SimonB2020,

You can use a Filter Array directly after your List to-do's by folder (V2) action to only retrieve active tasks. This will make the list of tasks you are using to compare a lot shorter. (You can also do the same for planner tasks as well).

Below is an example of using such a filter array.

Use this for the where statement

@not(equals(item()?['status'], 'completed'))

Was this reply helpful? Yes No
SimonB2020 40 on at

Like (0)

Report

Thank you for this!

Was this reply helpful? Yes No
SimonB2020 40 on at

Like (0)

Report

Actually @Expiscornovus it will not allow me to enter that expression, it keeps coming back as invalid.

Any ideas?

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @SimonB2020,

You added it directly after your List to-do's by folder (V2) action and used the Body in the From field? Did you try copy/pasting it into the action via edit in advanced mode option?

Below is an example (click on the gif to see it in higher resolution).

Was this reply helpful? Yes No
SimonB2020 40 on at

Like (0)

Report

woops @Expiscornovus , noob mistake.

Thanks again!

Was this reply helpful? Yes No