Share
Report
4Hello, I’m trying to use Power Automate to automatically create tasks in Microsoft Planner, but I’m stuck on the part where tasks should be assigned to the correct bucket.
Here’s the workflow I want to achieve:
- Each Planner bucket is named after the person in charge.
- Excel contains the task information, including the “Person in charge” column.
- When the flow runs, it should read each row and create a task in the corresponding person’s bucket.
I have already built a flow that reads Excel rows and loops through them.
I also created an object variable (bucketMap) that stores “Person name → Bucket ID” pairs.
However, I’m not able to make the process that reflects the tasks defined in the Excel table into Planner correctly.
It does create tasks and even auto-creates buckets as needed, but I can’t put together a reliable process so that the tasks in the Excel table are properly reflected in Planner with the right details and bucket assignment.
Here is my current flow structure (screenshot attached):
- Manually trigger the flow
- List rows present in a table (Excel)
- Initialize variable
- Initialize object variable (
bucketMapwith name → bucket ID) - Apply to each (Excel rows)
- Create a task in Planner
Goal:
Use the “Person in charge” column in Excel to automatically select the correct bucket ID, and ensure that the task information in Excel is correctly reflected in Planner tasks.
Note:
I’m a beginner in Power Automate and programming, so explanations in simple terms would be greatly appreciated.
If you know the correct way to reliably reference the bucket ID from the object variable inside the loop, or a better pattern to make sure Excel task data is mapped into Planner (title, description, due date, bucket, etc.), I’d really appreciate your guidance.
Thank you in advance!
All responses (
Answers (
