Microsoft Power Apps and Power Automate : A Complete Guide

Create your first Google Sheets connection in PowerApps, granting access and permissions to load data from the spreadsheet and manage the connection from the data tab.

Create a Google Sheets spreadsheet named employee details and load its data into a Microsoft Power Apps app by starting from data, connecting to the sheet, and auto-generating an app.

Discover how to structure a PowerApps app and apply basic customizations, including adjusting titles, fonts, colors, and themes, managing screens and components, and using undo/redo and the insert data options.

Select and remove icons, hide them with visibility settings, and change icons using the built-in icon library. Rotate, reposition, and style borders and colors to customize your PowerApps.

Learn to view PowerApps previews in full screen, test app functionality, add addresses, sort lists, and search entries on the canvas.

Learn to change the alignment of data in PowerApps forms by reordering fields such as first name, last name, and country, customize arrow colors, and undo changes.

Learn to adjust basic Power Apps settings by naming the app, selecting an icon and color, adding a description, and setting orientation.

Save your PowerApps to the cloud using save as, manage versions, view and share the app within your organization, and optionally download a local copy for offline use.

Add new entries to your Google spreadsheet and refresh your PowerApps data source to automatically update the app with the latest data.

Create a new screen in a PowerApps app, customize titles and labels, add elements like labels, buttons, and images, then preview and publish your screen.

Create a new flooring app in Power Apps by converting an Excel file into an auto-generated app with Google Sheets data, displaying category, name, price, image, and editable details.

Learn how data cards power PowerApps forms, with each field becoming a data card. Unlock and customize cards via the right-hand panel, but relocking is not allowed.

Add a home icon to the flooring app and link it to the organization’s home page URL with a launch function. Preview to confirm it opens the home page.

Apply an if conditional in PowerApps to control price color. Build a formula that makes the price red if less than eight dollars, using data card value and color property.

Learn to add a video to a PowerApps flooring app without coding by creating a new screen and inserting a video control linked to a YouTube URL.

Select a background image for the app, adjust its fit, and ensure the label is visible by white color and larger font; add a video, then save and publish.

Learn to add a ratings control and a reviews input in your Microsoft Power Apps flooring app, and customize background, title color, borders, and layout.

Learn to make ratings and reviews controls functional in Power Apps by building a rating-based formula that prompts for feedback and captures user reviews.

Create a functional popup discount message in a PowerApps app by adding an information icon, a discount text, and a cancel control, using formulas to show and hide the message.

Create interactive popup messages in Power Apps by building formulas for the information icon and the close button, toggling the dialog via visible properties and binding to a group.

Create an Office 365 E3 trial account and sign in to access SharePoint Online and Power Apps, then use a SharePoint list as a data source for your app.

Learn to create a SharePoint site from scratch within a Microsoft 365 environment, configure privacy and members, and connect SharePoint as a data source for PowerApps.

Create a SharePoint list using templates, such as contacts template, then customize columns like last name, first name, company, business phone, home phone, and email, and connect it to PowerApps.

Create a SharePoint connection in PowerApps by linking to a SharePoint Online site and list, then add the connection for app development.

Build a Power Apps app from a SharePoint list by connecting to SharePoint in Power Apps Studio, selecting the site and list, loading data, customizing fields, and saving the app.

Export canvas apps as packages from one Power Apps account and import them into another, configuring as new apps and reconnecting data sources such as Google Sheets.

Build an intermediate Power Apps app from a SharePoint list sourced from Excel, managing intern records with department, start and end dates, and saving updates to SharePoint.

Upload an Excel file to a new SharePoint site, convert the data into a table, and create a SharePoint list to power your apps with Power Apps and Power Automate.

Create a data connection to a SharePoint list in Power Apps Studio by linking the Interns List built from Excel, then load and preview the app from this data source.

Add the missing end date field to the details and edit screens in a PowerApps app by using the detailed form and edit form, adjusting fields in the screen layout.

Customize the browse screen in Microsoft Power Apps by editing the browse gallery to display schools and majors instead of names, improving app clarity.

Learn how to customize a Power Apps app by modifying the function formula to display interns' last names beside their first names, using the formula bar and advanced options.

Reorder the Power Apps detail screen with drag-and-drop fields, resize cards, and display data in two columns, then adjust spacing for a cleaner layout.

Unlock the detail screen cards in Power Apps, edit display names to insert spaces for fields like email address, phone number, start date, and end date, ensuring permanent screen changes.

Customize the edit screen with two columns, remove email addresses and telephone numbers, and set non-editable fields to view only while department, start date, and end date remain editable.

Unlock the title card, rename 'title' to 'first name', update the display name, and apply the same change on the order screen to clarify the first name field.

Change the sorting preference in Power Apps by previewing the app, using the smart list to toggle order, and editing the browse gallery formula to sort by title, school.

Change the search preferences in PowerApps from title to major to let managers find interns by department.

Learn how to remove the create new item icon in a Microsoft PowerApps app, so only managers can set interns' start and end dates via a SharePoint list.

Test and validate a fully functional intern list app built in Power Apps, demonstrating refresh, sorting, search, and browser editing with department and start date and end date fields.

Save the internal selection app by naming it, selecting an icon and color, adding a description, then choose cloud or local save and set sharing permissions.

Learn to create a PowerApps project from a template, explore all versus office templates, and build a budget tracker with sample data in phone and tablet layouts.

Create a budget tracker app from a template, configure a OneDrive for business data source, and save to Power Apps to store data and the Excel file.

Open the OneDrive for business Excel file to see how budgets, expenses categories, and expenses by category feed the budget tracker app.

Delete sample data from budget tracker by clearing entries in the Excel data source and in expense, recipes, and expense by category tables, then refresh data sources to reflect changes.

Preview and understand how the budget tracker app works, viewing projected, spent, and remaining amounts across cards and pie charts. Add, delete, and manage expenses, budgets, and categories.

Learn to customize a budget tracker in Power Apps by adding budgets, amounts, categories, and expenses from an Excel data source, and refresh data to reflect updates.

Refresh data connections in Power Apps to sync an Excel budget tracker, then customize budgets, categories, expenses, and visuals including the pie chart and updated titles.

Save the modified budget tracker app by creating a version with an update note, then publish the changes to make them available in the application.

Learn to customize your Power Apps by changing the app icon, background color, and description, configure screen size and orientation, save and publish for organization-wide access.

Preview the final look of the home studio budget tracker app built from a Power Apps template, now customized to manage budgets and equipment in a browser.

Create a PowerApps customer app from an Excel file by uploading to OneDrive for business, linking a OneDrive data connection, selecting the Excel table, and saving and customizing the app.

Master property handling in PowerApps by comparing static and dynamic methods, applying formulas to galleries, forms, and data cards, and using data sources to build responsive layouts.

Explore galleries in Microsoft Power Apps, customize layouts and the visible property, and use the concatenate function to display first and last names from your data source.

Explore how to customize the detail screen in PowerApps by working with forms and data cards, reordering fields, unlocking cards, and using the display name formula to add spaces dynamically.

Explore how to format dates in PowerApps with the text function to remove timestamps and customize date displays.

Set app titles dynamically in Power Apps by concatenating first name and last name from data cards using the concatenate function, reflecting the selected user on the detail screen.

Master the edit form layout in Power Apps with data cards, submit and cancel icons, and validation. Reorder fields like first name, last name, customer number, location, and date joined.

Learn how the update property on data cards in the edit screen submits and updates data using the submit form, with practical examples.

Learn to remove timestamps from the edit screen in Microsoft Power Apps, fix errors, and set passport number and customer number to view-only by adjusting data card display modes.

Discover how triggers in Microsoft Power Apps drive actions like submit, reset, and navigate by reacting to on select and on change events, and learn how triggers differ from properties.

Learn how to access and use the Microsoft PowerApps formula reference, explore formulas and functions, and apply text and concatenate functions to display dates in your app.

Demonstrates how to use the month and year functions in PowerApps to display only the month and year from a date column, with practical formula steps and examples.

Explore how to use the navigate function in PowerApps to switch screens and apply transitions. Understand how the back function remembers last location to return you to the previous screen.

Learn to use the app checker in Microsoft PowerApps to identify and fix errors, navigate to the exact element, and leverage guidance and Stack Overflow for solutions.

Publish the final changes to the custom app and review the browser view, date picker, and submit button as the intermediate PowerApps canvas apps section ends.

Create an advanced canvas app from scratch using a master screen and a documentation screen, configuring a tablet layout, saving progress, and centralizing properties across screens.

Learn to customize a documentation screen in power apps by adding and styling elements, setting font size and center alignment, renaming controls, and propagating title properties for consistent sizing.

Duplicate the master screen to create a home screen, then add and customize buttons in Microsoft Power Apps, including icon usage, color settings, dynamic properties, and cross-screen references.

Duplicate the screen, add a new customers view with a vertical gallery, and connect to a OneDrive Excel table to display first name, last name, location, and VIP level.

Learn to add and customize screens, set up navigation between home, view customers, and add new customers using on select navigate, and add a home icon for back navigation.

Explore variables in PowerApps with a hands-on example that sums two text inputs and learn why PowerApps often uses static references instead of separate variables.

Explore the PowerApps variables—contextual, global, and collection—and see how contextual variables differ from global ones in demos. Learn to set values with update context and implement a counter across screens.

Convert contextual variables to global variables in PowerApps to share data across screens, using set(variable, value) and understanding the syntax differences between contextual and global variables.

Learn to create and use collection variables in PowerApps, using collect on select to store multiple records with columns, and display them in a gallery or data table.

Make a Power Apps collection dynamic by adding records with text inputs, display title and subtitle in the gallery, and remove items with a trash icon using the remove function.

Add a dynamic search bar in Microsoft Power Apps to search by first name, last name, or location using a text input and gallery.

Learn to customize a search bar in Microsoft Power Apps by adding a search icon, toggling visibility with a variable, and enabling searches by first name, last name, and location.

Learn to use filter functions in PowerApps with a dropdown to filter data by VIP levels, and connect the filter to a gallery with a search bar.

Create a detail screen linked to the data source using a display form and gallery to show selected customer details with navigation and a fade transition.

Create an edit screen in Power Apps using an edit form, connect to table one, add fields, and implement a submit form button to update customer data.

Add navigation between the details and edit screens in a PowerApps app using an edit icon with on select navigate to the edit screen and a back arrow to return.

Create a new customers screen in Power Apps. Use an edit form set to new mode and implement a back action to return to the home screen.

Learn to validate user input in PowerApps with the IsMatch function, enforcing text-only entries, displaying a red error label when digits slip through, and configuring pattern options.

Explore data validation in Power Apps by using a validation button and a variable to control submit button visibility, preventing numbers in a name field and guiding proper input.

Learn how to implement data validation in Microsoft Power Apps using variables to control submit button visibility, prevent invalid input, and show validation errors.

Convert the agent data into a table with headers in Excel and upload it to OneDrive. Then connect PowerApps to this second data source using connectors.

Create an agent screen in Power Apps by adding a data table connected to multiple data sources, configuring name and phone columns, and enabling quick calling and navigation.

Learn how to use the lookup function in Microsoft PowerApps to link data from multiple sources, retrieve an agent's phone number on a details screen, and make calls directly.

Learn to add a clickable call button in Power Apps that dials a dynamic agent number using the launch function and a tel URL.

Reorder screens in an advanced canvas app to set the home screen first, publish the final version, update the icon, and preview the app in Power Apps.

Explore how the user function in Power Apps fetches current user details such as email, full name, and image. Use it with conditional logic to tailor screens for different users.

Discover the now and today functions in PowerApps to display current date and time or just the date, with practical demos for dynamic data and time-based content.

Learn to group elements in PowerApps to simplify moving and styling, create custom groups of labels and buttons, and apply shared properties dynamically across grouped items.

Explore the launch functionality in Microsoft PowerApps to open web pages, call or email apps, and launch context-specific resources from buttons and icons.

Learn to use the launch function in Microsoft Power Apps to initiate calls, send emails, and send images from buttons, detailing phone and email parameters and on select configurations.

Learn to launch other apps from your current PowerApps canvas app by pressing a button, using the launch function, copying the target app's ID, and building the correct launch formula.

Master cascading dropdowns in Power Apps using distinct for unique locations and sort by column for alphabetical order, then filter by location and VIP level to drive a data table.

Learn to build cascading dropdowns in Power Apps by filtering a data table with location and VIP level selections, using distinct and sort by columns to display unique, ordered results.

Learn to build cascading dropdowns in Power Apps by linking two dropdowns to filter VIP levels based on the selected location.

Add a delete button in Power Apps that removes the selected record from table one using the remove function, with on select handling and navigate back to the previous screen.

Learn to add a confirmation popup in PowerApps to prevent accidental deletions, using a Yes/No dialog, a darkened background, and a context variable to control visibility.

Learn how the combo box input control in PowerApps provides searchable drop-down lists, supports multiple selection, and filters tables by connecting to a data source.

Explore how to use the date picker in PowerApps to select and display dates, customize its default and selected dates, and bind its value to a label for dynamic updates.

Use the toggle control in PowerApps to manage true/false states and UI visibility, including binding the toggle value to a label and the dropdown visibility.

Learn to add a slider in Power Apps, set min and max values, and bind the slider to a label and to a rectangle’s opacity for live visual feedback.

Explore ratings and timer controls in Microsoft PowerApps, using star-based rating with adjustable maximum values and a timer to trigger actions, popups, or visibility based on elapsed time.

Discover the common data service as the foundational cloud data source for Power Apps, offering entities, security, Dynamics 365 integration, and business rules to drive reliable apps.

Set up the Common Data Service environment by creating a new environment, selecting region and trial plan, and provisioning a database with sample data and English language settings.

Learn how Common Data Service entities use preset templates and lookups, view the account entity fields, and add new entities to customize data in Power Apps.

Explore the fields and data types in the common data service, distinguishing standard and complex entities, and learn how server-side logic and data types drive storage.

Learn relationships in Microsoft Power Apps' Common Data Service, covering many-to-one, one-to-many, and many-to-many links between accounts and users. See how created by columns reference user table to model data.

Apply Power Apps business rules to implement logic without code in Common Data Service, setting field values, requirements, visibility, enablement, and validation with error messages across canvas and model-driven apps.

Define views in the Common Data Service to tailor data access for different users. Configure an active accounts view that shows a limited column set.

Learn how to create and edit records with forms in model-driven apps, using account templates, and explore data, dashboards, and charts within Power Apps fundamentals.

Create a new customer entity in Power Apps to store data from an Excel list, configure a unique name and customer number as the primary field, then provision it.

Add new fields to the customer entity in Power Apps using the add fields button, choose text data type, make searchable, and set fields as optional, recommended, or required.

Create a new last name field and a calculated full name field in an entity, using the concatenate function to display first name plus last name in Power Apps.

Switch between environments using the top environment selector to ensure your entities and data display from the correct environment, resolving visibility issues and keeping your Power Apps data organized.

Add remaining fields to the customer entity in Power Apps, including VIP level, date joined, location, passport number, and agent name, then save and review the updated entity.

Upload and map data from an Excel file into the customer entity, import the table, and verify results in Power Apps by connecting to a data source.

Explore viewing customer data in the common data service and fix the full name column by editing the calculated rollup formula to insert spaces between first and last names.

Create custom views in PowerApps to display selected customer data, filter by VIP level, sort by VIP level, and publish views within the Common Data Service.

Learn to create a new custom form in Power Apps for the customer entity, add fields and sections, set layouts and visibility, and publish changes.

Explore how to use Power Apps forms to add new records and edit existing ones in the customer entity, including fields like number, date changed, passport number, and VIP status.

Create and apply business rules in Microsoft PowerApps, using drag-and-drop conditions on the customer entity to enforce rules and show error when vip level is five and location is Singapore.

Create, save, and publish business rules in CDS to trigger conditional logic and VIP level checks, affecting location-based form data in Power Apps and Power Automate.

Explore additional common data service features, including data flows for automatic data loading into entities, and discover connections, gateways, and forms and views for enterprise Power Apps.