In this video series you will learn how to work with SharePoint and Power Apps. The following 5 videos are included in this series:
Learn Power Apps - https://www.youtube.com/watch?v=BnYe_7fpZRM
SharePoint Custom Forms Power Apps - https://www.youtube.com/watch?v=Badj3_T8zAw&t=1s
Patch SharePoint Columns - https://www.youtube.com/watch?v=gsk14D-CYRE&t=2s
SharePoint Columns vs. Power Apps - https://www.youtube.com/watch?v=mwXnJUkTug0
SharePoint Approval Flow - https://www.youtube.com/watch?v=3shHcIgjxH4
Working with SharePoint Learn Power Apps If you are new to Power Apps, this is the video for you! In Shane’s Power Apps with a SharePoint List – Learn Power Apps Tutorial video, he demonstrates how to use Power Apps to create an app with SharePoint as the data source. You will learn how to build your first Power Apps app and perform customizations to the different screens, columns, fields, and more. This video lays the groundwork for being able to make more complex Power Apps.
Key Timestamps:
0:00 Intro
1:09 Create a new phone layout SharePoint app
3:54 Preview the app
5:14 Access the data controls in order to be able to edit the app
6:24 Modify the color column with the ColorValue function
9:10 Sort the screen by a different field using the SortByColumns function
10:26 Modify the fields in the editscreen
13:09 Overview of app settings and save the app
14:43 Preview of the app on mobile
SharePoint Custom Forms Power Apps Create a better experience for your users by building and utilizing a custom SharePoint list form in Power Apps. In Shane’s Custom SharePoint List Form with Power Apps video, he demonstrates how to use Power Apps to get started with customizing SharePoint list forms. This video lays the groundwork for building more complex list forms in future videos. You’ll learn how to edit fields, add a button, and more. Shane also covers the SharePoint Integration capability.
Key Timestamps:
0:00 Intro
1:30 Create a new custom form in Power Apps, and save and publish the app to SharePoint
4:28 Walkthrough of different form modes
6:33 Hide unnecessary fields in the form via the Visible property
9:14 Refresh the SharePoint page to show new changes
10:45 Document changes made in a new screen
12:19 Add a button to the form that sends an email via the Office365.SendEmail connector
16:44 Overview of licensing and permissions
17:45 Overview of how to delete a custom form
Patch SharePoint Columns If you use SharePoint as a data source, you have likely encountered problems at some point while working with person, choice, and lookup columns. In Shane’s Power Apps SharePoint Complex Columns – Patch person, choice, and lookup fields video, he demonstrates how to directly patch complex column types in Power Apps using the Patch function. In this video, two approaches for patching each complex column type are shown: an intermediate way and a more advanced way. The intermediate way for patching columns is done with either a Drop down or Combo box control. The advanced way for patching columns is done with just a button.
Key Timestamps:
0:00 Intro
1:42 Demo of the solution
3:43 Patch a choice column via a Drop down control– intermediate
6:12 Patch a choice column – advanced
7:19 Patch a lookup column via a Combo box control – intermediate
8:58 Patch a lookup column – advanced
10:51 Patch a person field via a Combo box control – intermediate
12:04 Patch a person field – advanced
14:06 Patch a multi select choice column via a Combo box control – intermediate
15:32 Patch a multi select choice column - advanced
17:11 Patch a current user and an additional user into a multi people field
SharePoint Columns vs. Power Apps Do you use SharePoint columns as a data source for your Power Apps? When creating custom SharePoint lists, there are a few things to keep in mind that will make your life easier in the long run. In Shane’s Understanding SharePoint Columns and Power Apps video, he demonstrates how to create and name SharePoint columns. In order to avoid confusion in Power Apps, all SharePoint columns should be initially named without using any spaces. Shane also recommends that if you are creating a SharePoint list to be a data source only for a Power App, that you use the single line of text, number, and date and time columns. Keep in mind that column types matter when creating your SharePoint lists!
Key Timestamps:
0:00 Intro
1:08 Create a SharePoint custom list and name the column
2:51 Rename the ‘LastName’ column to include a space
5:33 Overview of different column types
SharePoint Approval Flow
In certain situations, you want to be able to control the content that your users are seeing by approving that content prior to it being published. This can be accomplished through a SharePoint Approval Flow. In Shane’s SharePoint Approval Flow video, he demonstrates how to build a SharePoint list, add SharePoint approvals, and put that into an approval process in Flow. The resulting solution is a SharePoint picture library that requires approval once a user has uploaded a picture to it.
Key Timestamps:
0:00 Intro
1:48 Create a picture library in SharePoint and customize the library settings
3:15 Create a flow from blank and add the ‘When a file is created’ SharePoint trigger
6:28 Add an approval action
8:58 Add a response condition
11:46 Add the ‘Get file metadata’ SharePoint trigger
14:34 Add the ‘Send an email’ action
16:01 Name and save the flow
17:17 View the approvals on a desktop, email, and mobile device
Comments