Microsoft Lists With SharePoint In Power Apps

Power Apps is a suite of apps, services, connectors, and data platforms that provides a rapid application development environment to build custom apps for your business needs. Please click here for more details.

A Microsoft list is a collection of data that you can share with your team members and people to who you've provided access. Microsoft lists help you organize, collaborate, and share the information you care about. You can create and share lists that help you track issues, assets, routines, contacts, inventory, and more. Start from the Microsoft Lists app, Microsoft Teams, or SharePoint using a template, Excel file, or from scratch.

In this article, you can learn how to create and use Microsoft Lists with SharePoint in Microsoft Power Apps.

Step 1

Open the URL https://powerapps.microsoft.com/en-us/ in the browser for Power apps,

Create an account with your Organisation Mail ID and login it, after login your Power Apps account,

Step 2

First, create a SharePoint Connection.

Click on Create (+ ), Start from data and select SharePoint and click New Connection,

Next, again select SharePoint and click on Create and connection created.

Step 3

For creating an Excel file.

Click the App Launcher and select Excel, click on New Blank Workbook.

Add the list of article data in the Excel sheet.

Now, convert to Table.

Finally, save the Excel file named as ArticleList.xsl,

Step 4

For creating a List.

Click App Launcher and select List, click New List.

Create List From Excel and select the Excel file ArticleList.xslx and click on Next.

Select table Table1 and click on Next.

Give the description and click on Create.

Now, you can see that ArticleList is created,

 

Step 5

For connecting created List to the PowerApps.

Click App Launcher and Select List, right click the ArticleList, and copy the Link address.

Next, paste the copied link to Connect to the SharePoint Site URL and select ArticleList, and click on Connect.

Now, the List is loaded in PowerApps app view,

Step 6

Now we can see the preview of your App in Power Apps Studio, and the output of the List with SharePoint in Power Apps is,

Summary

Now you have successfully tested List with SharePoint in the Power Apps Studio environment.