Unanswered

Help Needed with Power Automate Flow for Teams Planner

(1) Share

Report

Posted on by SV-01052050-0

Greetings,

A couple of years ago, someone helped me create a Power Automate flow for Microsoft Teams Planner and even shared a screenshot of the process. I’m now trying to follow the same steps, but I’m running into issues. Please see the attached screenshot for your reference.

I’m trying to build a flow using an Excel sheet to populate tasks into Planner. The Excel file contains over 100 tasks, each with different start and end dates, multiple task owners, and five different buckets. I want the tasks to be routed to their respective buckets accordingly.

Could someone help me identify what’s going wrong and guide me through the updated process to make this flow work?

Thank you in advance for your time and support!

Categories:

Building flows

vpeijunzmsft_2-16...

vpeijunzmsft_5-16...

vpeijunzmsft_3-16...

I have the same question (0)

All responses (2)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

@SV-01052050-0 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

Was this reply helpful? Yes No
SV-01052050-0 6 on at

Like (0)

Report

Hi there @SV-01052050-0! Thank you very much for your response. I followed the steps from your tutorial, but the steps were a little different for my flow, the flow didn't succeed. I tried creating the flow that I did a couple of years back (please see screenshot above) and I got this error (attached screenshot below). Would you please help me to diagnose this issue. Thank you very much for your time and support. I found another incredible tutorial of yours (creating a chatbot in teams). I'm gunna create a bot for my HR team. Thank you very much for sharing your knowledge.

Was this reply helpful? Yes No