PowerApps - Microsoft Power Apps Bootcamp (Beginner to Pro)

Understand PowerApps environments as containers for apps and data inside your Azure AD tenant, and use solution packages to move resources between development, testing, and production environments.

Explore the six Power Platform environments and learn when to use default, trial, developer, sandbox, production, and dataverse teams for development, testing, and deployment.

Explore PowerApps licenses, from the free developer plan for learning to premium licenses for organizations, including AI builder credits, Dataverse storage, and purchase steps in the admin center.

Explore the Power Apps tour to discover the new experience toggle, left navigation, create options, templates, Dataverse data model, and AI hub.

Create and organize PowerApps solutions, choosing between unmanaged and managed types for development vs production. Name the solution, select a publisher, and add a canvas app inside to differentiate projects.

Start a blank canvas app in PowerApps and choose a tablet design. Explore the insert panel, data connectors, theme, and screen properties to build and preview your first canvas app.

Save and publish PowerApps projects with version notes, view and manage version history, and restore prior versions to keep the live app aligned with team changes.

Explore how to view and share a Microsoft Power Apps application, wrap it for mobile, access a link or mobile QR code, and manage app ID, licenses, versions, and connections.

Create an app with Copilot automates database architecture, generating student and attendance tables and a responsive canvas app with data sources, screens, and search functionality.

share a Power Apps app with others, assign user or co-owner access, add the app to Microsoft Teams, and create copies with save as or download.

Explore vertical, horizontal, and flexible height galleries to view data from SharePoint. Bind to electronics inventory, show product name and price, and tailor templates, borders, transitions, and data tables.

Create a new SharePoint list from scratch and add columns for a bookstore app—book name, publisher, signatures, created date, price, and image—and populate sample data to connect with a gallery.

Connect a SharePoint list to a PowerApps vertical gallery, add a data source, and display image, title, body, and publisher; build an app that easily views and submits data.

Learn to add, delete, and manage images and icons in a Power Apps gallery, including image control usage, uploading from system or media, drag-and-drop, transparency, rotating icons, and clickable UI.

Create and connect an edit form to a SharePoint list, configure a submit button to save new records to the database, and view submitted data in the gallery.

Explore form properties in PowerApps: reset after submission, use on success to notify users with banners (success, error, information, warning), and adjust columns and orientation for better layout.

Navigate between screens in PowerApps using navigate and back functions with a button or icon. Show how to select target screens, preserve context with back, and test transitions without effects.

Create and customize a text input to capture user data, display it in a label, and explore properties like hint text, max length, and mode to design forms in PowerApps.

Design a PowerApps form using text inputs and labels for book name, price, publisher, quantity, and signatures, with border styling and a submit button to store data.

Learn how shapes in Power Apps serve as non-interactive UI elements, including circles, rectangles, and borders, and how layering and border radius create circular avatars and form-like layouts.

Learn to implement a drop-down and a combo box in Power Apps, drive their items from a SharePoint list with the choices function, and support search and multiple selections.

Switch to modern controls in Power Apps and compare new versus classic UIs. Learn naming conventions and practical steps in settings, insert controls, and themes for readable, compact interfaces.

Upgrade the user interface with the new text input controls, placeholders, color palettes, and modern icons. Configure the date picker, capture its output, and format dates with dateTimeValue.

Learn how containers organize controls in PowerApps to build responsive layouts. Use horizontal and vertical containers to allocate proportional space, like 25% per item.

Replace shapes with containers to improve user interface by applying border radius and drop shadows, creating card-like galleries. Bind controls inside the container so components move together.

Explore how to use the attachment control to upload documents, Excel files, PDFs, or images to a database, mirroring a SharePoint book image column, with the add media button outputs.

Explore how to use the pen input control in PowerApps to capture signatures, adjust thickness and color, toggle controls, and display the drawing in an image control on a form.

Explore the rich text box in PowerApps for live text edits with bold, italic, underline, color, font size, links, alignment, and bullets, and apply it to composing emails.

Learn to use the HTML text control in PowerApps to embed HTML styling, create gradient boxes with shadows, and bind width and height to parent values, unlike containers.

Explore graphs and charts in PowerApps using column, pie, and line charts with data, and learn to use collections and sales data for visualization.

Explore themes and templates in Power Apps, switch to a modern theme, customize themes, and use templates like onboarding and meeting capture with Planner, Outlook, OneNote, and Office 365.

Learn how to group multiple controls in PowerApps to move and manage them together, and apply common properties like visibility, font, color, and padding at the group level.

Explore formulas and functions in canvas apps to simplify calculations, navigate between screens, and access data with functions like average, last, and other Power Apps tools.

Apply PowerApps mathematical functions in galleries and forms, including sum and square root. Use round, rand, and rand between to adjust data and pricing by $5.

Explore color functions in Power Apps, including rgb(a), hex color values, and the color value function, then learn to adjust transparency with alpha and color fade.

Master date time functions in PowerApps, including the calendar function, today, date add, date difference, and formatting for day, month, year, and time.

Explore core logical functions in PowerApps, including if and switch, and, or, not, plus string tests like starts with, ends with, is blank, and is empty.

Explore information functions in PowerApps, return booleans for conditions, use is match for string checks, is today with now for dates, and is empty or is blank for data.

Apply text functions in PowerApps to manipulate and format strings, including concatenate, left, right, length, lower, upper, split, substitute, and trim. Convert between text and numbers and prepare outputs.

Explore statistical functions in PowerApps, including average, count rows, count if, max, and min, and learn how to apply them to data sources and delegation considerations.

Discover PowerApps variables, including contextual (local) variables, global variables, collections, and environment variables, and compare their scopes across screens and solution-wide apps.

Learn to use local variables with update context on a screen’s visible event, assigning text, numbers, or booleans, and recognizing scope limited to a single screen.

Learn to set and use global variables in PowerApps with the set function, access them across screens, and balance global vs local variables to optimize memory.

Create environment variables inside your PowerApps solution, choose text type, and set default and current values to control which data is used across apps.

Compare the definition table and environment variable value table to see how environment variables store default values and current values, enabling retrieval of environment data for a canvas application.

Learn how to connect and query environment variable definitions and values in a PowerApps canvas app using lookup to retrieve default and current values by display name and schema name.

Learn what a collection is and how to create and use it as local storage in canvas apps, including offline mode, data limits, and strategies for handling thousands of records.

Create and manage collections in PowerApps with collect and clear collect, storing items from a gallery as rows with name, price, and quantity, persisting across screens as a global variable.

Learn to create and manage collections with the clear collect function, replacing prior data on each click, and set up a mobile data collection with up to 2000 records.

Create collections from existing data sources like SharePoint and Dataverse using collect and clear collect, map fields, and use the collection across screens.

Update an existing PowerApps collection using update or update if with a lookup to select records by launch year. Batch update multiple records with update f function.

Explore deleting collection data in PowerApps using remove, remove if, and clear, including lookup-based deletes and bulk clears to manage records efficiently.

Learn to create and manipulate records using the patch function in PowerApps, covering CRUD operations, batch and update functions, data type conversions, and submitting updates to a SharePoint list.

This lecture demonstrates building a popup user interface to update SharePoint list records using the update function, with inputs for book name, price, and publisher, plus update and cancel controls.

Learn to update a SharePoint list record using the update function inside a PowerApps popup, including visible container toggling, selecting a record, and updating title, price, and publisher fields.

Learn to update SharePoint list data using update and patch functions, matching records by title or price with a lookup, and choosing bulk versus single-record updates.

Delete records in PowerApps using remove and remove if, matching booktopia to gal books dot selected dot name, and delete items with a filter such as price greater than $10.

Demonstrates using if conditions in PowerApps to drive color changes, enforce required fields, and patch data, while contrasting the if-else approach with the switch condition.

Learn to build nested if conditions in PowerApps, testing values and assigning colors like red or gray, and compare with switches for complex logic.

Implement a search function with a top search bar to filter data by the title in PowerApps, using a text input, across SharePoint, Dataverse, or Excel, with delegation notes.

Sort data in a PowerApps gallery using the sort function on the price column, toggling ascending and descending with a button and a boolean variable.

Understand filtering with the filter function by price, using a text input and the value function to convert text to a number, showing records above the threshold.

Explore replacing if conditions with a switch condition to map a variable value to colors for a rectangle's fill, and compare switch with nested if logic.

Use the lookup function to fetch a single record matching a condition from a data source, such as price greater than 20, then apply patch or update and other controls.

combine filter and sort in PowerApps by filtering with a text input, then sorting by price to produce ordered records, using the filter as a data source.

Practice data validation to patch records into the database, using the book name text box and dynamic alerts when the field is empty.

Learn to pass data between screens in PowerApps using the navigate function, by sending local variables and various data types to the next screen.

Learn how to use the width function in Microsoft PowerApps, passing a scope and a formula to compute values a and b, and enable data via patch, update, or lookup.

Power Automate flow automates manual and backend tasks while integrating with Power Apps and databases. It can create, modify, or delete records and send emails, using triggers from Power Apps.

Learn how to connect Power Apps to a Power Automate flow and pass a text input via the flow run property triggered by a button.

Send data from a canvas app to a power automate flow using the respond action and a compose output. Capture flow output in a variable and refresh to reflect changes.