rachel0002

Jul 21, 20214 min

SharePoint and Power Apps Video Series

In this video series you will learn how to work with SharePoint and Power Apps. The following 5 videos are included in this series:


 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

    586
    1