MENU

Fun & Interesting

How To Create a Planner Task from a Microsoft Form Submission

A Creative Opinion 6,549 8 months ago
Video Not Working? Fix It Now

Build a Power Automate flow that creates tasks in Planner each time a MS form is submitted. 👉 7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️: https://www.youtube.com/watch?v=QeBL32w2ClM&list=PLphkuAZNVjJAqhAcydKZtFENEmidag-53&index=15 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. #microsoft365 #powerautomate #powerplatform #productivityhacks #productivitytips #techtips #techtipsandtricks #microsoftpowerautomate #sharepoint #sharepointonline #microsoftforms ---- 💗 SUPPORT ME: If you found this video helpful, please consider giving this video a like and leave a comment. You can also show additional gratitude by giving me a 💖 Super Thanks or ☕️ Buying me a Coffee: https://www.buymeacoffee.com/acreativeopinion --- MENTIONED IN THE VIDEO: ▶️ ⚡️Automate Microsoft Planner Tasks: Create Tasks from SharePoint & Excel in Minutes: https://www.youtube.com/watch?v=LhtlVcVvYlE&list=PLphkuAZNVjJBnMnBsJ-jyn2g7iFDLBab7&index=3 ▶️ How to Get a MS Form ID: https://www.youtube.com/watch?v=ijoqOaOkaZs&list=PLphkuAZNVjJCLGy1a1_vp93pc13ETQHAV&index=3&t=156 ▶️ Find the internal column name: https://www.youtube.com/watch?v=ZmBaKBjghoc&list=PLphkuAZNVjJCpyWAXs2DJWKo-K7i9tJFL&index=13 ▶️ How to Use Multiple Conditions in a Filter Array Action: https://www.youtube.com/watch?v=HVAf1aTEQNg&list=PLphkuAZNVjJCpyWAXs2DJWKo-K7i9tJFL&index=3&t=1207s --- LEVEL UP YOUR POWER AUTOMATE SKILLS: ▶️ How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks: https://www.youtube.com/watch?v=ODobGcpgGlk&list=PLphkuAZNVjJAqhAcydKZtFENEmidag-53&index=14 ▶️ Are you using the Microsoft Power Automate Filter Array Action wrong?: https://www.youtube.com/watch?v=HVAf1aTEQNg&list=PLphkuAZNVjJCpyWAXs2DJWKo-K7i9tJFL&index=3 ▶️ 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow: https://www.youtube.com/watch?v=44Bk4JVMrD4&list=PLphkuAZNVjJCpyWAXs2DJWKo-K7i9tJFL&index=12 --- 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 --- SKIP AHEAD: 00:00 | Intro 00:48 | Group Form vs OneDrive Form 01:10 | Build the Flow 01:43 | Create a Task 02:29 | Add a Task Description 03:18 | Create a Task in a Bucket 04:42 | Return a Count of Items 05:23 | FAQ: Why Isn't My Filter Array Action Returning Any Items 07:16 | Add a Condition Check 07:52 | Create a Bucket 08:13 | Get a Bucket ID 10:11 | Create a Task in a Bucket 12:02 | Assign Users to a Task 12:48 | FAQ: How Can I Add Multiple Users Based on a Form Selection? 14:29 | Get a String of Email Addresses 16:42 | Get Email Addresses from an Excel Table 18:09 | Tips and Tricks: Group Your Actions 18:56 | Add Attachments to a Task 19:34 | Get File Upload Output 20:53 | Create Attachment Array 23:28 | FAQ: What if the User Doesn’t Add Any Attachments? 25:53 | Replace the Flow Trigger --- SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH 👉 https://bit.ly/SubACreativeOpinion 👈 --- FOLLOW ME: https://www.instagram.com/acreativeopinion https://www.tiktok.com/@acreativeopinion https://twitter.com/acreativeop

Comment