Beginner question: Check all Microsoft To-Do daily for the latest change

[m-s]

Hello everyone

I want to prevent a task from remaining unedited for too long and therefore write a flow that checks all Microsoft To-Do tasks to find the X days have not been changed.
The Microsoft To-Do Connector knows "lastModifiedDateTime" that should be the right thing to do, but how do I check all tasks in one go?

Can someone me in the right direction.

m-s

[v-bacao-msft]

Hi @m-s ,

You could refer to the following expression to filter tasks.

For example, filter out tasks that have not completed and have not changed in seven days.

@and(lessOrEquals(formatDateTime(item()?['LastModifiedDateTime'], 'yyyy-MM-dd'), addDays(utcNow(), -7, 'yyyy-MM-dd')),not(equals(item()?['Status'], 'Completed')))

Please take a try and feel free to let us know if you have any other questions.

Best Regards,

[m-s]

Hello @v-bacao-msft,
Thank you for the quick reply.

It took me a while to understand that you used the Outlook tasks for Outlook as a connector instead of the Microsoft To-Do connector.

Yesterday, execution stalled, maybe an error or generated too many mails, but this morning at the set time the tasks were searched and sent me corresponding mails.

So first of all, thank you very much.

I have one more question. Can I include a link to the corresponding task in the mails so that I can access it directly from the mail?

I'd love to use that in other flows, because then there's a link to a mail in a task, or to a OneNote page.

Is there a system for how the links are composed?

m-s

[v-bacao-msft · Accepted solution]

Hi @m-s ,

Please try to refer to the following method. Output by Compose is the link to the task.

Hope this helps.

Best Regards,

[m-s]

@v-bacao-msft
Thank you again.

When I first called a url created like this, I had an English-German mixed page of To-Do.
But that was probably only because I wasn't logged in.

Otherwise, it works exactly as expected, even if I think it's a pity that the website is always called instead of the software.

In any case, with the "flow" I can think about how to let the tasks signal to me, because at the moment I get more old tasks reported than I could watch in a day 🙂