Programme overview
Introduction:
Power Apps training covering canvas apps, Dataverse and Power Fx for citizen developers is a 5-day course for business analysis, departmental app building and IT support teams that ends with a working Request and Approval App. Organisations lose control when departments track requests in email chains and spreadsheets, or when unmanaged apps connect sensitive data to personal services without environment or connector rules. Nominees already maintain lists, spreadsheets or simple forms at work and learn hands on in software labs, building each screen and formula live. CoreConcept Training Center delivers this Power Apps training course.
Course Objectives:
- Assess departmental requirements and choose between canvas and model-driven apps within a governed Power Platform environment
- Build canvas apps with screens, galleries, forms and Power Fx formulas connected to SharePoint lists, Dataverse tables and Excel
- Configure Dataverse tables, relationships and security roles and assemble a basic model-driven app
- Connect apps to standard connectors and Power Automate cloud flows and prepare them for mobile and offline use
- Apply data loss prevention policies, sharing rules and solution-based deployment across environments
- Test, document and hand over a working Request and Approval App for a case department
Target Audience:
- Business analysis teams responsible for turning departmental requests into app requirements and data designs
- Citizen developer teams responsible for building and maintaining low-code apps for their own departments
- IT support and service desk teams responsible for supporting, sharing and troubleshooting business apps
- Departmental operations teams responsible for request registers, approvals and tracking lists
- Digital workplace teams responsible for app environments, connector rules and maker enablement
Course Outline:
Day 1: Low-Code Foundations, Power Platform Landscape and App Planning
- Power Platform Components and the Role of Power Apps
- Canvas Apps Versus Model-Driven Apps Selection Criteria
- Power Apps Maker Portal, Environments and Licensing Overview
- Citizen Developer Governance Roles and Centre of Excellence Model
- Departmental App Candidate Assessment and Requirements Capture Sheet
Day 2: Canvas App Architecture, Data Sources and Dataverse Tables
- Power Apps Studio Screens, Controls and Tree View Navigation
- SharePoint List Design as a Canvas App Data Source
- Microsoft Dataverse Tables, Columns, Choices and Relationships
- Excel Tables and Connector Delegation Limits for Large Data
- Power Apps Mobile Offline Caching with SaveData and LoadData
Day 3: Building Canvas Apps with Galleries, Forms and Power Fx
- Gallery Controls with Filter, Search and SortByColumns Functions
- Edit and Display Forms with SubmitForm and Validation
- Power Fx Variables, Collections and the Patch Function
- Navigate Function, Screen Transitions and Responsive Container Layouts
- Office 365 Users and Outlook Connectors in Canvas Apps
Day 4: Model-Driven Apps, Flow Integration, Security and App Lifecycle
- Model-Driven App Designer with Dataverse Views, Forms and Sitemap
- Power Automate Cloud Flow Triggered from a Power Apps Button
- Dataverse Security Roles, Business Units and App Sharing
- Data Loss Prevention Policies with Business and Non-Business Connectors
- Solutions, Environment Variables and Managed Deployment to Production
Day 5: Software Lab: Case Department Request and Approval App
- Case Department Brief and Dataverse Request Table Build
- Canvas Request Screens with Gallery, Form and Patch Logic
- Approval Flow Connection and Status Update Notifications
- Power Apps Test Studio Cases and App Checker Review
- Request and Approval App Sharing, Solution Export and Demonstration
Skills You Will Gain:
- Low-Code Solution Scoping
- Canvas App Design
- Power Fx Formula Writing
- Dataverse Data Modelling
- Connector and Flow Integration
- App Security and Sharing
- Environment and DLP Governance
- App Testing and Deployment
Why Attend This Course:
- Deliver a working Request and Approval App, with data tables, screens, approval flow and test record, to the department head and the platform owner
- Decide whether a departmental need belongs in a canvas app, a model-driven app or an existing system before any build starts
- Avoid shadow apps, broken data delegation and exposed data through connector rules, security roles and managed solutions
- Share app templates, Power Fx patterns and testing routines with colleagues who build or support departmental apps
Conclusion:
Back at work, the participant hands the department head and the platform owner a working Request and Approval App with its Dataverse tables, canvas screens, approval flow, security roles and test cases. The department uses it to replace email and spreadsheet requests, while the platform owner uses it to agree the environment, connector and sharing rules that future citizen-built apps will follow. After the first month in production, the unit should review request volumes, failed flow runs, delegation warnings and user feedback, then decide which further departmental processes move onto the platform.
Frequently Asked Questions (FAQ):
What should participants know before Power Apps training?
Participants should already work with spreadsheets, lists or simple forms and understand how their department handles requests. No programming experience is expected. Bringing a short description of one departmental request process helps them apply the labs to a familiar case.
How does Power Apps training differ from a business process automation or RPA course?
Power Apps training focuses on building the apps people use to enter, view and approve data. Process automation and RPA courses concentrate on modelling and redesigning workflows and building bots, with app screens touched only briefly.
Why do data loss prevention policies matter in Power Apps training?
Data loss prevention policies decide which connectors an app may combine. Grouping connectors as business, non-business or blocked stops an app from moving organisational data into personal services, so makers learn to design within the policies their environment enforces.
What do participants take back from Power Apps training?
Participants take back a working Request and Approval App with Dataverse tables, canvas screens, Power Fx logic, an approval flow, security roles and test cases, packaged in a solution ready to adapt for a real departmental process.