Answered

Flow: Complete a specific planner task when a microsoft form is submitted

(0) Share

Report

Posted on by CU29101523-0

Hello,

I was wondering if there was a way to complete a MS planner task when a MS form response is submitted. Ideally, I am searching for something along the following lines:

1. Individual X is assigned a planner task with a link to a MS form

2. Individual X completes the MS Form and submits their response.

3. Submission of response triggers Individual X's planner task to be completed.

I have tried implementing the solution provided in the link: https://community.powerplatform.com/forums/thread/details/?threadid=31147dd2-9235-415d-9bc4-96d1d803a9c8, however I've not been successful.

Any help with this matter would be greatly appreciated.

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (4)

NsL Coder 475 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

You are going to need to provide more information on what "not been successful" means. What have you done so far and what error you encountered.

Was this reply helpful? Yes No
CU29101523-0 38 on at

Like (0)

Report
Copy link

Link copied!

Hello @NsL Coder,

I've tried to implement the solution posted in this link: https://community.powerplatform.com/forums/thread/details/?threadid=31147dd2-9235-415d-9bc4-96d1d803a9c8. The step that shows the error is "Update task". The error states "Bad Request".

Please let me know if you need further information.

Thanks for your help

Was this reply helpful? Yes No
NsL Coder 475 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Need more info on screenshot for this "Update a task" action in edit mode and in run history to see what "task id" is passed in.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@CU29101523-0 It's hard to offer any recommendations without seeing your full flow and the logic behind it. If you are using the new designer, toggle it off and click each action to expand it. A screenshot of your flow in this view would really help.

You also haven’t mentioned what information is being captured from the MS Form. To mark a Planner task as complete, you need the Task ID. How are you pulling this information into your flow?

The more details and context you can provide—especially if you can include a screenshot of your flow in edit mode—the easier it’ll be to suggest an approach that works for your scenario. Without that info, we’re likely to end up going back and forth or making assumptions that might not match what you’re trying to achieve.

In the meantime, you might be interested in these YT Tutorials:

How To Create a Planner Task from a Microsoft Form Submission

Are you looking for a way to automate creating Microsoft Planner tasks from Microsoft Form Submissions? In this Power Automate tutorial, I’ll show you how to build this flow that creates tasks in Planner each time a form is submitted.

First, I’ll show you how to create a task using the Microsoft Form submission data. Then, I’ll show you how to place a task in a specific bucket based on a selection made in the form as well as how to assign tasks to specific users. At the end of the video I’ll show you how to handle Microsoft Form uploads and how you can attach those to your Planner Tasks.

If you’re looking for a way to quickly create tasks from a SharePoint list or an Excel table—I already have a tutorial on how to do that. Click here to check it out.

IN THIS VIDEO:
✓ How to automate creating Planner tasks from Microsoft Forms submissions
✓ How to differentiate between Group Forms and Personal Forms in Microsoft Forms
✓ How to build a flow to create tasks using Microsoft Forms data
✓ How to dynamically select a bucket in the Create a Task action
✓ How to add a task description to a Planner task
✓ How to use the List Buckets action in Power Automate
✓ How to use the Filter Array action to match form responses
✓ How to troubleshoot Filter Array action issues
✓ How to use the Condition action to handle bucket creation
✓ How to create a new bucket in Microsoft Planner automatically
✓ How to use variables to set the Bucket ID dynamically
✓ How to assign users to Planner tasks based on form responses
✓ How to add multiple users to a task using SharePoint or Excel data
✓ How to group actions using the Scope action in Power Automate
✓ How to add file attachments to Planner tasks from Microsoft Forms
✓ How to parse JSON output for file uploads in Power Automate
✓ How to handle empty file uploads in Power Automate
✓ How to replace the manual flow trigger with a form submission trigger

----

How to Email Attachments 🖇 to Your Planner Tasks

When you add attachments to a Planner task from your computer, the files are automatically saved in the Documents document library of the SharePoint site associated with the M365 Group of your plan.

Instead of downloading email attachments to OneDrive or SharePoint just so you can add them to a Planner Task—automate it. In this Microsoft Power Automate Tutorial—I’m going to show you how build a flow that will take your email attachments and add them to a Planner task. All you need to do is copy a link to a task, forward the email to yourself and the attachments will be saved onto SharePoint and attached to your planner task.
At the end of the video I’ll show you how to use Trigger Conditions so this automation only runs when specific conditions are met!

IN THIS VIDEO:
✓ How to get the Message ID from an Email
✓ How to use the Get an Email (V2) action with a Manual Trigger
✓ How to use the split() function to split an email subject line
✓ How to use the Scope action to group your actions
✓ How to create a folder for email attachments on SharePoint
✓ How to use the Get Attachment (V2) action
✓ How to create attachment files in SharePoint
✓ How to use the Append to Array variable action to collect attachments
✓ How to add multiple attachments to a Planner Task
✓ How to switch a manual trigger to an automated trigger
✓ How to use Trigger Conditions in a when a New Email Arrives Trigger
✓ How to trigger your flow when only specific emails arrive

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
CU29101523-0 38 on at

Like (0)

Report
Copy link

Link copied!

Hello @NsL Coder & @creativeopinion,

Apologies for not providing enough information.

Here is the flow that I have created:

The error I continue to receive it that the last step gets skipped, because its not picking up on my condition (see below), even though I know for a fact that the task has the blue label attached to it:

Another issue I don't know how to resolve is to ensure that only the individual who submitted their form has their task completed and NOT each task that has the blue label.

Thank you so much, in advance, for all your help. I hope I've provided enough information this time.

Was this reply helpful? Yes No
Verified answer

NsL Coder 475 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
There are a few issues with your flow:

Condition

you have "value blue" (which indicates if a task is categorized under the "blue" label, which is a boolean dynamic content, to "condition" on boolean, you cannot "type" in the "True" on the "right side" of the "is equals to". You have to go to expression, and type in "true" there.

you also mentioned you want to only update task for those that submitted the form. The issue here is, you do know who submitted the form, in terms of email address only. However, the "List tasks" action show "assigned" by their office 365 user "ID", so in order for you to "match" them, you will need to use the Get user profile (V2) action in the Office 365 Users connector before your Condition action.

Not critical, but improves performance

instead of adding condition, use Filter Array instead

Update a task (V2)

for this action, your screenshot show that "Task Id" is "Curent item" that would be a mistake

it should the the task id

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@CU29101523-0

First, I would recommend using a manual trigger while you build and create your flow. This way you don't need to leave Power Automate to trigger your flow. Once your flow is ready to go—create a copy of your flow and replace the Manual Trigger with an Automated Trigger. I always keep a manually triggered copy of my flows to help with troubleshooting at a later date or to test out any modifications I'd like to make to my flow.

Response IDs are assigned sequentially. Depending on how many times you've filled out your form, you can enter any number in the Response Id field.

Also, it's inefficient to loop through all of your tasks and run a condition check inside the Apply to Each action.

Instead, use a Filter Array action. This way you filter out the items that you want to loop through first. @NsL Coder An expression isn't required for true. The reason the Condition was returning false for OP was because he used 'True' with a capital T.

I prefer to use a Compose action to output the number of items returned from the Filter Array action as it can help with troubleshooting your flow. Use the length() function.

I cover how to do that in this section of the first tutorial linked at the bottom.

Run a test to ensure the number of tasks is what you are expecting.

You can then add a Condition check action to check and see if the number of tasks returned is not equal to 0.

If tasks with the blue label are found, you can add your subsequent actions to the Yes branch. If there aren't any tasks found you can add any actions (perhaps a notification) into the no branch.

Based on your previous post you said:

Only the individual who submitted their form has their task completed and NOT each task that has the blue label.

Is it assumed that there will only ever be a single task assigned to each user? The reason I'm asking is that ideally, it would be best if the user could input their task ID into the MS Form.

This way you could streamline your flow even further as you could insert the Task ID directly into the Update a Task action.

However, if you want to list tasks based on the user, you might run into an issue where there is more than one task assigned to a user. How do you plan to manage that?

In the meantime, to familiarize yourself with the Filter Array and Apply to Each actions, you may be interested in these YT Tutorials below.

Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.
1️⃣ Cross-Referencing Data
2️⃣ Filtering by Key
3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:
✓ 3 Ways to Use the Filter Array Action
✓ How to use the Scope Action to Group Actions
✓ How to Check the Number of Items returned from a Filter Array Action
✓ How to Cross-Reference Data in Excel with a SharePoint List
✓ How the Filter Array Action Works
✓ How to Access the Dynamic Content from a Filter Array Action
✓ How to Filter Items by a Key
✓ How to Filter Items by Matching a Substring
✓ How to Use Multiple Conditions in a Filter Array Action

---

Filter Array + Apply to Each: The Best Tip You Need to Know

In this tutorial—I’m going to show you a quicker way to get the dynamic content from your Filter Array action—and it doesn’t require writing an expression.

IN THIS VIDEO:
✓ How to Loop Through Filter Array Results in Power Automate
✓ Using Apply to Each with Filtered Arrays
✓ The Easiest Way to Access Dynamic Content from Filter Array
✓ Fixing Nested Apply to Each Actions
✓ When to Use Value vs. Body Dynamic Content
✓ Simplifying Power Automate Flows with Filter Array
✓ Troubleshooting Filter Array and Apply to Each Issues

---

3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:
1️⃣ Looping through a Single Item
2️⃣ Creating Unnecessary Nested Loops
3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

IN THIS VIDEO:
✓ How to avoid the Apply to Each action with a single item array
✓ How to use the item() function to access dynamic content in an array
✓ How to prevent unnecessary nested Apply to Each action loops
✓ How to use the Select action
✓ How to convert an array to a string with the Select action
✓ How to use the Filter Query field
✓ How to count the number of items in an array
✓ How to use a condition control
✓ How to use the concurrency control
✓ How to set a top count
✓ How to use Compose actions for troubleshooting

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
CU29101523-0 38 on at

Like (0)

Report
Copy link

Link copied!

@NsL Coder

WOW! Thank you so much for your reply and all your help. I tried implementing the steps you provided, however, I'm running into a slight problem: When the first person completes and submits their form, it automatically completes everyone's tasks instead of just the task of the individual who completed and submitted the form.

I know I'm implementing something wrong when it comes to matching the responder's email with the profile ID of the individual, however I'm kinda stuck as to where the error is.

Here is my flow below:

Any help and insight on this would be very much appreciated.

Thank you so much!!!!

Was this reply helpful? Yes No
Verified answer

NsL Coder 475 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

The assignment's JSON structure:

What you need to filter on for user is inside the _assignments property, which is an Array (list). Make sense as you CAN assign the task to more than one person.

You need to determine a few things: for what you are doing, can a task be assigned to more than one person, if not, then you can use "first()" expression to look at only the first (one and only) assigned person's userId property.

if your task can be assigned to more than one, then you need to determine your business process of if you are going to "mark complete" when it's more than one.

Was this reply helpful? Yes No
CU29101523-0 38 on at

Like (0)

Report
Copy link

Link copied!

@NsL Coder thank you so much for the quick response.

I tried to implement what you had mentioned below, however the flow is still not working appropriately. I know I'm definitely misunderstanding something or have plugged in the wrong variables somewhere in the flow.

I know that there is only person assigned to each task, so I tried using the first() expression to match the userID from the task filtered in the previous filter array to the ID variable from "Get user profile V2" as shown below:

For the first expression above, here is the code: first(outputs('Get_user_profile_(V2)')?['body/id']))

Apologies for the all the back and forth, I feel like I'm close to getting it to work and I really appreciate all your help.

Thanks

Was this reply helpful? Yes No