Developing Custom SharePoint Solutions with Power Apps and Power Automate Training Course
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
- Build custom SharePoint solutions using Power Apps and Power Automate.
- Design and develop no-code business applications in Power Apps.
- Automate document management and approval processes with Power Automate.
- Create custom forms for SharePoint lists with Power Apps.
- Integrate Microsoft 365 apps (Teams, Outlook, Planner) into SharePoint solutions.
- Implement role-based access control and security measures for apps and workflows.
- Apply best practices for deploying and maintaining SharePoint-based business solutions.
Prerequisites
- Basic understanding of Microsoft 365 and SharePoint Online
- Familiarity with data management concepts (lists, libraries, forms)
- No prior experience with Power Apps or Power Automate required
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
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
- Duration: 1 Day
- 4.5 Ratings
Introduction to Microsoft 365 Collaboration Tools: SharePoint, OneDrive, and Teams Training Course
- Duration: 2 Days
- 4.5 Ratings
Getting Started with Microsoft Teams for Business Communication Training Course
- Duration: 2 Days
- 4.5 Ratings
File Management and Sharing with OneDrive for Business Training Course
- Duration: 3 Days
- 4.5 Ratings
Microsoft SharePoint Online for Beginners: Sites, Libraries, and Lists Training Course
- Duration: 3 Days
- 4.5 Ratings
Microsoft 365 Collaboration Best Practices for Remote Teams Training Course
- Duration: 3 Day
- 4.5 Ratings
Managing and Securing Data in SharePoint and OneDrive Training Course