Lab 0: Validate lab environment

WWL Tenants - Terms of Use If you are being provided with a tenant as a part of an instructor-led training delivery, please note that the tenant is made available for the purpose of supporting the hands-on labs in the instructor-led training. Tenants should not be shared or used for purposes outside of hands-on labs. The tenant used in this course is a trial tenant and cannot be used or accessed after the class is over and is not eligible for extension. Tenants must not be converted to a paid subscription. Tenants obtained as a part of this course remain the property of Microsoft Corporation and we reserve the right to obtain access and repossess at any time.

Scenario

Bellows College is an educational organization with multiple campuses and programs. Many of Bellow Colleges instructors and administrators need to attend events, and purchase items. Historically tracking these expenses has been a challenge.

Campus administration would like to modernize their expense reporting system where employees submit expenses.

Throughout this course, you will build applications and perform automation to enable Bellows College employees to manage expenses.

In this Module 1 lab, you will acquire a Power Platform trial and access the Power Platform admin center. In the admin center, you will then create a Practice environment that you will perform the majority of your lab work in.

Exercise 1 – Setup

Task #1 - Verify your Microsoft Power Platform trial tenant

Verify that you have your Microsoft 365 credentials from the Authorized Lab Host available.
In a new browser tab, navigate to https://make.powerapps.com
Enter the email address provided by the Authorized Lab Host.
Select Sign in.
Enter the password provided by the Authorized Lab Host.
Optionally, select Yes to stay signed in.
If prompted, enter 0123456789 for Phone number and select Submit.
Refresh the tab and verify the Dev One environment is selected under Environment in the top right.

Exercise 2 - Import Fabrikam solutions

In this exercise, you will import the main solution into the Dev One environment.

Task 1.1 – Main solution

Navigate to https://make.powerapps.com
Make sure you are in the Dev One environment.
Select Solutions.
Select Import solution.
Select Browse and locate the FabrikamEnvironmental_1_1_11_3.zip file and select Open.

Note: This file is located in the Allfiles/Labs/ folder on GitHub repo.
Select Next.
Select Next again.
Select Continue.
Wait while connections are created.
Select Next.
Select Import.

The solution will import in the background. This may take a few minutes.

Alert: Wait until the solution has finished importing before continuing to the next step.
When the solution has imported successfully, open the Fabrikam Environmental solution.
In the solution, select the Overview page.
Select Publish all customizations.

Exercise 2 - Import data

In this exercise, you will import data the into the Dev One environment using the Configuration Migration Tool and import Outcome rows into your Microsoft Dataverse environment using a dataflow.

Task 2.1: Download and install Power Platform CLI

Download the Power Platform CLI https://aka.ms/PowerAppsCLI
Open powerapps-cli-1.0.msi to install the CLI tools.
Use the setup wizard to complete the setup and select Finish.
Open a Command Prompt.
Verify Power Apps CLI is installed.

pac install latest

Task 2.2 - Import data with the Configuration Migration Tool

Open a Command Prompt.
Launch the Configuration Migration Tool using the following command:

pac tool cmt
Select Import data.
Select Continue.
Select Office 365 for Deployment Type.
Check Display list of available organizations.
Check Show Advanced.
Select Don’t know for Online Region.
Enter your Microsoft 365 tenant credentials.
Select Login.
Choose the Dev One environment.
Select Login.
Select the ellipsis (…) menu and locate and select Fabrikam Environment data.zip file.

Note: This file is located in the Allfiles/Labs/ on GitHub.
Select Open. The data file will be validated.
Select Import Data. The import process will take approximately a minute.
Select Exit.
Select the X to close the Configuration Migration Tool.

Task 2.3 – Load Outcome Excel file to OneDrive

Navigate to the Power Apps Maker portal https://make.powerapps.com
Select the Waffle button in the upper left corner to change applications and select OneDrive. (It may take a moment for your OneDrive to be set up. Select Your OneDrive is ready when you see it on the screen.)
Select + Add new and select Files upload.
Locate and select the Outcome data.xlsx file and select Open.

Note: This file should be located in the Allfiles/Labs/ folder on GitHub repo.

Task 2.4 – Create a dataflow to import Outcomes

Navigate to the Power Apps Maker portal https://make.powerapps.com
Make sure you are in the Dev One environment.
Select Tables from the left navigation menu.
Select Import from the action menu, then select Import data.
In the Choose data source dialog, select Excel workbook.
Select Browse OneDrive. If prompted, sign in with your Microsoft 365 credentials.
Select the Outcome data.xlsx file.
Select Next.
Check the box next to Table1.
Select Next. Do not navigate away from this page.
Select the first three Do Not Modify columns. Tip: You can hold Ctrl on the keyboard and click with the mouse to select multiple columns.
On the Home tab of the ribbon, select Remove columns to remove these three columns.
Select the Estimated Completion Date column.
Right-click on the Estimated Completion Date column and select Replace values.
Enter null for Value to find.
For Replace with, enter a date in three months time. Use date format MM/DD/YYYY.
Select OK. The Estimated Completion Dates should show the date chosen.
Select Next.
Select Load to existing table.
Select contoso_outcome from the Destination table drop-down.
Under Column mapping, map Estimated Completion Date, Goal, Outcome Description, Outcome Title, and Target Aim to their corresponding destination columns.
Select Next.
Select Refresh manually.
Select Publish.

Task 2.5 – Test Your work

Navigate to the Power Apps Maker portal https://make.powerapps.com
Select Tables.
Locate and open the Outcome table.
You should see all the imported Outcome rows.
In the Maker portal, select Apps from the left navigation.
For the Environmental Project Delivery model-driven app, select the ellipsis … and select Play, signing in with your Microsoft 365 credentials if prompted.
In the left navigation of the app, select Outcomes.
The imported Outcome records should be in the view.
Select the title to open one of the imported Outcome records.
Verify the Estimated Completion Date column is set to the future date.
Verify the Outcome Lifecycle business process flow is visible at the top of the form.