Email: it@huph.edu.vn

Microsoft Power Apps for Beginners

0 students Last updated Mar 2024

About the course

Course content

Sections: 21

•

Activities: 0

•

Resources: 210

1. Welcome
2. Course Overview
3. Getting setup
4. What is a canvas app
5. What is a model-driven app
6. What is Power Automate
7. What is the Dataverse (Common Data Service)

1. Introduction to the PowerApps maker environment
2. Apps
3. Create
4. Data
5. Flows
6. Chatbots
7. Solutions

1.Introduction to canvas app maker layout
2. Left Navigation
3. Middle Pane
4. Right-hand pane
5. Formula Bar.
6. Ribbon
7. Additional Functions

1. Introduction
2. Create a data file
3. Let Power Apps do its majic
Data File

1. Introduction
2. Adding screens to your app
3. Adding Labels
4. Adding Buttons
5. Add text types
6. input Options - Kids Drawing App
7. Input options part
8. Input options part 2

1. Input options part 3
2. Input options part 4
3. Input options part 5
4. Forms
5. Media Images
6. Working with Sound - Part 1
7. Working with Sound - Part 2
8. Icons
9. Add Picture

1. Navigate
2. Collect
3. OnSelect & Select
4. Power Automate

1. Data sources
2. Media
3. Collections
4. Variables

1. What is Power FX
2. Comparing Excel to Power FX
3. Formula (Power FX Resources)
4. Where to enter formulas
5. Basic Math Operations

1. Filter - Setup database for filtering exercise
2. Filter - Configure Galleries on Canvas
3. Filter - Write the expression to filter contacts
4. Filter - Using a dropdown to Filter Data
5. Search Function
6. Edit an exiting record
7. Delete a record
8. Mapping the current user details to a record
9. And, Or, Not Operators
10. Setting global variable within the APP Object
11. Using the Sum expression
12. Using the Calendar Object
13. Using the ColorFade Expression
14. Using Concatenate to join strings
15. Using CountRows in a table
16. Date calculations
17. One click dialing
18. Download function

1. Introduction to Model-driven Apps
2. Creating an app with the new designer
3. Introduction to Tables
4. Introduction to Forms
5. Introduction to Views
6. Introduction to Table Relationships
7. Introduction to Datatypes
8. Introduction to Business Processes
9. Introduction to Business Rules

1. Introduction to columns
2. Setup for column exercise
3. Text Field
4. Multiline Text Column
5. Whole Number
6. Decimal Number
7. Text Area Column
8. YesNo Option
9. Choice Column
10. Choices Column
11. URL Field
12. Status & Status Reason Fields
13. Phone Column
14. Owner Field
15. Image Column
16. Email Column
17. Date and Time columns
18. Lookup Column

1. Introduction to forms and views
2. Preparation for this section
3. Introduction to views
4. Exploring existing View configuration
5. Create a SystemPublic View
6. Create a Personal View
7. Creation your first form
8. Creating a quick view form
9. Inserting data grids into forms
10. Creating a quick create form

1. Introduction to Business Rules
2. Setting column values
3. Clearing column values
4. Set column requirement levels
5. Show or hide columns
6. Lock or unlock columns
7. Validate data and show error messages
8. Create business recommendations

1. Introduction to Business Processes
2. Create the Credit Application Table
3. Creating the Credit Application Business Process

2. Introduction
3. Demo of the completed version
4. Create a solution and required tables
5. Create a model-driven app
6. Complete the model-driven app
7. Lunch time app - Home Screen
8. Creating the Menu Screen
9. Creating the Order Screen
10. Creating the confirmation screen
11. Introduction to the Delivery App
12. Creating the home screen
13. Creating the Ready for Collection page
14. Creating the Confirm Collection page
15. Creating the My Deliveries Page
16. Creating the confirm Delivery Page
17. Exporting your project

2. Introduction
3. Final Solution Demontration
4. Create a Solution for your app
5. Setup the required tables
6. Creating the required columns (Fields)
7. Configure the car components
8. Configure the fuel purchase components
9. Configure the Odometer reading components
10. Assemble the Model-driver App
11. Create an real-time workflow
12. Create a real-time workflow part 2
13. Create a real-time workflow part 3
14. Setting up the required screens
15. Configure the buttons on the home screen
16. Configure the Select car screen
17. Configure the Record New Trip screen
18. Configure the IncomTripList screen
19. Configure the EditTrip screen
20. Configure the Car Report screen
21. Configure Fuel Purchase screen
22. Configure the Submit Receipt screen
23. Update on the image save error
24. Finishing touches
25. Export your completed project

2. Introduction
3. Demo of the Completed Solution
4. Download and install the required components
5. Overview of Lucid and Miro
6. Installing the base components
7. Setup the database - Part 1
8. Setup the database - Part 2
9. Setup the database - Part 3
10. Setup the database - Part 4
11. Setup the database - Part 5
12. Configuring the form layouts - Part 1
13. Configuring the form layouts - Part 2
14. Configuring the form layouts - Part 3
15. Configuring the table views
16. Creating the Admin Application
17. Creating sample data for our APP
18. Purchase Order & Order Products Automation
19. Automatic creation of Items

1. Connecting the required data sources
2. Cashier & Manager Login Configuration
3. Configure the items gallery
4. Review Keypad Configuration
5. Recording the items the customer purchased
6. Configure the itemselected Gallery
7. Function to cancel selected items
8. Loyalty Membership
9. Configuring the receipt
10. Calculating the change
11. Creating a receipt using Power Automate
12. Some odds and ends
13. Using Patch to create the receipt items
14. Change item(s) status to sold
15. Email receipt to customer
16. Create new Loyalty Customer
17. Cancel Sale Function

1. Configuring the End-of-Shift report
2. Configuring the Cash Up total
3. Configuring the end-of-shift Form
4. Configuring the end-of-shift button
5. Configuring the manager PIN
6. End-to-end test.
7. Configuring the stock take functions - part 1
8. Completing the stock take functions
9. Configuring forced rollups
10. Final end-to-end solution test - Part 1
11. Final end-to-end solution test - Part 2
12. Exporting your completed project

1. Providing users with access to your app
2. Security Roles - Business Case

Instructors

Enrolment options

Microsoft Power Apps for Beginners

Microsoft Power Apps for Beginners

Course modified date: 20 Mar 2024

Enrolled students: There are no students enrolled in this course.

Guests cannot access this course. Please log in.