u/CompleteChocolate149

Power Automate M365 - Get Planner Task Details - how to get around the 5,000-rows limit

Power Automate M365 - Get Planner Task Details - how to get around the 5,000-rows limit

In Power Automate Cloud, I have a flow (scheduled once a day) that retrieves all data from MS Planner; the tasks are then consolidated into a single ".json" file, which I subsequently transform into a report in Power BI. The problem is that my Plan will soon have more than 5,000 tasks, which is the limit for the M365 version of Power Automate. We also have the free version of Planner, so Dataverse isn’t an option, and unfortunately, I can’t use the Graph API.

Is there any other way to exceed the 5,000-item limit in the M365 non-premium version of Power Automate?  

https://preview.redd.it/zm8annw73ivg1.png?width=517&format=png&auto=webp&s=a7fcc29f30f17e6f7aebf8baf82de85987f2c735

reddit.com
u/CompleteChocolate149 — 6 days ago