Power Apps - Creating Forms in Power Apps

Create a SharePoint List for storing form data

Microsoft PowerApps One of the really cool features of PowerApps is the ability to use it to replace and enhance SharePoint list forms.

Here, we will walk you through how to create a SharePoint list.
Note: In this example we will create a list for storing CPR Certification Requests.

Create a List
  1. Go to SharePoint.
  2. Under the Sites section, click on the SharePoint team site you want to create the list in.
  3. Click on New > List.
  4. Enter the name and description for the list, and click Create.

  5. Note: In this example, I named my list "cprcertrequest" and put in a description of "CPR Certification Request".

    Note: It is best practice to not have spaces in your name, initially, as these will render "%20" in the URL of your list. After the list is created you can add in the spaces so it reads nice on the form.
    1. Click on Settings in the upper right hand corner.
    2. Select List Settings from the drop-down menu.
    3. Select List Name, description and navigation. (the top left link item)
    4. In the Name: field type the display name now using spaces so it reads well. In this example (CPR Certification Request)
    5. Click Save to save this change.

    Most fields in forms are "Single line of text" including Email addresses and phone numbers. Code can be added to these fields to force formatting if desired.


  6. Next add the column's you need (click on + Add column). In this example, I created the following columns.
    1. NameID: Single line of text
    2. EmailLocation: Single line of text
    3. CourseCompletedDate: Date
    4. Base: Lookup Values: pull from "Base" list "Title" field

When finished, your list should look something like this:

View your default SharePoint form

Note: The "Title" field is a default column in a SharePoint list and you might not need that field on your form. You can rename it and use it for something else but behind the scenes it will still be "Title" and this can cause challenges in reporting. The best option to creating a SharePoint list without the default "Title" field is to create a SharePoint list from an Excel file.

Click on New Item to see the default SharePoint list form:

Not a bad looking form, but if we want to add some branding like a logo or have a better structure for the form? That's where we turn to PowerApps!

If you want to create a customized form for this list go to the next tutorial: Customize SP List Form