Select Page

PowerApps

These coaching sessions are designed to be hands on, practical, relevant and specific to each person and their particular requirements.  This will be followed by detailed coaching, feedback, content edits, recommendations, top tips, and Q&A. We aim to elevate your confidence and grow your virtual classroom skillset significantly! Let’s chat and explore how we can help you!

Premium Skill sheets

Professional Coaches

Personalized learning

Regularly updated content

Over Topics to choose from

Learn at your own pace

Online Delivery

Tests and quizzes

 Free Support after course

Certificate on Completion

Live online sessions are virtual instructor-led sessions conducted online from your location.  You will be sent an invitation to join the session. A computer with an internet connection and a browser.

You will have an opportunity to have your own virtual classroom displayed as comfort of own home or at work.

You will be sent an invitation to join the session online.

Entry requirements

Learners must have basic literacy and numeracy skills.

Computer requirements

Learners will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows
  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Microsoft edge , Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster

Learners will also need access the following applications

  • Adobe Acrobat Reader

 

Business Outcomes Covered in these courses

  • Microsoft 365
  • Shortcuts and Tips and Tricks
  • To inquire about Live Online Courses, please Call +61 2 6243 4862

PowerApps

Empower everyone in your organization to build business apps the easy way with Microsoft Power Apps and start modernizing processes and driving.

Courses 

Introduction Topics

PowerApps

 Topics will be selected from the following list

About PowerApps

What Is PowerApps?
Who Is the Citizen Developer?
PowerApps And Office 365
How Dynamics 365 Relates to PowerApps
Understand Licensing Options

Getting Started with Power Apps

Accessing PowerApps
PowerApps Home Screen
Building A PowerApp
Introduction to PowerApps Environments
Understanding types of apps Mobile or Tablet apps

Data Sources and Connections

What is the Common Data Service (CDS) for Apps
How Dynamics 365 relates to PowerApps
Data Sources and Connections
Introduction to data sources and connections
Available data sources and connections
Connecting to a SharePoint list

The PowerApps Studio

Introduction to the PowerApps Studio
Navigating the PowerApps Studio
Working with the PowerApps Studio
How does An App Work?
Introduction to components of an app
Understanding screens
Understanding controls
Understanding properties
Using Gallery Controls
Using Form Controls
Saving your App

Coding in PowerApps

How Much Code is low code?
Formulas and Functions
Formatting of Formulas and Functions
Referencing Other Controls
Using Variables in PowerApps
Using Data Sources
Data Connections in PowerApps
Accessing Data in Controls
Delegation in PowerApps

PowerApps Settings

Configuring App Settings and Features
Saving and Sharing
Saving Your App
Closing Your App
Versioning Control
Sharing Apps with Others
Viewing Shared Apps
Exporting a PowerApps
Loading a Locally Saved App File

Using Forms to Display Items

Adding Forms
Using Display Forms
Calculating Values
Using the OnChange Property
Creating Variables
Using Variables in Formulas
Updating Our Data Source
Using the Mobile App
Downloading the PowerApps App
Accessing your Apps
Viewing list of Apps

Creating an App from Blank

Introduction of our case study
Planning your app
Exploring your data
Creating a blank app
Creating a SharePoint connection
Connecting to static Excel Spreadsheets
Creating an Office 365 connection
Customising your Blank App

Building and customising your app

Adding Screens
Adding Shape Controls
Adding Images
Adding Text Labels
Uploading Images
Using the OnSelect Property
Adding Navigation
Aligning Objects
Creating Control Groups
Editing and displaying data
Adding Galleries
Customising A Gallery Control
Adding Controls to a Template Cell
Filtering Your Data
Adding Combo Box Controls
Adding Slider Controls
Adding Date Picker Controls
Searching Gallery Items

User Experience

Understanding User Experience
Creating App behaviours to inform users

 

PowerApps Functions

Colours
Concatenation
Distinct
Filter
First
If
Isblank
Lookup
Navigate
Office365 Outlook
Office365users
Operators
Patch
Set
Sort
Startswith
Sum
Text
Thisitem Operator
User
Value
Patch

Favourite Apps

Pin shortcut to home screen
Windows 10 PowerApps App

 

FAQ

Does the course include hands-on training?

Yes, you can follow the coach as you do the training. The course also includes a quick skillsheets reference guide and quiz for each lesson, to help you cement your knowledge.

What version of software do I need?

The course is compatible with Microsoft 365 (previously known as Office 365) and Excel for Windows 2019, 2016, 2013, 2010. Also available for Mac.

I’m a beginner. Can I take this course?

Yes, you can! This online course starts with the basics and is suitable for beginners. With each lesson, you will build your knowledge, going from beginner to intermediate and advanced lessons. Once enrolled, our friendly support team and instructors are here to help with any course related inquiries.

What if I have some experience with? Is this the right course for me?

Contact our staff and customise the session based on topics you would like to learn.

How long does it take to complete the course?

Each bite-sized lesson consists of a 30min, 45min, 60min, 120min sessions.  This microlearning format makes it easy to fit learning into your busy schedule, so you can even complete a lesson during a lunch break or on your commute. Have a look at our packages www.janszgroup.com.au/digital-coaches

 

Do you have other online courses?

Yes, we do! Here are the other courses we offer:

www.janszgroup.com.au/courses

Do you have any free resources?

You’re in luck! Start learning OVER 100 of the best shortcuts for PC and Mac (free PDF cheat sheet included). And check out our resources for regular posts.

What our learners say!

Very helpful and useful information that will be used daily for my working tasks to improve efficiency.

MattTAFE Teacher