How to connect Planner to Power Apps integration guide

by

How can I leverage Microsoft Planner PowerApps integration for my team?

I manage a project team that uses Microsoft Planner for task management, but our field employees need mobile access to create and update tasks while on customer sites. They’ve complained that the standard Planner mobile experience lacks customization for our workflow. Is there a way to create a custom mobile interface that connects directly with our Planner boards while maintaining all the task management capabilities we need?

Integrating Planner with PowerApps

Organizations that maintain separate systems for task management and mobile operations often face productivity bottlenecks. Field teams delay updates until they return to their desks, creating information gaps. By connecting Microsoft Planner to PowerApps, companies break down these barriers, enabling real-time task creation and updates from anywhere. This integration particularly benefits teams with mobile workforces, streamlining operations and ensuring that project visibility remains consistent across the organization.

Microsoft Planner PowerApps integration

This tutorial will demonstrate how to build a custom Power Apps interface that connects with Microsoft Planner, allowing users to view, create, and update tasks directly from a mobile-friendly application. We’ll use Power Automate as the connection layer between Power Apps and Planner. The solution requires:

Building your MS Planner Power App connection

Setting up the foundational connections

  • Begin by launching Power Apps Studio from the Power Apps portal (make.powerapps.com) and create a new canvas app using the phone layout for optimal mobile usability, ensuring your field teams can easily navigate the interface regardless of their device type.
  • Navigate to the “Data” panel and select “Add data source,” then search for “Microsoft Planner” in the connectors list to establish the primary connection between your app and your organization’s Planner environment.
  • When prompted, authenticate using your Microsoft 365 credentials and grant the necessary permissions for the app to interact with Planner data, which enables secure access to all relevant plan and task information.
  • After establishing the connection, add a second connection to Power Automate by returning to the data sources menu and selecting “Power Automate” to enable the creation of flows directly from your Power App.

Creating the PowerApps interface for Planner tasks

  • Add a gallery control to your app’s main screen by selecting “Insert > Gallery” and choosing a layout that displays task information clearly, including title, due date, assigned users, and completion status for optimal task visibility.
  • Configure the gallery’s Items property with the formula: Planner.ListPlans().value to display all available plans, allowing users to navigate between different project boards within your organization.
  • Create a detail screen with input controls for task creation by adding a new screen and inserting text inputs for task title, description, start date, and due date, along with dropdowns for priority and assignee selection.
  • Add a button labeled “Create Task” and set its OnSelect property to trigger a Power Automate flow that will handle the actual task creation in Planner, separating the user interface from the backend processing.

Building the Planner update task details flow

  • Open Power Automate from the Power Platform menu and create a new instant flow that will be triggered from your Power App, naming it something descriptive like “Create Planner Task from PowerApp.”
  • Add an action step by selecting “Microsoft Planner > Create a task” and configure the required parameters including Plan ID (which you’ll pass from your Power App), Task Title, and Bucket ID for proper task categorization.
  • Include additional fields like Start Date, Due Date, Percent Complete, and Assigned To by expanding the “Show advanced options” section, ensuring all relevant task details are captured properly.
  • Create a second flow for updating existing tasks using the “Microsoft Planner > Update task details” action, which requires task ID and plan ID as inputs along with the fields you want to modify.
  • Configure your Power App to pass the necessary parameters to your flows by using the formula: PowerAptoBIFlow.Run(PlanId, TaskTitle, Description, DueDate, Assignee) on your button’s OnSelect property.

Implementing task visualization and reporting

  • Enhance your app with task visualization by adding chart controls from the Insert menu and connecting them to aggregated Planner data, providing users with visual representations of task status and distribution.
  • For advanced analytics, incorporate the Microsoft Planner Power BI connector by adding a Power BI tile to your app, displaying pre-built dashboards that offer deeper insights into task completion trends and team performance.
  • Create a task detail view by designing a new screen that displays all information about a selected task, including checklists, attachments, and comments for comprehensive task management.
  • Add refresh capabilities to ensure data remains current by incorporating a refresh button with the OnSelect property set to: Refresh(YourPlannerDataSource) so users always see the most up-to-date information.

Troubleshooting common Planner PowerApps integration issues

  • When receiving the error “Unable to create connection,” verify that your Microsoft 365 account has sufficient permissions to access both Planner and Power Apps services, then try signing out completely from Microsoft 365 and signing back in before attempting to create the connection again.
  • If your Power Automate flow fails with the message “Invalid Plan ID or access denied,” ensure you’re correctly passing the Plan ID from your Power App and verify that the user triggering the flow has contributor access to the specified Planner plan in your Microsoft 365 environment.
  • When task updates aren’t appearing in Planner after submission from your Power App, check the run history of your flow for any execution errors, and verify that all required fields are being properly passed from your app to the flow, paying special attention to data format requirements for dates and IDs.
  • Users reporting that the app loads slowly or times out when retrieving Planner data should consider implementing pagination or filtering in your data retrieval formulas to limit the amount of data being processed at once, especially for organizations with extensive Planner usage.
  • If task assignments aren’t working correctly, confirm you’re using the correct format for user identifiers (typically email addresses) and that the specified users have appropriate permissions in your Microsoft 365 environment to receive task assignments.

Note: When implementing task visualization and reporting features, you’ll want to enhance your app with chart controls from the Insert menu and connect them to aggregated Planner data. For advanced analytics, you can incorporate Power BI dashboards that offer deeper insights into task completion trends and team performance. This provides users with comprehensive visual representations of task status and distribution.