Introduction

  • PowerApps is an application platform that can be put on the web page and viewed on a Phone.
  • Power App is the immediate successor of InfoPath
  • Share Point allows users to customize the forms with PowerApps with a bunch of possibilities. Users can add things to List, review information, interact with the data, edit things, show charts & icons, etc.
  • While a User works with a Modern List View or in a Modern Library, the user can create PowerApps forms that can replace the traditional SharePoint Form.
  • Power Apps is one of the Office 365 Programs.
  • PowerApps can connect many different data sources like SQL, Excel, and third-party things like Facebook & Twitter.
  • PowerApps is done completely online. It does not matter whether you use Windows or MAC; users have to Login & edit or view the application.
I am going to write a series of articles to learn PowerApps from scratch. In this article. I am going to explain how to modify a SharePoint List using PowerApps and how to connect a Sharepoint List using Power Apps.

Steps to modify a SharePoint List into a PowerApps Form

One important thing to consider is that you have to be in the modern View of SharePoint.
Step 1
I have created a List in Modern View of Share Point
Modify SharePoint List Into Power Apps Form
Step 2
In modern view, there is an option “PowerApps”. In the dropdown, you will find the following options:
Modify SharePoint List Into Power Apps Form
Step 3
When you click on Customize forms, it will open the PowerApps Studio & setup the form automatically.
Modify SharePoint List Into Power Apps Form
  • As displayed in the above picture, in FormScreen1 the SharePointForm1 is present.
  • Here, you can go back to Share Point if you click on the Back to Share Point option.
  • Customize forms in PowerApps is not possible in Classic SharePoint.
Note
When you create forms for a List, it doesn’t appear on everybody’s PowerApps studio. Anyone who has the owner access should be able to edit it.

Steps to connect Sharepoint List using Power Apps

Open http://apps.powerapps.com/. The below screen will appear:

Modify SharePoint List Into Power Apps Form
The above screen shows two options to create an app
  1. Start from data
  2. Make your own app

Start from Data

  • PowerApps can create various data sources, you can select a data source and can create a new app.
  • From the PowerApps environment, you can select the displayed data source under the Start from data.

    Modify SharePoint List Into Power Apps Form

  • For now, I am going to select Share Point
  • After clicking Sharepoint, the page will redirect to the connect the SharePoint site. Paste the URL of the Share Point Site on the box which will connect to Share Point.
Modify SharePoint List Into Power Apps Form
  • After selecting the site to choose the List you want to connect, I select the same List "Registration Form".
  • It will automatically create my app and build some default screens, like Browse Screen with Detail Screen & an Edit Screen1.
  • I can build and customize any of the items here.
  • But the limitation here is Phone Size, the orientation can not be changed here.
Modify SharePoint List Into Power Apps Form

Make your own App

Modify SharePoint List Into Power Apps Form
  • Now from the PowerApp window select Canvas App then it will as you select either the Tablet or Phone option to create App. I have chosen the Tablet option to create an App. Give your App Name and then select Create.
Modify SharePoint List Into Power Apps Form
  • Then the Power App window will appear like shown in the below image.
Modify SharePoint List Into Power Apps Form
  • From the window, select Insert from the top navigation bar
  • Select Insert a Form.
Modify SharePoint List Into Power Apps Form
  • Click connect data from the screen appears to connect the data of List to create a Form
  • In the left pane, connectors are available to connect with various data sources.
  • Chose Share Point Site & select the List Name
Modify SharePoint List Into Power Apps FormModify SharePoint List Into Power Apps Form
  • Select the DataSource Property of the Form " Share Point List Name ". In this example, I have taken the List name " Registration Form".
Modify SharePoint List Into Power Apps Form

Conclusion

In this article, I have explained how a Sharepoint List which is connected to PowerApps can be used for different purposes, in different ways, and in different forms.