Create Collection from SharePoint List in PowerApps

In this Power Apps Tutorial, We will discuss how to create collection from SharePoint list PowerApps.

You can also read another article on How to create PowerApps collection from Excel.

Create Collection from SharePoint list PowerApps

To create PowerApps Collections from SharePoint List, We need to follow these below processes as:

  • Create a SharePoint List and Add some items into that List
  • Create a Canvas app in Power Apps
  • Connect a new or existing Data Source and SharePoint Site to your App
  • Add a Button and Apply the List Collections Formula
  • Preview the Canvas app in the Power Apps
  • SharePoint List Items added into the Power Apps Collections

Syntax: Create PowerApps Collection from SharePoint List

Below is the syntax to to Create Collection from SharePoint List in PowerApps.

Collect(MyListCollection, ListName)

Where,

  • Collect = Collection Function Name which is used to create Powerapps Collections
  • MyListCollection = Collection Name
  • ListName = Provide the SharePoint List Name which contains the items that you wants to display in the Powerapps Collections

Create a SharePoint List and Add some items into List

First of all, In the SharePoint Site, I have created a List named “Hospital Registration Details“. This list has some columns and records of some patients as shown below.

How to create PowerApps Collection from a SharePoint List

Create a Canvas app in Power Apps

  • Sign in the PowerApps app with your credentials.
  • Go to Apps option from the left navigation.
  • Select Canvas under the + New app tab from the top of the page.
How to create PowerApps Collection from SharePoint List
  • Select Tablet layout under the Blank app section as like below screenshot.
How to create Power Apps Collection from SharePoint List

Connect a Data Source and SharePoint Site to your App

Click on to connect to data from the middle of the page and expand the Connectors (from left navigation). Select the new Data Source as SharePoint as shown below.

Also, you can directly search the SharePoint in the Search bar.

powerapps create collection from sharepoint list

Provide your SharePoint Site URL for the location of your list and hit the Connect button. Also, you can directly search the SharePoint Site Url under the Resent sites section.

power apps create collection from sharepoint list

Choose your SharePoint List (Hospital Registration Details) and click on the Connect button.

powerapps create collection from a sharepoint list

Add a Button and Apply the List Collection Formula

Now in the Power apps Screen, add a Button (Click Insert -> Button).

How to create Power Apps Collection from a SharePoint List

Just rename the Button name to Add SharePoint List Item to Collection by double clicking on it. Also, you can provide some button properties like Font size, Font color, Border etc.

Those above properties you can change under the Button Properties section (From the right side of the page).

Create PowerApps Collection from SharePoint List

Select the Button and apply the below formula in its OnSelect Property to this function.

OnSelect = Collect(ListCollection,'Hospital Registration Details')

Where,

  • OnSelect = Button Property Name
  • Collect = Collection Function Name
  • ListCollection = Collection Name
  • Hospital Registration Details = SharePoint List Name
Create Power Apps Collection from SharePoint List

Preview the App in the Power Apps

Now preview the app to see how it works. To preview, click on F5 or Preview icon from right top of the page.

Create Power Apps Collection from a SharePoint List

In the Preview screen, the Button will appear as the below screenshot. Just hit on this button. There will be no effect when you will hit the button, but all the list items will be added into the Collections.

Create PowerApps Collection from a SharePoint List

SharePoint List Items added into the Power Apps Collections

To view all the SharePoint List Items in the Powerapps Collections, Go to View tab -> Collections as shown below.

Create a Power Apps Collection from a SharePoint List

Click on your Collection Name (ListCollection) and then you can view the first 5 items in the collection.

In the below screenshot, some of the boxes are appearing in the Collections. When you will click on it, then you can see the details.

Create a PowerApps Collection from a SharePoint List

Also, you may like some below Powerapps Tutorials:

In this Power Apps Tutorial, We discussed how we can create collection from sharepoint list PowerApps.

  • Hello, i would like to know how to make an item deleted automatically from a sharpoint list when it is removed from a collection ?

  • >