Need Help With Plnner Daily Digest

[Neverous]

Hello,

I'm trying to customize the following template: Send a digest email of all outstanding Planner tasks

I'd like for this flow to generate a list of outstanding planner tasks that are due in the next two weeks. I've seen a couple of other threads that address this issue and I've tried using their solution but none of them seem to be working for me. Here is the flow that I currently have:

 

 

The formula I'm using above is an accepted solution from another thread: 

@And(not(equals(item()?['percentComplete'], int(100))), less(item()?['dueDateTime'], addDays(utcNow(), 14, 'yyyy-MM-dd')))

 

This flow successfully sends an email of outstanding tasks that are in Planner but it lists every task that is outstanding and not just the outstanding tasks coming due in the next two weeks like what I'm looking for. Am I not referencing something in the correct order in this flow? I've tried changing a few different things to see if I can get this to work and have used another accepted solution but I'm still getting all outstanding tasks listed in the email that is sent out.

Thank you for any help!

[v-liwei-msft]

Hi @Neverous 

To filter tasks due within the next two weeks, not only need to filter whether the due date is less than today's date plus 14 days, but also need to filter whether the due date is greater than or equal to today's date.
This is done to avoid getting expired tasks.
I made a test for your reference:

@And(not(equals(item()?['percentComplete'], int(100))),greaterOrEquals(item()?['dueDateTime'], utcNow()), less(item()?['dueDateTime'], addDays(utcNow(),14)))

Best Regards,

Levi

[Neverous]

I tried using the formula you provided above in the location where I had my formula. However, I just kept getting an error with this new formula so I couldn't test it. I looked over what I wrote to make sure there were no grammar issues but it looks the same as what you provided:

 

[v-liwei-msft]

Hi @Neverous 

According to the formula you provided, in the item()?['dueDateTime'] part in greaterOrEquals(item()?['dueDateTime'], utcNow()) you used braces.
You should change it to square brackets.

item()?['dueDateTime'] not item()?['dueDateTime'}

Best Regards,

Levi

[Neverous]

Sorry for the delayed response but I was away from my computer for a few days. Thank you for spotting that syntax error. I made the correction you pointed out and that fixed the issue with my flow not functioning. However, I'm still getting the same results overall with what information I'm being sent in the email. It still includes tasks with due dates more than 14 days from the current date.