Microsoft Powerapps Essential Training 2021

Explore the common data service for apps as a secure, SQL Server backed data source for power apps, featuring security roles, business rules, and entities.

Create a new CDS environment and database, then explore the common data model's prebuilt entities, fields, and relationships; define business rules and keys, and review data security.

Create a custom entity in the Power Apps web portal to track pet services. Understand that an entity is a set of records like a database table, with attributes.

Add and customize fields for an entity in Powerapps, creating custom fields, renaming display names, and configuring an option set for species and an appointment date.

Import Excel data into CDS using the Power Apps workflow and publish changes to reflect in Power Apps Studio; or use the Power portal to get data from Excel.

Create a many-to-one relationship from the account entity to a custom entity in Power Apps, then confirm the relationship is saved and the account field appears automatically.

learn to create and activate business rules in cds, defining conditions such as species equals dog and cat and applying business required actions at the entity level for consistent governance.

Learn how to customize a view using the view designer, add and remove columns, arrange them by drag and drop, and save and publish changes to reflect updates.

Learn to customize the main form in Microsoft Powerapps by using the form editor, choosing a tablet layout, adding fields like species, appointment date, and account, then save and publish.

Create a canvas app using CDS by connecting to a custom entity pet, configure fields, preview data, add a new record, and save the app to the cloud.

Enroll in SharePoint by selecting a plan at products.office.com, and subscribe to Office 365 or Dynamics 265 subscriptions to start using SharePoint as a data source.

Establish a data connection between a SharePoint Online list and Power Apps by creating a SharePoint list, adding columns, and configuring data connections in the Power Apps Studio.

Create a canvas app in Power Apps by connecting to a SharePoint list, then preview in the browser to verify data from the list and refine functionality.

Explore and customize the browse screen by selecting elements and mapping fields to a SharePoint data source. Configure layout options and advanced properties to control what data appears.

Learn to change a Power Apps formula by concatenating first name and last name with a space using the formula bar and ampersand, via advanced properties.

Reorder form fields on a SharePoint list by dragging them into the desired sequence, adjust the layout to a two-column design, and expand fields to enhance the app's appearance.

Change the display mode of fields in Power Apps to toggle editability, turning most fields into read-only and keeping department and start/end fields editable, with a preview.

Change search fields in a PowerApps app by adjusting filters and using the formula bar to search by title or first name, then preview results.

Delete the plus icon, move the refresh button left, and adjust the app name for readability; verify changes reflect in the SharePoint data source.

Save your power app by selecting save, name it, choose a color and icon, and add a description. Then share with colleagues and run or test the app to stakeholders.

Download the exercise files, locate the included Excel workbook, format the table in that workbook, and use the worksheet as your data source in the next module.

Format Excel data as tables and name them, then upload the workbook to the Power Apps environment to use Excel as the app’s data source for a hotel review app.

Connect Power Apps with OneDrive for Business by creating a new data connection in Power Apps Studio, authenticating with your account, and building an app based on this established connection.

Connect a canvas app to an Excel data source, selecting the restaurant review table, then customize fields such as restaurant name, customer name, and overall rating, and adjust the title.

Edit a detail screen in Power Apps by unlocking fields, cleaning display text, and adding a comments field. Resize cards, connect fields, and adjust display mode for a clean form.

Refine the edit screen in PowerApps by reordering fields, tightening the layout, and changing the comment field from single-line to multi-line text for easier writing.

Connect additional data sources in Power Apps by adding connectors to an Excel workbook and its data tables to create drop-down menus and surface live restaurant data.

Add a drop-down menu to your Power Apps app and connect it to your data. Set the default for food type and restaurant rating to blank to control user input.

Connect the dropdown to the food underscore time data source using the formula bar, preview, fix warnings, and bind the selected value to pull data and export to Excel.

Arrange data cards and add a dropdown in powerapps by dragging, resizing, and renaming controls; map the dropdown to restaurant data in the formula bar.

Learn to manage versions in Power Apps by loading the app, selecting a team, saving, viewing previous versions, and publishing the latest version to go live.

save, name, publish, and share a PowerApp with colleagues by entering names or emails, then run and test the app to validate its functionality.