Microsoft Power Apps: Build Custom Apps Without Coding

Course Curriculum

Chapter 1: Course Introduction + Intro to Power Apps

Lecture 1: Intro: The Instructor. What is Power Apps? Job market and objectives.

Lecture 2: How to Access Power Apps

Lecture 3: Exploring the Power Apps development environment

Lecture 4: Creating an App: The Tablet and Phone Options

Lecture 5: Inside the Power Apps authoring interface – Command Bar

Lecture 6: Inside the Power Apps authoring interface – Element Properties

Lecture 7: Inside the Power Apps authoring interface – Authoring Menu

Lecture 8: Saving, publishing and sharing the application

Lecture 9: Restoring an application version to the previous version

Lecture 10: Notice – Please Read!!

Chapter 2: NEW – MODULE IN PROGRESS!!! Fundamentals: our first case – Contacts application

Lecture 1: Planning the app we are going to build

Lecture 2: Preparing the Excel SpreadSheet

Lecture 3: Connecting Power Apps to the Excel SpreadSheet

Lecture 4: First Screen: Loading Screen

Lecture 5: Second Screen: Home Screen

Lecture 6: Control properties

Lecture 7: Power Apps color themes

Lecture 8: Naming your controls accordingly and desing patterns

Lecture 9: Configuring the start screen of our app

Lecture 10: Navigation between screens

Lecture 11: Executing actions after a certain time with the timer

Lecture 12: How to display data in Power Apps: galleries

Lecture 13: Gallery: The ThisItem property

Lecture 14: Gallery The ThisItem.IsSelected property

Lecture 15: Suggested Classes about Booleans and Logic before continuing

Lecture 16: Understanding the IF function

Lecture 17: Modifying the gallery background color according to the selected item

Lecture 18: Gallery Transitions, Scrollbar and Navigation Button

Lecture 19: Showing users images based on e-mails

Lecture 20: Intro o Containers in Power Apps

Lecture 21: Creating the filter controls

Lecture 22: Theh Search Function: Searching a text in the Gallery from a text input

Lecture 23: Dropdown: Adding a list of data to a dropdown

Lecture 24: Filtering a gallery from a dropdown menu

Lecture 25: How to unselect a dropdown and show all items when nothing is selected

Lecture 26: Combining the dropdown with the text input

Lecture 27: App review + navigation to the Contacts List

Lecture 28: 38. Adding a form and changing field types

Lecture 29: 39. Creating our first record using a form

Lecture 30: 40. Understanding forms a little better: cards and required fields

Lecture 31: The Update property

Lecture 32: Linking the Departments dropdown to the departments table

Lecture 33: Intro to Power Apps variables

Lecture 34: Editing a record from a gallery in Power Apps

Lecture 35: Creating the action buttons with Icon and Label

Lecture 36: Creating a reusable component – Getting started

Lecture 37: Creating a reusable component – Inputs Properties

Lecture 38: Adding actions to the reusable component

Lecture 39: Making the component look like a button

Lecture 40: Opening external links with the Launch formula

Lecture 41: Concatenating strings + encoding text + open WhatsApp with a default message

Chapter 3: LEGACY – Creating connections and app from data

Lecture 1: It's time to get started!

Lecture 2: Creating the data structure for the app.

Lecture 3: Gallery: creating a new tablet app, connecting to data and seeing galleries

Lecture 4: Creating the app from the data.

Lecture 5: OnSelect and Navigate: Creating a new screen and navigating between screens

Lecture 6: Media: Adding a background image to our app

Lecture 7: Table: Creating and editing a table to see our products

Lecture 8: NewForm: adding a new product to the data table

Lecture 9: EditForm: editing existing items

Lecture 10: ViewForm: form in view mode

Lecture 11: Setting the Visible property of the buttons in order to show/hide when adequate.

Lecture 12: Adding a dynamic header to our form with the IF function.

Lecture 13: Barcode Scanner: learning how it works

Lecture 14: Barcode Scanner: integration with form

Lecture 15: Form manipulations: hiding stuff and facilitating data input

Lecture 16: Form manipulations: fixing dropdown default on a new item

Lecture 17: Improving the products gallery

Lecture 18: Setting a different background for each row

Lecture 19: Switch function: understanding how it works.

Lecture 20: Dynamic colors based on quantities

Lecture 21: Dynamic Emojis based on quantities

Lecture 22: IsSelected: highlighting the selected item

Lecture 23: UpdateContext: hiding and showing elements with the Visible parameter

Lecture 24: Patch: updating the product quantity

Lecture 25: New data table: ProductMovements

Lecture 26: Popup windows for products IN and OUT.

Lecture 27: Registering movements for products IN.

Lecture 28: Registering movements for products OUT.

Lecture 29: Hold on tight, we’re not done.

Chapter 4: Final section

Lecture 1: Form Survey: lets build a 5 star course!

Lecture 2: End of the course. Congratulations!

Chapter 5: Bonus Section

Lecture 1: My Youtube Channel