PowerAutomate - Condition to look for Planner tasks due in the next 7 days

Question

Hi,

I am try to create an email that is sent to a project manager to give them a daily update of all tasks that are due in the next 7 days.

I found this code below that works, but only for ones 7 days out. If something is due in 6 days, it won't appear in the email.

@and(equals(formatDateTime(item()?['dueDateTime'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(),7 ), 'yyyy-MM-dd')),less(items('Apply_to_each')?['percentComplete'], 100))

Any help is greatly appreciated!

Answer 1

Hi CBerry34,

Based on your post, I found a similar article that might help you achieve your goal:

Solved: URGENT - Automatically setting Planner Due Date to... - Power Platform Community

Use Microsoft Flow to remind the Team of due dates from Planner

How to dynamically calculate working business days for a due date in Power Automate

***Third-party Disclaimer:***Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

Since you are using Power Automate, if you meet any issue creating the flow,, we’ll suggest you post in Microsoft Power Automate Community for expert assistance. This is a specific channel related to issues with Power Automate.

The reason I request you to post a new thread is that in Answers forum, we have limited resources and very little knowledge about Power Automate flow and in Microsoft Power Automate Community, you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction.

We appreciate your understanding.

With Sincerest Regards,

Neha