Practice Lab 5 – External data

In this lab you will add an external data source.

What you will learn

In the Power Apps maker portal, https://make.powerapps.com select the App launcher in the top left of the browser window and then select SharePoint.
If the Welcome to SharePoint Start Page popup dialog is displayed, select ✖ to close the dialog.
In SharePoint, select + Create site.
Select Team site, select Standard team template, and select Use template.
Enter Pet boarding for Site name and select Next.
Select Create site.
Select Finish.
If the Start designing your site pop-up dialog is displayed, close the dialog.

In the SharePoint site, select + New and then select List.
Select List under Create from blank.
Enter Bookings for Name and select Create.
Select + Add column, select Text, and select Next.
In the Create a column pane, enter or select the following values:
1. Name: Pet Name
2. Data type: Single line of text
Select Save.
Select + Add column, select Text, and select Next.
In the Create a column pane, enter or select the following values:
1. Name: Owner Name
2. Data type: Single line of text
Select Save.
Select + Add column, select Date and time, and select Next.
In the Create a column pane, enter or select the following values:
1. Name: Start Date
2. Data type: Date and time
Select Save.
Select + Add column, select Date and time, and select Next.
In the Create a column pane, enter or select the following values:
1. Name: End Date
2. Data type: Date and time
Select Save.
Copy the first part of the URL of the SharePoint site, for example https://m365x99999999.sharepoint.com/sites/Petboarding/

Navigate to the Power Apps Maker portal https://make.powerapps.com
Make sure you are in the Dev One environment.
Select the Apps tab from the left navigation menu.
Select the Booking Request app, select the Commands (…), and select Edit > Edit in new tab.

In the app authoring menu, select Data.
Select the drop-down caret next to Add data and enter SharePoint in Search.
Select SharePoint.
Select Connect directly (cloud services) and select Connect.
Enter the URL of the SharePoint site you created earlier in this lab.
Select Connect.
Select Bookings.
Select Connect.

In the app authoring menu, select Insert (+).
Select Vertical gallery.
Select Bookings for data source.
Select Title and subtitle for Layout.
Select 6 selected next to Fields
Select Pet Name for Title3.
Select Start Date for Subtitle3.
Close the Data pane.
In the app authoring menu, select Tree view.
Rename the gallery to BookingList.
Set the properties of the gallery in the formula bar as follows:
1. X=1000
2. Y=80
3. Height=575
4. Width=250

In the app authoring menu, select Tree view.
Expand BookingRequestList.
Select NextArrow.
Set the OnSelect property of NextArrow in the formula bar to:
```
 Collect(colRequests, ThisItem)
```
In the app authoring menu, select Tree view.
Select the App object.
Set the OnStart property in the formula bar to:
```
 Clear(colRequests)
```

In the app authoring menu, select Tree view.
Select BookingRequestList.
Select the pencil icon in the top-left of the gallery control.
In the app authoring menu, select Insert (+).
Expand Icons.
Select Blocked. The icon will be added to each row in the gallery.
Set the properties of the icon in the formula bar as follows:
1. X=150
2. Y=40
3. Height=30
4. Width=30
In the app authoring menu, select Tree view.
Rename the icon to DeclineIcon.

Set the OnSelect property of DeclineIcon in the formula bar to:

 Patch('Booking Requests', ThisItem, {Decision: 'Decision (Booking Requests)'.Declined})

In the app authoring menu, select Data.
Select the drop-down caret next to Add data and enter Office 365 in Search.
Select Office 365 Users.
Select Connect.

Select outside of the gallery on the blank canvas, or select the MainScreen on the Tree view.
In the app authoring menu, select Insert (+).
Select Text label.
Drag the label to the top right of the screen next to the UserLabel.
In the app authoring menu, select Tree view.
Rename the label to UserDetailsLabel.
Set the Text property of UserDetailsLabel in the formula bar to:
```
 Office365Users.MyProfile().Country
```
Set the properties of the label in the formula bar as follows:
1. X=930
2. Y=20
3. Size=18
4. Color=Color.White
Select Save in the top-right of the Power Apps Studio.
Select the <- Back button from the top left of the command bar, and select Leave to exit the app.