Connect a SharePoint List to Power Apps

In this blog you will understand How to connect a SharePoint List to Power Apps?

Similar questions related to this post-

1. How do I get data from SharePoint list in PowerApps?
2. Can PowerApps portal connect to SharePoint?
3. Connect to SharePoint from a canvas app.
4. PowerApps with a SharePoint List.
5. Connecting PowerApps to a SharePoint List

Things to be cover here-

1. Upload Excel file data to Share Point List
2. Connect a SharePoint List to Power Apps

Following these steps-

Step-1: Login into Power Apps maker Portal with your work or school mail id-  https://make.powerapps.com/

Note:  Power Apps doesn’t not support personal mail id, you have to sign in with you official mail id or Id assigned by your school.

Step-2: Now click on Create tab > choose Blank app > Click on Create

Step-3: Give app name and choose the App format > Click on Create button.

Step-3: Now you can see the blank canvas power apps screen.

Upload Excel Data to SharePoint List and Connect a SharePoint List to Power Apps

Step-1: Open SharePoint Portal.

Step-2: Now click on Setting Icon > Choose Site contents.

Step-3: Click on +New > And choose List.

Step-4: Now you will see three option to create a list – Blank list , From existing list, From Excel.

Choose third option From Excel >Click on upload > Browse the Excel file

Note: Format your data as a table in excel, if you don’t know how to format as a table? Refer this post.

After that you will see the preview of your data, here you can change the data type of columns.

Step-5: Give the list an appropriate name and by default Site Navigation is checked, uncheck it if you don’t want this list to appear in the navigation menu.

Step-6: Now list has been created and you can see the data.

Copy the URL of this list

Step-7: Now Open the Canvas App> Click on Data > +Add Data > Search SharePoint data source> click on SharePoint 

Step-8: If you don’t have any existing SharePoint connection click on +Add a connection else click on SharePoint.

Step-9: Choose connect directly(cloud services) > Connect.

Step-10: Paste SharePoint URL here and click on Connect. After that choose your list and click on connect.

Step-11: Now add one Gallery control and bind the data in Gallery.

Refer more Power Apps post- Microsoft Power Apps

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.