Modify a SharePoint List Into a Power Apps Form

In this blog, you will learn how to modify a SharePoint List into a Power Apps Form.

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

 

 

Step 2

 

In modern view, there is an option “PowerApps”. In the dropdown, you will find the following options:

 

 

Step 3

 

When you click on Customize forms, it will open the PowerApps Studio & setup the form automatically.

 

• 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:

 

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.
  
  
  
  
• 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. 

• 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.

 

Make your own App 

 

• 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. 

• Then the Power App window will appear like shown in the below image.

• From the window, select Insert from the top navigation bar 
• Select Insert a 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

 

•  Select the DataSource Property of the Form " Share Point List Name ". In this example, I have taken the List name " Registration 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.