Question: Is there is a way I can combine multiple Planner task creates or updates into one HTTP PUT or PATCH request?
Reason: I'm looping through rows on an Excel spreadsheet and successfully creating or updating using the built in "Create a Task" and Update a Task" connections (see attached.) However, I'm reaching connection limits to Planner (default is 100/min but I think we are upgraded to 900/min.)
Hypothesis: As I'm looping through the rows in Excel, could I create a single array of all the tasks and their updates (instead of executing the Update a Task connector?) Then outside the loop, can I make one HTTP connection and update all the tasks in the array with the updates? Not only would this reduce the number of connections but might also be faster.
I've tried to think through Pieter Veenstra's method for improving performance of Apply to Each and I'm just not sure if I can build an single HTTP payload to send all the updates anyways...and what URL do I PATCH to...and how I would construct the body. Has anyone tried this? Comments/suggestions are appreciated.
Current flow attached for reference.
