Create a daily summary of incomplete Planner Tasks due this week by Bucket

(0) Share

Report

Posted on by CG-25072327-0

Hi,

I am adapting the "Create a daily summary of Planner Tasks by Bucket". The template provides a good starting point to get the data I need but I don't need a summary of everything in planner. I just want:

- Is it due this week?

- Is it 'not finished'?

I have seen solutions in this community to exclude 'not finished' from

but not how to filter the "due this week" tasks where this week is the next Saturday (or Sunday).

I tried to figure out if "dayOfWeek('<timestamp>')" might work, but it doesn't look like it would work (or I just can't figure it out).

Any ideas? Thanks

All responses (1)

Answers (1)

Verified answer

v-peijunz-msft Microsoft Employee on at

Like (1)

Report
Re: Create a daily summary of incomplete Planner Tasks due this week by Bucket

Hi @geissler

To filter the due date is in this week, the start date and the end date of the current week should be caught firstly.
Adding a new compose to get the output from the formula:
sub(dayOfWeek(utcNow()),1)
The start date of the week:
addDays(utcNow(),sub(0,outputs('Compose')),'yyyy-MM-dd')
The end date of the week:
addDays(outputs('Get_start_date_of_the_week'),6,'yyyy-MM-dd')
Here is the flow for your reference:
Hope it helps.

Best regards,
Sylvia