Microsoft Power Apps Foundations A-Z

Sign in to Power Apps with an enterprise or school account, or create a free Microsoft developer account for a 90-day trial of premium features across the Microsoft suite.

Create an Excel table called 'students' for Power Apps, connect via OneDrive or Google Drive, and use Mukuru.com data to populate fields such as first name, last name, and gender.

Connect to OneDrive by signing in and selecting the students table to build a data source in Power Apps. The next lecture covers Google Drive setup and an app tour.

Connect to Google Drive as a data source in Power Apps, sign in, grant access, and automatically create a basic app from the students Excel document.

Save your canvas style power app to the cloud, explore a live student list with search, edit, add, delete, and sort, using an Excel data source to learn Power Apps.

Publish power apps to mobile and tablet, login, and view students list on any device; edit records and refresh data from the Excel document stored on drive or Google Drive.

Take the canvas tour in Microsoft Power Apps Foundations A-Z to navigate screens, inserts, data sources, media, and debugging tools, then customize properties, triggers, and themes for a mobile app.

Create a campus app quickly by using Excel to auto-generate a functional Power Apps interface, then view and search student information such as name, email, and contact details.

Adjust the landing screen by using the press gallery layout as title and subtitle, and map first name, last name, and email from the Excel table via the formula bar.

Learn how to use Power Apps formulas to combine first and last names in a gallery, using concatenate and spaces, with tips for referencing items and exploring documentation.

Wire gallery items in Power Apps to navigate on select to the edit screen. Use the edit form in edit mode with an edit icon and explore screen transitions.

Reorder fields on the details screen and update the heading to reflect the current student’s name. Use data card defaults and concatenation to display dynamic headers, with email links.

Learn to update the edit screen by ordering fields through the edit fields properties, placing first name, last name, email, and agenda in the desired order.

Set the next ID automatically for new records in an Excel data source, making the ID read-only to prevent duplicates and ensure unique identifiers.

Set fields as required and validate email addresses using the esmat function with predefined patterns to ensure only valid emails pass, preventing form submission when invalid.

Prevent form submission for invalid emails by using an if statement on select submit; submit when the email matches a valid address, otherwise do nothing, with a visual validation cue.

Explore the Power Apps interface, edit your first app, and use a pre-built reference to learn navigation between screens with button selections and the Formula Bar.

Build a real estate canvas app from scratch in Microsoft Power Apps, enabling viewing, adding, and creating listings with Bing Maps showing GPS coordinates in real time.

Create a canvas app named Real Estate, set a header with a rectangle and title, choose an icon, and establish a template screen as the master for duplicating future screens.

Duplicate the template to create a home screen, rename and title it, add two buttons for view listings and add listing, use white text and font size 36.

Streamline listing displays in Power Apps by building a vertical gallery linked to an Excel table on OneDrive, including bedrooms, bathrooms, car spaces, address, price, and agent ID.

Practice navigating from the home screen to the view listings screen using the navigate function, add a home icon in the top left, and apply a transition animation between screens.

Add a searchable gallery by renaming the input to search input, using the search function on the Excel table of listings, and configuring searchable columns to filter real estate listings.

Add a bedroom filter to listings by introducing a top dropdown and a Power Apps filter formula to the gallery, enabling dynamic filtering of properties by bedrooms.

Create a detail screen by duplicating a template, connect to the listings table on OneDrive, and navigate from the listings gallery to a read-only detail view with a back button.

Display a listing’s location on a map using latitude and longitude, enable geospatial services in the admin center, and bind default coordinates to the map for dynamic listing navigation.

Add a pin marker to a map component in Power Apps by creating a one-row table with name, latitude, and longitude, and binding it to the map's items.

Master editing and creating listings in Power Apps by duplicating the listing template, binding a form to data, and adding save and navigation controls for edit and new records.

Learn how to fix the new record bug in a banking app by adding a back navigation after saving a listing to prevent loading the previously viewed item.

import agent table from OneDrive or Google Drive into Power Apps and create a view agents screen with a data table listing id, first name, last name, email, and phone.

Display agent names on the listings details screen by looking up the agent in the agents table, concatenating first and last names, and binding the result to the UI.

Wrap up Power Apps foundations by building a canvas app from scratch with no code, using Excel-like formulas, and leveraging the Power Apps community for solutions.

Explore model-driven apps in Power Apps with prerequisites and the Common Data Service, then build a real estate listings model-driven app to compare with canvas apps.

Explore the common data service as a cloud database for model-driven apps. Load data from Excel, SharePoint, or Salesforce, and use tables, columns, records, relationships, metadata, and business rules.

Explore entities as the core data tables in common data services, using prebuilt account entities and tailoring fields like account name, number, data types, and which are required or searchable.

Explore relationships in a common data service, including one-to-many, many-to-one, and many-to-many, illustrated with products and reviews, listings and agents, and the joining table in Power Apps.

Explore business rules in Microsoft Power Apps Foundations A-Z, enforcing Australia restrictions in the Common Data Service with conditions, actions, and error messages to guide data entry.

Explore views and forms in model-driven Power Apps, filtering active accounts and displaying key fields, while using out-of-the-box components and forms libraries to create and update records within your app.

Explore dashboards and charts in model driven apps, including creating a two-column dashboard, adding components, and using chart creators similar to Excel to visualize cases, accounts, and agents.

Explore the data tab by viewing and creating account records using the account form, honoring required fields, saving and refreshing to see multiple records in the Common Data Service.

This introductory lecture shows how to create a listings entity in the Common Data Service. Import data from spreadsheets and design views, forms, and business rules for real estate listings.

Create a new entity for listings within the Common Data Service, set a unique display name as the primary field, and review default fields like who created and last updated.

Add a bedrooms field to listings entity, choosing a data type such as text, text area, or number and marking it as recommended. Save the entity after adding the field.

Configure listing fields in a Power Apps entity, including beds, bathrooms, car spaces, price as currency, street, post code, country, and latitude and longitude; set data types and constraints.

Upload an Excel listing sheet, map its columns to the listings entity, and import the data into Common Data Service, creating records with id, bathrooms, bedrooms, price, latitude, and longitude.

Create and customize views in model driven apps by adding columns, applying filters, and reordering fields, then save and publish to make the view live for users.

Edit the main form for a listings entity, adding fields like bedrooms, bathrooms, and address details, then publish and use the data tab to create or edit records.

Learn how to create and activate a centralized business rule in Microsoft Power Apps to prevent listings with more than 10 bathrooms, including error messaging and field validation.

Review the model-driven app setup by applying the built views and entities as building blocks, plug them into the app, and reuse the foundation to create multiple model-driven apps quickly.

Learn to build a model-driven app in Microsoft Power Apps by connecting entities from the Common Data Service, enabling rapid development for real estate agents.

Set up a listeners entity with data and custom business rules for forms, then create a new model-driven app and customize its name, description, and icon.

Explore editing and adding an entity in a model-driven app, linking from the sitemap to listings, configuring forms, views, charts, dashboards, and access controls.

Create a sitemap in a model-driven app by defining areas, groups, and sub-areas tied to entities and views, then publish, run, and view updated forms and dashboards.

Configure a listings view by selecting my view, publish and play to see the default restricted view, then use search, filters, and column controls with non-overridable settings.

Edit the map to add links for real estate and domain websites, creating a new research area with a links group, then save, publish, and play to test navigation.

Explore the benefits of the Common Data Service for model-driven apps, including centralized data, security controls, reusable building blocks, and seamless integration with Dynamics 365 and Power Automate.

Finish the Microsoft Power Apps Foundations A-Z course by applying canvas and driven apps, loading data, and deploying without coding for personal or organizational use.