Microsoft 365 PowerApps

Explore how Microsoft Power Apps, part of the Microsoft 365 ecosystem, enables low-code canvas and model-driven apps to capture, manipulate, and connect data for tasks like time-off requests.

Master Power Apps Studio to build canvas apps by inserting components, editing properties, managing screens and data sources, and publishing updates using save and publish.

Compare canvas and model driven apps, highlighting flexibility, data sources, and licensing. Canvas offers quick, low-cost entry with non-premium connectors; model driven uses Dataverse, auto-generated interfaces, and premium licenses.

Customize a SharePoint list form with Power Apps, keeping ownership with the list, and publish the form to replace the default when adding or editing items.

Create a Power Apps app with data by connecting to SharePoint, Excel, or SQL as you build; choose new or existing data tables, aware of premium connectors and licensing.

Learn PowerApps by starting with built-in templates and page designs, then customize with your data to see how apps are built and function.

Choose blank canvas from the page design, select the tablet option for flexible sizing, rename the home screen, then save and publish the app with a name.

Learn to edit a Power Apps canvas app and its SharePoint forms, access edit mode, customize forms via list settings, manage versions, and revert to default SharePoint forms when needed.

Save and publish your PowerApps changes carefully, using autosave or manual save, review version history, and restore prior versions if needed to protect live apps.

Customize a SharePoint list form in PowerApps by adding screens and navigation, while the form is owned by the list via SharePoint integration and on save or cancel actions.

Modify the form object in Power Apps by using the edit form to update records, adjust fields and layout with snap to columns, and explore visibility and advanced options.

Learn to reorder, add, and remove form fields in PowerApps by selecting the form, dragging items in the fields list, and using custom cards for spacing.

Unlock and customize PowerApps data cards in forms, adjusting visibility, data card value types such as text, drop down, and date picker, and handling required indicators and errors.

Learn how to add and customize a text box in PowerApps, including inserting a text label, resizing the form, and adjusting font, padding, color, and alignment.

Insert an image or an icon in your PowerApps screen by uploading media or linking online, then adjust size, fit, and icon color for branding.

Insert modern or classic PowerApps buttons on a screen, use icons and hover or outline styles, and configure OnSelect to show notify messages or trigger actions.

Set default values in PowerApps forms using today for dates, user().fullName for the current user, and dropdown selections, including a pending status, with form modes for new, edit, and view.

Learn to auto populate the submitted by field with the current user in a SharePoint form by creating a current user record with the claims value, email, and display name.

Learn how SharePoint integration in PowerApps uses form modes (new, edit, view) and conditional defaults to streamline data entry, including start date and submitted by fields.

Discover how PowerApps formulas power properties through static values and dynamic calculations. Use update context to set variables and reference parent values.

Explore how power apps let child objects inherit properties from their parent containers and items, and reference these properties to enable consistent colors and fonts across galleries and forms.

Leverage date functions in Microsoft 365 PowerApps to generate and adjust dates with today, now, date, year, month, day, and date add from a date picker.

Format dates and numbers in PowerApps with text functions and value function, enabling currency formatting and flexible date representations.

Learn how to use the lookup function in Microsoft 365 PowerApps to retrieve a single related item from a data source, match id values, and replace brittle first filter approaches.

Learn how the set function creates a global variable for use across the app. Then explore update context for screen-specific variables and compare when to use global versus screen-scoped variables.

Change the app name and icon in Power Apps settings, add a description and logo, and enable auto save for reliability.

Change your app's size and orientation in PowerApps by selecting portrait or landscape, choosing custom dimensions, and using containers to preserve layout when embedding.

Explore how to manage PowerApps updates and advanced settings, including new, preview, experimental, and retired features, modern controls and themes, explicit column selection, analysis engine, copilot, and PDF function.

Create and manage screens in Power Apps using the tree view or new screen commands. Learn to duplicate, rename, reorder, set the start screen, and understand when to delete carefully.

Explore how containers in PowerApps organize content into flexible boxes, enabling horizontal and vertical stacking, responsive layouts, padding, and scroll capability for popups.

Learn to connect multiple data sources in Power Apps, manage data types, and refresh data sources to keep SharePoint lists and other sources current, using Office 365 users and Outlook.

Create and manage in-app collections to hold data, streamline updates, and bypass repeated data source access, using collect, clear collect, add columns, and delegation considerations.

Learn how app formulas replace on start clear collect with named formulas and collections that auto refresh as data changes, improving startup speed and performance.

Clarify delegation in PowerApps, showing how data sources like SharePoint, SQL, and Dataverse perform queries within 2000 items and how non-delegable queries risk incomplete results.

Add and customize galleries in Microsoft 365 PowerApps, choose vertical, horizontal, or flexible height layouts, bind to a data source, tailor fields and item properties, and configure navigation and filtering.

Explore the modern table in PowerApps, with data source setup, sortable columns, and adjustable widths, and note the older data table's limitations and the option to add custom columns.

Learn to filter and sort data sources in PowerApps galleries and tables using filter, sort, and sort by columns, with delegation considerations and practical tips for named formulas and columns.

Learn to create and customize PowerApps forms, choosing between modern and classic forms, select a data source, manage fields, and consider patch for data submission.

Explore how to add and configure input controls in Power Apps, including text inputs, combo boxes, and dropdowns, to filter and search data from your sources.

Navigate between screens in Microsoft 365 PowerApps using icon buttons and navigate actions triggered by selections. Manage access by applying visibility rules tied to the approvers list.

Share your PowerApps with teammates using the share feature or classic sharing, manage access, assign users and co-owners, and ensure underlying data sources are shared.

Learn how to embed a Power Apps app on a modern SharePoint page using the Power Apps web part, with web link or app ID, resizing, and full-screen launch.

Use query strings and the param function to direct PowerApps to screens, hide the nav bar, and open records from direct email or SharePoint links.

Export and import a PowerApps package to manage versions and move apps between environments. Understand updating, creating as new, removing embedded flows for smoother migrations, and migrating list forms.

Manage app versioning by viewing and restoring previous versions in the details and versions tabs, and monitor usage with Power BI analytics and live monitor to diagnose performance.

Explore Power Apps basics, including canvas and a hint of model-driven, while learning to create and modify SharePoint list forms, build data sources and components, and distribute apps.