@CU23011057-0 The logic of your flow needs to be adjusted. Currently you are:
- Listing Buckets
- Looping Through Buckets
- Checking if a bucket is equal to a value
- Listing Tasks
- Looping through each task
- ....
It's always best practice to have the List [anything] actions OUTSIDE of the Apply to Each loops. This will make your flow more efficient as you need to only get the items once and then take additional actions.
If you are looking to get tasks from a specific bucket you need to do the following:
List Buckets in the root of your flow.
Add a Compose action to output the bucket ID. The Filter Array action will return an array of items. To output a single item (and avoid the apply to each action) you'll need to use an expression.
For detailed instructions, follow
this section of the first YT Tutorial linked at the bottom.
List Tasks in the root of your flow. Use the Filter Array action to filter out the tasks in a specific bucket.
I would recommend adding a Compose action after a Filter Array action to output the count of items. This can help with troubleshooting and ensure that your flow doesn't error out if there aren't any items found. I cover how to do that in
this section of the second YT Tutorial linked below.
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
---
To learn more about the Filter Array action, check out these YT Tutorials:
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
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
2
Share
Report
All responses (
Answers (
