How to Email Planner Task Details and Attachments using Power Automate
Question details
The user needs to configure a Power Automate flow to send an email with the task description and file attachments whenever a Microsoft Planner task is assigned or labeled.

- Product
- Microsoft Power Automate
- Device & OS
- not provided
- Scenario
- Automating email notifications for specific Microsoft Planner tasks, requiring the extraction of task descriptions and the conversion of linked Planner or SharePoint files into email attachments.
- Observed behavior
- To successfully send the email, the flow must correctly retrieve task details and convert the attachment files into email attachment content bytes before processing.
Ensure you have an active Microsoft 365 account with proper permissions for Power Automate, Microsoft Planner, and access to any associated SharePoint document libraries where attachments might be stored.
Create a Power Automate Flow for Planner Tasks
Build a cloud flow that triggers upon task assignment or creation, retrieves the task details, and loops through attachments to bundle them into an email array.
To successfully attach Planner files to an email, the flow must retrieve the file content from SharePoint or the Planner attachment list and format it into a specific JSON array containing the file name and content bytes.
Open Power Automate and create a new automated cloud flow. Search for the Planner connector and select the trigger 'When a task is assigned to me' or 'When a task is created'.
If you only want to send emails for specific task categories, add a 'Condition' control. Set it to check if the desired task label (e.g., Label Green) is equal to 'true'. Place all subsequent actions in the 'If yes' branch.
Add a 'Get task details' action. Insert the Task ID dynamic content from your trigger into the Task ID field. This allows you to pull the task description into your email body later.
Add an 'Initialize variable' action. Name it 'AttachmentsArray' and set the type to 'Array'. This will store your formatted attachment files.
Add an 'Apply to each' action to loop through the task attachments. Inside the loop, use the appropriate SharePoint 'Get file content' action. Then, add an 'Append to array variable' action using this exact JSON structure: {"Name": "[FilenameWithExtension]", "ContentBytes": "[FileContent]"}.
Add a 'Send an email (V2)' action. Use dynamic content to insert the task description into the email body. Finally, switch the Attachments field to array mode and insert your 'AttachmentsArray' variable.

Enhance Your Daily Workflow with WPS Office
While Microsoft Power Automate is excellent for complex background workflows like Planner notifications, WPS Office provides a free, lightweight, and highly productive suite for your daily document creation and editing needs. It serves as an excellent complement or alternative to Microsoft Office desktop apps.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the Suite: Run the installer and follow the quick on-screen instructions to set up the software.
- 3. Open Your Files: Launch WPS Office and seamlessly open your existing Microsoft Office files with full formatting support.

Frequently Asked Questions
Why are my Planner attachments corrupted when opening them from the Power Automate email?
This usually happens if the file content wasn't properly converted to ContentBytes. Ensure you are using the 'Get file content' action (often via SharePoint) and mapping its direct output to the 'ContentBytes' property in your 'Append to array variable' JSON payload.
How do I include the task description in the email body?
You must use the 'Get task details' action in Power Automate after your initial trigger. Once added, you can map the 'Description' dynamic content directly into the body field of your 'Send an email' action.
Can I trigger the email only when a specific color label is applied to the Planner task?
Yes. Immediately after your trigger, add a 'Condition' control. Configure it to check if the dynamic content for that specific label (for example, 'Label Green') is equal to true, and build the rest of your email flow inside the 'If yes' branch.




