Microsoft PowerApps

Audience:End User / Power User, Business Executive
Duration:2.00 day(s)

Price: £975.00
Accommodation: £220 (UK Midlands only)

About this course

This course delivers an instructor-led breakdown of Microsoft PowerApps. Students will be taught how to design, test and publish new applications that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.

Meet your trainer

Choose a date

Delivery Date Delivery Type Delivery Location  
November 26, 2018OnlineEMEA UK Time (9:30 start)
Book now
January 7, 2019OnlineEMEA UK Time (9:30 start)
Book now
March 18, 2019OnlineEMEA UK Time (9:30 start)
Book now

All Combined Knowledge courses can be delivered privately online or at a site of your choice.
Contact us to arrange private delivery of a course or to find out more.

Book a private delivery of this course

There are currently no dates scheduled for this course, but all of our courses can be delivered privately at a site of your choice.

Our private on-site / online training can provide your business with the following benefits:

  • Substantial savings on travel and expense costs
  • Group learning – ensuring a consistent transfer of knowledge
  • Open discussions focused on specific business requirements
  • Ability to ‘cherry pick’ modules and tailor course content to your specific needs.
  • Multiple delivery and set-up methods

Contact us to arrange private delivery of a course or to find out more.

Course Syllabus

This course delivers an instructor-led breakdown of Microsoft PowerApps. Students will be taught how to design, test and publish new applications that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.

Audience

This class has something for everyone, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their applications.

Prerequisites

Delegates should have prior experience of using Office 365.


Module List

Module 1

An Introduction to Microsoft PowerApps

Module 2

Getting Started with PowerApps

Module 3

Branding and Media

Module 4

PowerApp Controls

Module 5

Data Sources and Logic

Module 6

Model-Driven Apps

Module 7

PowerApp Integration

Module 8

Administration and Maintenance


Module 1: An introduction to Microsoft PowerApps

Let's get started with an introduction to Microsoft PowerApps. Traditionally building customised solutions for a business involved using a coding language to build an application from scratch. Typically, these solutions could often only be used within the business, making external use of the application a large hurdle to overcome. With PowerApps we can now not only easily build solutions, but we can also share them with users in our business. Deployment takes seconds and you could by testing your own app on your phone in no time. This module will overview the features of PowerApps, its benefits to a business and the variety of ways you can build and access your apps on different devices.

Topics Covered

 

What is PowerApps?

The benefits of apps
How to get to PowerApps
Canvas Apps and Model-Driven Apps

License Options and Costs




Module 2: Getting started with PowerApps

To begin our journey through the PowerApps product, we will begin by looking at some of the templates that are available to view and edit. Microsoft's templates are a good starting point to discover what the product is capable off and how it can be achieved. We will also take the chance to have a tour of the editor so that students are familiar with the interface that they will be using over the two-day course. We will then build our first app from a static data source, showing students how to test their changes in the app instantly without the need to publish. We will also discuss how to configure your apps settings and how to access the app once it has been saved and shared.

Topics Covered

 

Discover PowerApps with templates

Building a new app with a data source

Add, edit and remove controls

Testing an app

App settings

Publish and share an app

Mobile app


Module 3: Branding and Media

In our next module, we will look at the options available to designers that allow them to implement their business branding. Not only will this deal with the aesthetics of your app, it will also introduce time-saving tips to help keep your branding consistent. We will also be discussing how to embed media into your app which can be useful if you are planning on an app that might promote video content.

Topics Covered

 

Linking control properties

Backgrounds

Colours and transparency

Duplicating screens

Copying the look and feel

Using images

Embed and play audio and video

 


Module 4: PowerApp Controls

So far in the course, we would have covered the basics of adding, editing and removing controls from our applications. The drive behind this module is to provide more depth on the categories of controls which can be used on a form. Your instructor will take you through each control and discuss its purpose and configuration. Tackling the wide selection of controls will help students recognise when to use the right control.

Topics Covered

 

Labels

Buttons

Text inputs

Controls

Galleries

Data tables

Forms

Media

Charts

Icons


Module 5: Data Sources and Logic

To help maintain and view essential business information, organisations often have a diverse selection of locations to keep different types of data. This could range from databases to file storage locations. PowerApps offers connections to a wide selection of data sources. We will show students to build their PowerApps to bring in data from a variety of sources as well as how they can utilise the common data source, a storage location unique to PowerApps.

Topics Covered

 

Working with files

Databases
Filter, sort and search formulas
If and Select

Accessing on-premises sources

The common data source

Sharing data sources


Module 6: Model-Driven Apps

Module one to five discussed how to work with the original type of PowerApp known as a Canvas App, Microsoft have now introduced a second type of app known as a model-driven app. Model driven apps involve a different development process to canvas apps. We will review this development process during this module.
Model-Driven apps can be quicker to build than canvas apps, but they are less customisable and typically have a higher cost, knowing which type of app to use is not always a simple decision, we will show you the pros and cons of each.

 

Topics Covered

What is a model-driven app?
Where will my data be stored?
How do create a model-driven app
Canvas vs model-driven summary
Mobile App


Module 7: PowerApps Integration

PowerApps is designed to easily connect to other business systems to read and update information. In this module we will discuss some simple ways to integrate PowerApps with key Office 365 systems including Teams, SharePoint Online and Flow. The result, is the ability to use a combination of systems to create solutions for a variety of business requirements.

Topics Covered

 

Start a Flow from a PowerApp
Embed PowerApps in Teams
Embed PowerApps in SharePoint Online


Module 8: Administration and Maintenance

In our last module for Microsoft PowerApps, we will be looking at how a business can manage their existing apps. This could be using analytics to discover usage trends. We will discover how to export and import apps, so they can be reused in other locations. Finally, we will discuss how Office 365 administrators can shape the PowerApps experience with high-level settings that help ensure data segregation and security.

 

Topics Covered

Maintaining an app

View analytics

Export and import apps

Office 365 administration for PowerApps           

Environments

Data policies

Data integration

Courses related to Microsoft PowerApps

This course delivers an instructor-led product showcase for Microsoft Flow from start to finish in an engaging and practical way. Flow is a diverse product, turning business processes into automated, consistent and visual workflows. Flow is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workflow logic for your business workflows.

View course

This fast paced 3-day workshop will teach you how to build powerful SharePoint business solutions without having to engage in any custom development. You will be amazed exactly how far you can take things with Office 365 and SharePoint Online just using the out-of-the-box features and functionality. This course has been specifically designed for the experienced business users who wants to re-engineer parts of their business process in the Office 365 environment. You will complete all lab exercises for this course using the browser, SharePoint Designer 2013, InfoPath 2013 and other no-code tools, such as Microsoft Flow and PowerApps.

The first day of the course introduces you to Office 365 services and revises SharePoint Online functionality, in particular, how to customize lists and documents libraries by creating and adding site columns and contents types, and the use of Document sets. You will end the first day by reviewing the current list of no-code tools, including an introduction into the use of Windows PowerShell.

You will learn how to use InfoPath 2013 and PowerApps to customize the forms to display and manipulate data from SharePoint list and other data sources, as well as introducing you to Microsoft Forms. You will learn about the workflow architecture in SharePoint Online and discover a new sense of power when creating custom workflows with SharePoint Designer 2013 and Microsoft Flow.

You will learn how to visualize your business data on top of services that are included in Office 365 such as Power BI and Excel Services and the course concludes with an examination of the techniques and strategies to expose content on pages you find in Office 365.

View course

Over many years, we have come to understand and love a suite of Microsoft products including products like Outlook and Excel; most of these products have been with us for over ten years and often make the work we do possible.

Office 365 has introduced a range of new products causing much excitement and more than a little confusion. This class will help you to understand two of these newer products, Office 365 Groups and Teams.

We cover the specific details of how to use Groups and Teams, while also looking at the bigger picture to help you understand how you might use them in the real world to improve the way you share files and communicate as a business.

Finally, we discuss the administration process for Groups and Teams, with a review of the management options including security and controlling who can use the tools.

View course

For users with 6 - 12 months' experience with Power BI, this Certification Bootcamp is an advanced 3-day training class designed to prepare students to pass Microsoft certification exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI. During the course, students will gain the real-world skills required to design, deploy, upgrade and monitor reporting and dashboard solutions using the rapidly-evolving Power BI platform. All the essential Power BI concepts and techniques discussed in lectures are reinforced with hands-on lab exercises in which students will move through the actual steps required to build reporting and dashboard solutions and then to distribute those solutions to a wide audience using app workspaces and the Power Bi app model.

View course

This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ‘what not to do’ as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.

View course