SOLVED

How to find the total no of tasks created so far for a Particular plan in Planner?

Copper Contributor

Hi, 

Through Power Automate work flow I am creating tasks in Planner based on email. I don't know how many tasks created so far. Since the maximum tasks in a particular plan limit is 9000 I want to know the number of tasks created so far, so that I get to know when it's going to reach it's maximum limit. Any help would really be great. Thank you.

1 Reply
best response confirmed by Sheela975 (Copper Contributor)
Solution
Initially, I considered using notifications as the best way to alert you when you're nearing limits. However, I realised that relying on manual actions might not be ideal when you're trying to navigate your day, week, month, or even your year (as in the Friends reference) without interference. So, here's an alternative approach:

I propose archiving tasks after a specific timeframe, which depends on your incoming task volume. For instance, I would create a Power Automate flow that identifies tasks completed and surpassing 20 days since creation, moving them to a dedicated "Archive Plan" (a new plan you can set up). Subsequently, the Power Automate flow would then delete these tasks from the original plan. This method safeguards your plan from approaching its limits without requiring constant manual intervention.

Admittedly, your Archive Plan may eventually become full. To address this, you can repurpose the Backup automation I developed (accessible in this community hub). By using a Power Automate to transfer anything in the Archive Plan older than 60 days to a excel file, you can maintain a downloadable archive of your tasks in an Excel document on your system. This ensures that the Archive Plan remains unburdened.

I hope this solution proves helpful. Feel free to reach out if you need further assistance.

Matt James Davis
No More Bad Mondays
1 best response

Accepted Solutions
best response confirmed by Sheela975 (Copper Contributor)
Solution
Initially, I considered using notifications as the best way to alert you when you're nearing limits. However, I realised that relying on manual actions might not be ideal when you're trying to navigate your day, week, month, or even your year (as in the Friends reference) without interference. So, here's an alternative approach:

I propose archiving tasks after a specific timeframe, which depends on your incoming task volume. For instance, I would create a Power Automate flow that identifies tasks completed and surpassing 20 days since creation, moving them to a dedicated "Archive Plan" (a new plan you can set up). Subsequently, the Power Automate flow would then delete these tasks from the original plan. This method safeguards your plan from approaching its limits without requiring constant manual intervention.

Admittedly, your Archive Plan may eventually become full. To address this, you can repurpose the Backup automation I developed (accessible in this community hub). By using a Power Automate to transfer anything in the Archive Plan older than 60 days to a excel file, you can maintain a downloadable archive of your tasks in an Excel document on your system. This ensures that the Archive Plan remains unburdened.

I hope this solution proves helpful. Feel free to reach out if you need further assistance.

Matt James Davis
No More Bad Mondays

View solution in original post