Power Apps - Complete Guide to Microsoft PowerApps

Connect to data sources in Power Apps by linking OneDrive or Google Drive and importing an Excel file; format as a table to create an app from it.

Learn how to connect Power Apps to Google Sheets by importing a Customers ToImport sheet, selecting Sheet1, and linking via a Google Sheets connection, with options for other data sources.

Find all reference materials at the bottom under section 11: reference material, and download the Excel file used in this course by clicking the links.

Explore the power apps development environment, a drag-and-drop low-code tool that builds apps from data sources like Excel, OneDrive, Google Sheets, or SQL.

Demonstrate basic Power Apps functionality by editing records, adding entries, and deleting items, while Power Apps ID tracks changes in the underlying Excel or Google Sheets data.

Learn easy customization in Power Apps by applying themes, fonts, colors, and icons. Adjust app settings like name, background, orientation, and scale using a simple click-and-drag interface.

Explore the Power Apps development environment, including the tree view of screens, elements, and their properties, and learn to use dynamic properties and formulas to drive app behavior.

Explore how forms and data cards work on the detail screen in Power Apps, drag to reorder fields, customize keys and values, unlock cards, and adjust column layout.

Explore configuring detail screens in Power Apps with data cards, formatting dates with the text function, and building a dynamic title from the selected record’s first and last name.

Learn how the Power Apps edit screen uses an edit form and data cards, where update properties submit changes, enforce validation, and support read-only fields like passport and customer numbers.

This lecture defines triggers in Power Apps, highlights OnSelect and OnChange, shows how semicolons chain actions, and demonstrates resets, navigation, data refresh, and startup triggers.

Explore how to use Power Apps formulas to manipulate text and dates with the formula reference, including concatenation, text conversion, short date formatting, and month-year formatting using ThisItem data.

Use the navigate function to switch screens with transitions from data cards, navigate to detail or edit screens, and leverage the back function to return to the previous screen.

Learn to detect, identify, and resolve errors in Power Apps using inline error indicators, app checker, and targeted fixes across screens, plus consulting online solutions.

Share your app to create a download link, save it to your account, and log in to the PowerApps app on your phone with the same credentials to run it.

Learn to build a canvas app from scratch in Power Apps. Use a master screen and a documentation screen to keep colors and layout consistent across screens.

Create a canvas app master screen with a title label at font size 40, white title color, and a light gray background, following the documentation method.

In this Power Apps session, create a home screen with three navigation buttons, add a magnifying glass icon, and fine-tune colors and hover fill.

Explore building galleries in a canvas app by connecting a OneDrive table, configuring title and subtitle, concatenating first and last names, and displaying location and VIP level, with tablet-mode layouts.

Add a top navigation with a white home icon, connect its onselect to navigate to the view customers screen, and use back or navigate to return to the home screen.

Explore how variables work in Power Apps and how the platform acts like a static language, referencing text box properties to sum two numbers without using variables.

Explore how contextual variables work in Power Apps, creating screen-scoped values with update context, such as first number and second number, and compute their sum and counter increments.

Learn how to create and use global variables in Power Apps with the set function, share data across screens, and reference a counter global in later screens.

Create and manage collections in Power Apps using the collect function to store two-column records, dynamically add items via text inputs, display them in a gallery, and remove items.

Explore implementing a search field to filter a gallery using the Power Apps search function, searching first name, last name, and agent name with a toggleable text input hint.

Explore the filter function in Power Apps, applying multi-condition logic to a table, and learn to combine it with search and a VIP level dropdown to drive a dynamic gallery.

Learn how to link navigation between the detail and edit screens by adding an edit icon, navigating to edit, and returning to details, while aligning data card order for clarity.

Learn to add a new customer screen by reusing the same form and toggling between new form and edit form modes, with proper navigation and back behavior.

Learn how to implement data validation in Power Apps using the isMatch function to prevent digits in names, display a validation error, and optionally disable the submit button.

Link data validation to a single validation flow using a validate button and a submit variable in Power Apps; ensure fields validate before submission and reveal errors only when appropriate.

Add a new Excel data source named agents, save to your drive, convert to a table with headers, and connect it to Power Apps for multi-source data integration.

Create an agent screen with a non-editable data table, displaying the agent name and phone number from table 1.1, and navigate to the agent screen.

Explore the Power Apps lookup function to dynamically pull an agent's phone number by matching the agent name across customers and agents data sources, enabling one-click calling.

Create a call agent button in Power Apps that uses Launch with a tel URL, concatenating the label's phone number to dial.

Publish your Power Apps project by choosing file, save, then publish this version to push updates to all users and enable native opening on devices.

Set the app's first screen by moving a screen to the top, replace the master screen with the home screen, then save, publish, and refresh to see the change.

Master Power Apps by building canvas apps with new inputs, charts, and media; explore CDS connection pathways and model-driven apps to create central, app-within-an-app solutions.

Discover how to use Microsoft Docs to master canvas apps, navigating design, control references, and formula basics, then apply relational data and accessibility concepts in your applications.

Learn to group objects in Power Apps, reuse common properties, and propagate size and style changes across grouped elements, including nested groups and mixed controls like labels and buttons.

Explore cascading drop-downs in a Power Apps app. Create dependent location and VIP level filters using distinct, sort by columns, and filter functions to reveal matching records.

Link two drop-down menus by filtering data source to show only VIP levels for the selected location, e.g., filter Table One where location equals chosen value, creating cascading dropdowns.

Add delete button on detail screen to remove selected record from table one with the remove function and Gallery2.Selected, then navigate back to view customer screen with cover transition.

Learn to implement a delete confirmation popup in power apps by updating a confirmation variable, showing a grouped popup with yes/no buttons, and navigating to the view customer screen.

Explore how common data services use entities as templated tables to store records, with preset account entities that include fields like address, credit limits, and lookups for relational data.

Explore how entities use fields and relationships to connect accounts, users, sales, and discounts through many-to-one, one-to-many, and many-to-many patterns.

Explore business rules and views in model driven application, applying rules such as making alcohol license ID mandatory and creating active accounts views that show a filtered, limited column set.

Create and edit records with forms in model driven apps, using account templates, rearranging fields, and adding or removing fields, while noting dashboards, charts, keys, and data.

Create a new entity named customer, set the primary field to number, and provision the table to store customer data. Power Apps suggests fields like created by and modified by.

Add fields to the customer entity, such as first name and last name, choose text data types, set optional, recommended, or required, and explore calculated fields like full name.

Add a calculated field in Power Apps to generate a full name by concatenating first and last names, then save and view the automatically calculated result.

Add and configure fields in Power Apps, including first name, last name, a calculated full name, date joined (date only), and text fields for location, passport number, and agent name.

Explore viewing and editing data in Power Apps by inspecting the customer table, viewing all fields, and creating a calculated full name by concatenating first name, space, and last name.

Create custom views in Power Apps to display a subset of fields from the underlying data. Sort, filter by vip level, and publish views to tailor presentation for model-driven apps.

Create and customize forms in Power Apps by building a main form, adding fields and sections, and configuring properties to add or edit customer records.

See a business rule in action, a flow-chart style validation that enforces data correctness as you add a record via a form, with inline errors like vip level constraints.

Explore other common data service concepts and leverage dataflows to automatically load up-to-date data into common data service; connect sources, use gateways, and see views and forms in model-driven apps.

Explore input, media, and charts in Power Apps, including pen inputs, combo boxes, and microphone features. Use the docs and control reference to add these elements.

Learn to use sliders as input elements in Power Apps, set min and max, bind values to labels, and adjust brightness by mapping the slider to a 0–1 range.

Explore rating inputs and timer controls in Power Apps, using stars for ratings and a timer to trigger actions, update labels, show hints, and animate visuals.

Learn how to use the image element in Power Apps to display, customize, and upload images, making logos or icons clickable and replacing default icons on screens.

Explore how pen input creates an image from your drawing and binds it to an image control. Save resulting image to databases or cloud storage like OneDrive or Google Drive.

Learn how to integrate a camera control in Power Apps, capture photos, and bind them to an image or gallery across screens to create a professional app.

Use the media add photo control to let users select an image from their file directory or camera and display it via an uploaded image control in your app.

Explore how to display dynamic images in a Power Apps gallery by binding each item to its imageURL from a OneDrive table, with data source setup and refresh steps.

Explore how to add charts and graphs in Power Apps, leveraging a Power BI tile for dynamic visuals and steps to display revenue data from OneDrive.

Open Power Apps, create a new model-driven app named FirstModelDrivenApp, optionally add a description and customize the icon, skip the welcome page, then click done to create the app.

Navigate the Power Apps environment by exploring its sections, site map, dashboards, business process flows, and entity views, and learn to configure, view, and manage artifacts, forms, charts, and properties.

edit and configure the site map by adjusting areas, groups, and subareas; assign targets like a dashboard, entity, web resource, or URL, then publish to view customer and address data.

Edit forms and views in Power Apps by configuring which views appear for users, then customize forms, charts, and dashboards tied to the entity in the Common Data Service.

Configure a central business rule that validates VIP level and location on the form, preventing submission when conditions fail, and ensuring the rule propagates across all data and forms.

Explore how to use business process flows in Power Apps, including data steps and conditions, and how decision paths route to update content, expiration, or publish steps.

Explore the model driven apps documentation, covering design, views, forms, site maps, and the app designer, and note how it relates to canvas apps and Power Automate.

Extend Power Apps to websites with portals, enabling secure data sharing with external users through a low-code, responsive platform with authentication for access control.

Set up a new Power Apps environment called PortalTester, create a database for portals, select USD and English, and prepare the common data service layout before building a portal.

Navigate to data and select entities to create a new entity named Agents, then set the primary field to ID and click done to finalize the entity.

Discover how to create a URL in Power Apps portals, troubleshoot a Chrome bug by using Edge or Firefox, and follow Microsoft support steps as the portal builder provisions.

Explore the portal environment in Power Apps, building a website from elements like sections, headers, and text boxes, adjusting properties, themes, and templates, then synchronize and browse live changes.

Add portal components by selecting a section, insert a text title, adjust font size to 36, bold it, and apply blue color to customize your page.

Edit section properties and background images, access basic components with paid options, and learn how sections and portal components use columns to place elements side by side, stacking on mobile.

Add a blank page or landing page in Power Apps Portals, name it Agents, and watch the header update automatically with the page starting from the default studio template.

Populate a Power Apps entity by connecting it to a data source such as OneDrive Excel and adding a form to enter records like first name, last name, and location.

Learn to add portal forms in power apps by creating a new agent form on the agents entity, configuring quick view and main forms, and publishing changes.

Create a website view in Power Apps, add first name, last name, and location columns, then publish and sync to update the portal with the CDS structure.

Observe PowerApps Portals in action, with forms and views that update a website automatically as data changes. Build agent forms and pages that reflect backend updates in real time.