Power Platform Community Forum Thread Details

I'm working on an automation for creating tasks in Planner, where the trigger is the creation of an item in SharePoint. My flow encountered an issue where the number of items created exceeded the limit of ongoing tasks in Planner, which is 2,400. Initially, I split my flow into two plans (since I have two types of requests), but over time I realized that dividing them into just two was not sufficient, as the task assignees were unable to keep up with the speed at which tasks were being created.

That's when I decided to create backup plans to relieve these main plans and added a step before the task creation. I included an action to list tasks in Planner, and after this step, I used the 'Filter Array' action to filter only the tasks with a completion percentage different from 100. I then stored the count of these tasks in a variable. After this step, I use a conditional to check if the number of tasks is less than 2,390. If it is, I proceed to create the task in the primary plan; otherwise, the task is created in a backup plan.

I thought the flow would work smoothly, but I’m experiencing many instances where the flow gets stuck running at this stage, and I’m not sure what might be causing this. (I’ve already limited pagination to 4,900, knowing that the limit is 5,000, in case this might be causing an issue.) Does anyone have any ideas on what might be happening? I’ll send a screenshot of the setup (it’s in Portuguese).

This flow has been running for 20 minutes, but there are some instances where it runs for more than 3 hours before I have to cancel and restart it. Any help would be appreciated!

Categories:

General topics

It's hard to offer any recommendations without seeing your full flow and the logic behind it. Toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.

In the meantime, you might be interested in this YT Tutorial:

⚡️Automate Microsoft Planner Tasks: Create Tasks from SharePoint & Excel in Minutes

In this Microsoft Power Automate tutorial I’ll show you how to build a flow that will:
⚡️ Create a task in Planner for each of your SharePoint list items
⚡️ Create a flow that will trigger each time a new SharePoint list item is created
⚡️ Create a tasks in Planner from an Excel Table
⚡️ Add a description to your tasks

---
IN THIS VIDEO:
✅ How to bulk create Planner tasks from a SharePoint List
✅ How to use the Get Items action with a filter query
✅ Tips on creating a fast flow while building and testing
✅ How to create a string of email addresses from a multi-person choice column
✅ How to dynamically select a bucket in the Create a Task action
✅ How to use the Filter Array action
✅ How to use the Condition action
✅ How to use the Create a Task action
✅ How to automatically create a Planner task when a new SharePoint list item is created
✅ How to bulk create Planner tasks from an Excel Table
✅ How to add a task description to a Planner Task

Hope this helps!
Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram