Advanced Power Apps is a hands-on course in building enterprise-grade Power Apps on Dataverse, from data modelling, delegation, advanced Power Fx and component libraries to performance tuning, security roles and shipping apps to production with solutions. It suits Power Platform makers, citizen developers and IT teams who look after apps for several departments and need them to scale.
Power Apps built by a small team often work well until users grow into the hundreds and data into the tens of thousands of records. Then the app opens slowly, searches miss records because of delegation limits, the same formula is copied across many screens and becomes hard to change, users see data they should not, and every fix is made directly in production. These problems come from a design that was never prepared to scale.
This course takes people who already build canvas apps to enterprise-grade apps. Learners design a data model on Dataverse, master delegation with large data sets, and write advanced Power Fx with With, ForAll, multi-record Patch, user-defined functions and user-defined types. They build component libraries and responsive screens with modern controls, tune performance with Monitor, secure data with security roles, integrate with Power Automate, get to know model-driven apps and custom pages, and ship apps to production with solutions and pipelines. The course closes with a capstone app for a department. (2 days, 6 hours per day, 12 hours in total, Advanced level.)
Course Details
This course focuses on building enterprise-grade Power Apps on Dataverse. It runs for 2 days, 6 hours per day (12 hours in total, 09:00-16:00), as lectures with labs and workshops built on one sample request system throughout. Advanced level. It builds on Microsoft Power Apps, which teaches canvas apps from the ground up, and covers Dataverse data modelling, delegation, advanced Power Fx, user-defined functions, component libraries, responsive layout, Monitor, security roles, Power Automate, model-driven apps, custom pages, solutions, pipelines and Test Studio. Learners use their own or their organisation's account with Power Apps Premium rights, or a developer environment they sign up for; the institute does not provide accounts, licences or environments.
Section 1: Enterprise App Architecture
Section 2: Lab: Designing a Data Model on Dataverse
Section 3: Lab: Delegation and Large Data Sets
Section 4: Lab: Advanced Power Fx
Section 5: Lab: Component Libraries
Section 6: Lab: Responsive Layout and Modern Controls
Section 7: Lab: Performance and Monitor
Section 8: Lab: Data Security
Section 9: Lab: Power Automate and Offline Use
Section 10: Lab: Model-Driven Apps and Custom Pages
Section 11: Lab: ALM and Testing
Section 12: Workshop: Department App Capstone
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
This course builds on Microsoft Power Apps, which teaches canvas apps from the ground up with SharePoint and SQL Server. This course focuses on enterprise apps on Dataverse: data modelling, delegation with large data sets, advanced Power Fx, component libraries, performance tuning, security roles, model-driven apps and ALM with solutions and pipelines.
The institute does not provide accounts, licences or environments. Dataverse is a premium capability, so you need your own or your organisation's Power Apps Premium rights, or a developer environment or trial set up in advance. Check that you can create Dataverse tables before the training day.
You should already build canvas apps and be comfortable with galleries, forms, collections and basic Power Fx such as Filter, LookUp and Patch. If you have never built an app, start with Microsoft Power Apps first.
Not every app. The class explains when an app should move to Dataverse, for example when data has complex relationships, needs record-level security or grows large. The ideas on delegation, performance, components and advanced Power Fx still apply to SharePoint-based apps.
Not in depth. The course focuses on low-code apps with Power Fx and component libraries, and gives an overview of the Power Apps component framework so you know when to use it and what extra skills it needs.
Yes. Every app lives in a solution that you can export and import into your organisation's environment, but it should be reviewed by your Power Platform admins for permissions and data policies before going live, and you should avoid confidential real data during class.
Many organisations still run work on paper, on Excel files passed through several hands, or on forms whose data has to be retyped into another system. Writing a new program in a programming language takes time and depends on a development team. Microsoft…
A lot of office work is still repeated by hand every day: copying data from emails into Excel, sending forms to a manager for approval, chasing documents that have not arrived or letting the team know in Teams when a new item comes in. Organisations that use…
Many organisations already use Microsoft 365 Copilot for everyday work. The next step is building their own AI agents that know the organisation's data, answer questions from internal policies and documents, and take action on people's behalf, such as opening…
