Course Outline
Introduction to Microsoft Power Apps for Government
- An overview of the Office 365 platform components and capabilities, and their integration with Power Apps.
- The principle of simplicity in application development.
- A definition of Power Apps and an exploration of its benefits for government operations.
- Scenarios where Power Apps can be effectively utilized within public sector organizations.
- An introduction to canvas and data model-based applications.
- A review of ready-made application templates available in Power Apps.
Building Applications with Microsoft Power Apps for Government
- Setting up the development environment and configuring user permissions.
- Establishing a structured working methodology for project management.
- An introduction to interface creation, including best practices and design considerations.
- A discussion on the data layer and its role in application functionality.
- Fundamentals of communication and information exchange within the application.
Power Apps for SharePoint 365 for Government
- Steps to create a SharePoint form using Power Apps.
- Utilizing Power Apps forms as interfaces for SharePoint lists.
- An overview of the Power Apps interface and its components.
- Basic controls such as text fields and buttons.
- Input controls for capturing user data.
- A guide to creating an application by importing an Excel sheet into SharePoint.
Working with Power Apps for Government
- Creating a blank application from scratch.
- Customizing screen colors, backgrounds, and fonts.
- Incorporating buttons and icons for enhanced user interaction.
- An exploration of various control types, including galleries and forms, media elements, and more.
- Techniques for customizing controls to meet specific needs.
- Using text controls for data entry and display.
- Selecting from a variety of control options such as drop-down menus, combo boxes, date selectors, and option buttons.
- Designing forms as interfaces for adding and editing data.
- Presentation of information using charts and graphs.
Data Sources for Applications in Government
- An explanation of what constitutes a data source in application development.
- A review of popular data sources used in government applications.
- Discussion on data storage options and services available for government use.
- Guidance on selecting the appropriate data source to meet specific requirements.
- How data is integrated into applications.
- Methods for presenting data effectively within the application.
- Steps to create an application based on selected data sources.
- Techniques for adding, modifying, and deleting controls within the application.
- An introduction to formulas used in Power Apps.
- A definition of model-based applications and their advantages.
- Instructions for creating a model-based application.
Working with a Form in Government Applications
- Previewing forms in read-only mode.
- Reviewing form details and structure.
- Editing forms to modify and save data.
- Adding and deleting data entries within the application.
Galleries and Features for Government Applications
- Managing galleries and their content.
- Using ThisItem for dynamic data handling.
- Applying text formatting and conditional formatting to enhance readability.
- Implementing filtering, sorting, and searching functionalities.
- Navigating between screens and establishing dynamic relationships within the application.
Automation in Power Apps for Government
- An introduction to Power Automate for Power Apps.
- Using connectors such as Office 365 Users and SQL Server.
- Executing conditional operations within workflows.
- Performing basic operations using Power Automate.
- Scheduling processes with the Power Automate scheduler.
- Calling a process from within Power Apps.
- Running workflows directly from PowerApps.
Application Management and Testing for Government
- Implementing application versioning to track changes and updates.
- Sharing applications with colleagues and stakeholders.
- Managing different working environments for development, testing, and production.
- Testing the application to ensure functionality and user satisfaction.
- Adjusting application settings to optimize performance.
- Publishing and sharing applications within government agencies.
- Embedding PowerApps in Microsoft Teams for collaborative workflows.
- Integrating PowerApps into SharePoint Online for seamless data management.
- Using the Power Apps mobile app for on-the-go access.
- Integrating Power Apps with Power BI for advanced data analytics and reporting.
Requirements
Testimonials (5)
The subject was taught in an engaging way, making me want to learn more.
kgotla Moncho - Martin Engineering Africa
Course - PL-300T00: Microsoft Power BI Data Analyst
Blessing made sure that he knows every one , and referred every candidate by their name which is excellent. He is a well experienced Trainer and has patience, and very helpful to all the candidates. Trainer like him make the training more interesting. Wish to have him allocated to my next training that I will be doing with your company.
Alfred Mashala - National Transmission Company South Africa
Course - Analyzing Data with Power BI
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
Course - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
Anne-Cecile Jacquot - Ameropa
Course - Excel to Power BI
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.