Microsoft Power Apps let you build apps fast with a point-and-click approach to app design. You can choose from a large selection of templates or start from a blank canvas. You can easily connect your app to data and use Excel-like expressions to easily add logic. Apps can be published to the web, iOS, Android, and Windows 10.

This Level 1 course will be split into 4 main areas:
Creating and modifying an app from an Excel table
Adding screens and forms from separate tables
Creating drop down boxes from a reference table
Sharing the app via the admin centre and downloading the app onto a device ready to be used.

Prerequisites

• • Delegates should have attended our Excel Level 3 course or have equivalent knowledge.

Objectives

• • Use the power apps environment to modify apps
  • Create apps from an Excel table by using the power apps builder
  • Create multiple screens with forms based on multiple data sources.
  • Create and modify the appearance of the app
  • Move between screens and forms
  • Create a dropdown box from a reference table within a separate form.
  • Use the admin centre to share the app amongst colleagues
  • Download the app onto a mobile device ready to use

This course will be delivered using the PowerApps browser version available via the Office 365 Enterprise licencing scheme.<br/>

What's included

• • Laptops are available for training delivered at client's premises
  • Lunch and refreshments when training is delivered at our training venues
  • Comprehensive course materials and exercises
  • Telephone and Email Support

Course Content

• • Creating and modifying an app from an Excel table
    Accessing one drive from power apps environment
    Creating an app from an Excel table using the power apps builder
    Understanding the interface
    Adding icons, labels, and text boxes
    
  • Adding screens and forms from separate tables
    Understanding the data channel
    Understanding forms and data cards
    Working with screens and forms
    Connecting a form to an additional datasource
    Moving between screens within the app
    Using the Gallery controls
    Filtering
    Sorting
    Validating data and Converting data types
    How to refresh a data source
    
  • Creating dropdown boxes from a reference table
    Editing the fields of a form
    Modifying the order of a form
    Connecting a dropdown box
    
  • Sharing the app via the admin centre and downloading the app onto a device ready to be used.
    Using the admin centre to modify users access to apps.
    Downloading the app and using it onto a mobile device