Copilot prompt to turn Outlook emails into Planner tasks
A prompt for an Outlook to Planner flow in Power Automate: which emails qualify, the Planner plan and bucket, task title and due date rules, the description and checklist, and how to avoid duplicates.
Tuned for Copilot · structured role / context / task / output
Open in the builder →Ready-to-use prompt
# Role You are an experienced workflow-automation architect who designs reliable, maintainable automations on the platform in use: a precise trigger, exact connector and action names, explicit conditions, error handling, and a test plan. # Context Design a Power Automate flow that turns flagged emails from clients into Planner tasks in the Client Work plan with a due date three days out. # Task Design the automation described in the context above for the stated platform: the trigger, each action in order with exact connector or action names, the conditions and approvals, error handling and retries, and how to test it before it goes live. # How to approach this Think through the problem step by step before answering. Work the hard parts out explicitly, then give a clear final answer. Let the difficulty of the task set how much reasoning is needed — don't pad the easy steps. - Lay the automation out in order: trigger, each action, the conditions and branches, error handling, then a test plan. Before you finalize, verify that the trigger fires on exactly the intended event and nothing else; every action names the real connector, action, or command for the stated platform; the first failure has a handling path: retry, notify, or stop; the test plan covers the main path and that first failure. # Constraints - Do not invent connector, action, or command names. If unsure one exists, say so and use the closest real alternative. - Use clean, professional formatting that pastes cleanly into Word, Outlook, and Excel. Prefer tables and numbered steps for anything structured. - Deliver one finished, office-ready result rather than a set of options. - Keep the tone professional and workplace-appropriate unless the prompt says otherwise. - For spreadsheet or document tasks, give the exact formula, steps, or text — never a vague description of what to do. - Deliver the result directly — no apologies or meta-commentary about the prompt itself. # Output format Return only the requested output. If multiple distinct variants would clearly help, label them (e.g., "Option A", "Option B"). # Done when - the output fully answers the goal in the Context section with no missing parts
Customize this prompt
Answer a few quick questions and Promptivo re-tunes the prompt above to your exact situation.
Start the interview →Why this prompt works
Most email-to-task flows create noise. The prompt asks for the qualifying rule (sender, subject, flag, folder) before anything is created.
Create a task in Planner needs a Group ID, Plan ID and bucket, and details such as the description live in a separate Update task details action. The prompt asks for these so the design is buildable.
Duplicates are the second failure. The prompt asks how a repeat email is detected, for example by conversation ID or a tracking list.
Using this prompt in Copilot
For outlook to planner flow, Copilot is a strong choice — it's especially good at Office-ready output you can finish in Word, Outlook, and Excel. Promptivo formats this prompt the way Copilot works best: office-ready output that pastes cleanly into Word, Outlook, and Excel, with tables and numbered steps.
Paste it into Microsoft Copilot or the Microsoft 365 side-panel, then replace any bracketed details with your own. Copilot generalizes when it is under-fed, so keep the bracketed context specific and it will stay grounded in your details.
Tuned for Copilot: how it differs
| Model | What Promptivo changes |
|---|---|
| ChatGPT | Concise instructions, strict format adherence, no preamble. |
| Claude | Explicit step-by-step thinking and clearly delimited output sections. |
| Gemini | Precise phrasing with brief reasoning cues where they improve accuracy. |
| Copilot | Office-ready output that pastes cleanly into Word, Outlook, and Excel, with tables and numbered steps. |
Questions, answered
- How do I create a Planner task from an email?
- Trigger on When a new email arrives (V3) with a filter, add Create a task (Planner) with the plan and bucket, then Update task details for the description and checklist. The prompt collects the rules for title, due date and assignment.
- Can the flow attach the email to the task?
- Planner tasks hold references (links), not file attachments. Include a link to the email or save the attachment to SharePoint and reference it.
- How do I set a due date from the email?
- Use an expression such as addDays(utcNow(), 3) or parse a date from the subject. The prompt asks for the rule so the expression is designed, not guessed.
- Is Copilot good for outlook to planner flow?
- Yes. Copilot handles outlook to planner flow well thanks to its Office-ready output you can finish in Word, Outlook, and Excel, and Promptivo tunes the prompt to match — office-ready output that pastes cleanly into Word, Outlook, and Excel, with tables and numbered steps. Paste it into Microsoft Copilot or the Microsoft 365 side-panel.