Microsoft Power Apps Essential Training: Beyond the Basics (2020)

Course details

Microsoft Power Apps makes it possible for anyone to build robust, no-code mobile business apps using data from a variety of sources, including OneDrive, Excel, and SharePoint. The apps you create are easy to distribute throughout your organization, leading to increased productivity with minimal investment. In this course, Bill Kulterman explores how to quickly create and share business apps using Power Apps, leveraging advanced features such as templates and themes. Learn how to collect data through a Power App, access data in SharePoint lists and Excel spreadsheets, add and remove fields, incorporate additional data connections, add screens, create buttons and actions, and more. Bill helps you build surveys, budget trackers, and reporting apps, but with these lessons, the only limit in Power Apps is your own imagination.

Topics include:
Creating an app from a SharePoint list
Adding and removing fields
Saving and publishing the app
Creating a survey app with drop-down lists
Making a data connection in OneDrive
Adding additional data sources
Adding a theme
Creating a budget tracker app
Using Power Apps templates
Creating an app that connects to multiple SharePoint lists
Adding blank screens

Concepts

0. Introduction

01 - Do more with Microsoft Power Apps

1. Create an App from a SharePoint List

02 - Making a data connection
03 - Create an app
04 - Change the browse screen
05 - Change a function formula
06 - Reorder the display fields
07 - Add columns
08 - Unlock the fields to change the display
09 - Add and remove fields
10 - Change the display mode
11 - Change how the list is sorted
12 - Change the search field
13 - Delete an action
14 - Save and publish the app

2. Create a Survey App with Drop-Down Lists

15 - Format the data in Excel as a table
16 - Make a data connection to OneDrive
17 - Create and preview the app
18 - Change the detail screen layout
19 - Change single-line text into a multiline text field
20 - Add another data source
21 - Add a drop-down input field
22 - Connect the drop-down field to data
23 - Save and test the app
24 - Add a theme and create a new version of the app

3. Create the Budget Tracker App from a Template

25 - Power Apps templates
26 - Create the Budget Tracker app
27 - Preview the app
28 - Replace sample app data
29 - Refresh the data connection
30 - Save the app and share it
31 - View the stored receipt files

4. Create an App That Connects to Multiple SharePoint Lists

32 - Create the app
33 - Display a value as currency
34 - Add data connections
35 - Add an additional list screen
36 - Add an additional blank screen
37 - Add a text label
38 - Add a button and an action
39 - Change button color
40 - Add an icon and an action
41 - Add a tool tip
42 - Preview the app and write data to SharePoint

Conclusion

43 - Next steps

Microsoft Power Apps Essential Training: Beyond the Basics (2020)

Authors

Bill Kulterman