What is my flow about :
Once a month, I have to retrieve all the Planner tasks of 100+ groups into a SharePoint list to feed a Power BI report.
- Recurrence trigger
- Initializing 10 variables
- HTTP request to Office 365 Groups to get all groups which names begins by "ProjectXX-".
- For each group > on 150 groups
- get the corresponding line in a Excel file (that gets me lots of information)
- get all the Planner plans and filter those to get only the planner called "Project XX"
- Get all details of the Project XX plan
- Set several variables (groupName, groupID, planName, planID, categories)
- Get all the tasks of Project XX plan
- For each task > approx 150 tasks per group
- Get the SharePoint list Item with title equals the task ID
- Condition : does it exist in the list ? Yes > Delete. No > Do nothing
- Get task details
- Set variables (categories, is it late, get assigned user displayname...)
- Create the task in the SharePoint list
- Reset 5 tasks variables
- Reset 5 groups variables
- Refresh Power BI data set.
Do you have any idea how to :
- Batch delete all the items of a List at once ? Without passing through a for each step ?
- Optimize my flow's duration (less than 1 day ? is it possile or am i too hopeful ?)