Developing Custom SharePoint Solutions with Power Apps and Power Automate Training Course

Share this course

Duration

5 Days

Course Overview

This course is designed for professionals who want to develop custom no-code/low-code business solutions using SharePoint, Power Apps, and Power Automate within Microsoft 365. Participants will learn how to build interactive apps, automate workflows, and enhance collaboration by integrating these tools. Hands-on exercises will guide participants through creating real-world business solutions, custom forms, automated approval processes, and interactive dashboards in SharePoint.

Format of Training

  • Instructor-led interactive sessions
  • Hands-on lab exercises
  • Practical demonstrations
  • Real-world case studies

Course Objectives

  1. Build custom SharePoint solutions using Power Apps and Power Automate.
  2. Design and develop no-code business applications in Power Apps.
  3. Automate document management and approval processes with Power Automate.
  4. Create custom forms for SharePoint lists with Power Apps.
  5. Integrate Microsoft 365 apps (Teams, Outlook, Planner) into SharePoint solutions.
  6. Implement role-based access control and security measures for apps and workflows.
  7. Apply best practices for deploying and maintaining SharePoint-based business solutions.

Prerequisites

Course Outline

Day 1: Introduction to No-Code Development in Microsoft 365

Session 1: Understanding SharePoint, Power Apps, and Power Automate

  • Overview of Power Platform in Microsoft 365
  • Role of SharePoint, Power Apps, and Power Automate in business automation
  • Understanding Dataverse and SharePoint lists as data sources

Session 2: Creating SharePoint Lists and Libraries for Business Solutions

  • Setting up SharePoint lists and libraries for structured data storage
  • Managing permissions and access control
  • Using metadata, views, and filters for better data organization

Session 3: Introduction to Power Apps for SharePoint

  • Understanding Power Apps types (Canvas vs. Model-driven)
  • Creating a basic Power App from a SharePoint list
  • Customizing form layouts, fields, and user inputs

 

Day 2: Building Interactive Power Apps for SharePoint

Session 1: Customizing Power Apps for Business Workflows

  • Designing responsive forms and dashboards
  • Implementing conditional formatting and data validation
  • Using Power Apps controls (galleries, buttons, date pickers, etc.)

Session 2: Managing Data Sources and Integrations in Power Apps

  • Connecting Power Apps to SharePoint, OneDrive, and external sources
  • Using Power Automate to trigger actions from Power Apps
  • Storing and retrieving data with Dataverse and SharePoint lists

Session 3: Role-Based Access Control in Power Apps

  • Implementing user roles and permissions in Power Apps
  • Using Power Automate to enforce approval workflows
  • Ensuring data security and governance for apps

 

Day 3: Automating Workflows with Power Automate

Session 1: Automating Business Processes in SharePoint

  • Overview of Power Automate flow types (instant, automated, scheduled)
  • Creating workflow triggers from SharePoint actions
  • Managing document approvals and notifications

Session 2: Advanced Power Automate Features

  • Implementing conditional logic and parallel branches
  • Working with adaptive cards in Teams for approvals
  • Managing looping, error handling, and exceptions in workflows

Session 3: Integrating Power Automate with Microsoft 365 Apps

  • Automating processes with Outlook, Planner, and Teams
  • Using AI Builder for document processing and approvals
  • Creating Power Automate templates for reusability

 

Day 4: Advanced Power Apps and Power Automate Solutions

Session 1: Designing Advanced Power Apps for SharePoint

  • Implementing lookup fields and cascading dropdowns
  • Using collections and global variables for dynamic data handling
  • Creating offline-enabled apps with local storage

Session 2: Power Automate and AI-Powered Workflows

  • Using AI Builder to automate form and document processing
  • Extracting data from scanned documents and images
  • Automating data classification and compliance actions

Session 3: Monitoring, Troubleshooting, and Debugging Power Automate Flows

  • Debugging failed flows and troubleshooting common issues
  • Using Power Automate analytics for monitoring
  • Optimizing flow performance and reducing execution time

 

Day 5: Deployment, Governance, and Best Practices

Session 1: Deploying Power Apps and Workflows in SharePoint

  • Managing app publishing and sharing settings
  • Ensuring scalability and security in deployed solutions
  • Implementing Power Apps in SharePoint web parts

Session 2: Governance and Compliance in Power Platform Solutions

  • Managing Power Automate permissions and data loss prevention (DLP) policies
  • Implementing audit logs and compliance monitoring
  • Securing Power Apps and workflow data

Session 3: Best Practices for Developing SharePoint Business Solutions

  • Creating scalable and maintainable Power Apps
  • Optimizing workflow performance and reducing manual intervention
  • Planning for long-term Power Platform adoption and governance
Team reviewing charts and documents together around a meeting table

Bespoke Option

We are open to customizing this program to align with your specific learning objectives. If your team has particular goals or areas they wish to focus on, we would be happy to tailor the course outline to meet those needs and ensure the program supports the achievement of your desired outcomes.

Need help with the right course to choose?

support@skillvotech.com

Explore more opportunities

Introduction to Microsoft 365 Collaboration Tools: SharePoint, OneDrive, and Teams Training Course

Getting Started with Microsoft Teams for Business Communication Training Course

File Management and Sharing with OneDrive for Business Training Course

Microsoft SharePoint Online for Beginners: Sites, Libraries, and Lists Training Course

Microsoft 365 Collaboration Best Practices for Remote Teams Training Course

Managing and Securing Data in SharePoint and OneDrive Training Course

Developing Custom SharePoint Solutions with Power Apps and Power Automate Training Course