Answered

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.

All responses (5)

Answers (2)

SimonB2020 40 on at

Like (0)

Report

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

woops @Expiscornovus , noob mistake.

Thanks again!
Verified answer

Expiscornovus 31,779 Most Valuable Professional on at

Like (0)

Report

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

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).
SimonB2020 40 on at

Like (0)

Report

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

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

Any ideas?
SimonB2020 40 on at

Like (0)

Report

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

Thank you for this!
Verified answer

Expiscornovus 31,779 Most Valuable Professional on at

Like (0)

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

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'))