How to Create Power Apps Collection from SharePoint List?

Are you working with a scenario where you must create a Power Apps collection using a SharePoint list? If Yes, You are in the right place!

Creating a Power Apps collection from a SharePoint list can be extremely useful, as it allows you to easily access and manipulate data from the list within your app.

This Power Apps tutorial will guide you on Creating a Power Apps Collection from the SharePoint list and also additionally you can learn how to create a Power Apps collection by retrieving specific columns from a SharePoint list.

How to Create Power Apps Collection from SharePoint List

Here are the steps to create a Power Apps Collection from the SharePoint list.

  1. Create a blank canvas app in Power Apps.
  2. Connect a data source to a SharePoint list.
  3. Create a Power Apps collection from the SharePoint list.

Step 1: Create a blank canvas app in Power Apps

Now, we will create a blank canvas app in Power Apps :

  • Go to the Power Apps Home page -> Select the Apps section [Right-hand side] -> Expand the +New app -> Then click on the Canvas app.
Create a Power Apps collection from SharePoint list
  • Now a dialogue box will open as “Canvas app from blank” and provide the app name based on your requirement -> Click on the Create button.
Power Apps Collection using SharePoint list
  • Now, the Power Apps app will be created with a new screen, as shown below:
How to create a Power Apps collection from SharePoint list

Now, we have created a blank canvas app in Power Apps. The next step is to connect to the SharePoint list.

Step 2: Connect a data source to a SharePoint list

Now, we will connect a data source to a SharePoint list to work on the Collection. Before let me show you the SharePoint list and their columns.

I have a SharePoint list as “Employee Onboarding.” that has various columns like:

Column NameData type
Employee IDTitle
Employee NameSingle line of text
Employee EmailSingle line of text
Employee DepartmentChoice [“IT,” “Marketing,” “Sales,” “Finance”]
ProfileImage
Joining DateDate and time
Collection from SharePoint list in Power Apps

Let’s create a Power Apps collection using the above SharePoint list.

  • On the Power Apps screen, click on the Connect to data from the middle of the Screen page -> A dialogue box will appear [left-hand side]; click on the Add data.
Create a Power Apps collection using a SharePoint list
  • Now Select a data source by expanding the Connectors -> Then click on the See all connectors -> Select the data source as “SharePoint” -> Connect to your SharePoint site -> Choose your respective SharePoint list -> Click on the Connect button.
How to create a Power Apps collection using a SharePoint list
  • Once the SharePoint Online list is connected, it will be added under the Data section below:
Create collection from SharePoint list in Power Apps

Our next step is creating a Power Apps app collection from the SharePoint list.

Step 3: Create a Power Apps app collection from the SharePoint list

We will create a Power Apps collection from the SharePoint list using the App OnStart property by applying the SharePoint list collection formula.

  • In the Tree view, Click on the App [left-hand side] -> Select the OnStart property -> Then apply the SharePoint list collection formula.
Collect(
    colEmpDetails,
    'Employee Onboarding'
)

Where,

  1. Collect = Collection function name.
  2. colEmpDetails = Provide your Collection name.
  3. Employee Onboarding = SharePoint list name.
Power Apps Collection from SharePoint list
  • Now, we will Run OnStart to create a collection from a SharePoint file. On the App, click on the More options (…) -> Then select Run OnStart.
How to create collection from SharePoint list in Power Apps

Now, let us check if the collection will be created from a SharePoint list or what.

  • On the left-hand side, click on the Variables (x) -> Expand the Collections -> Then select the Collection name, click on the More options (…) -> Then click on View Table.
Create collection using SharePoint list in Power Apps
  • Now, we can see that the Power Apps collection will be created from a SharePoint list, as shown below:
Power Apps Collection SharePoint list

I have shown you how to create a PowerApps collection using a SharePoint list per the above steps. In my SharePoint list, we can see that there are only 6 fields.

However, you may required to retrieve only three specific columns from a SharePoint list to create a Power Apps collection; let me show you how to create it with each step.

Create a Power Apps collection by retrieving specific columns from a SharePoint list

You can retrieve only the specific columns from a SharePoint list while creating a Power Apps collection. Follow the below steps to achieve it:

  • After connecting a data source to the SharePoint list on a Power Apps screen.
  • On the Tree view, Click on the App [left-hand side] -> Select the OnStart property -> Then apply the SharePoint list collection formula.
ClearCollect(
    colEmployeeDetails,
    ShowColumns(
        'Employee Onboarding',
        "EmployeeName",
        "EmployeeDepartment",
        "Joining_x0020_Date"
    )
)

Where,

  1. ClearCollect: This function helps to remove duplicate data and adds new data to the same Power Apps collection.
  2. colEmployeeDetails: Provide your Collection name.
  3. ShowColumns: This function helps to show the columns of a table or a list.
  4. Employee Onboarding: SharePoint list name.

Then, provide the specific column names based on your requirements.

Collection using SharePoint list in Power Apps
  • Now, we will Run OnStart to create a collection from a SharePoint list. On the App, click the More options (…) -> Then select Run OnStart.

Let us check that the collection will be created by retrieving specific columns from a SharePoint list.

  • On the left-hand side, click on the Variables (x) -> Expand the Collections -> Then select the Collection name, click on the More options (…) -> Then click on View Table
  • Now, we can see that the Power Apps collection will be created by retrieving three specific columns from a SharePoint list, as shown below:
How to create collection using SharePoint list in Power Apps

To create a Power Apps collection, we can retrieve specific columns from a SharePoint list.

Conclusion

This Power Apps tutorial highlighted the importance of the Power Apps collection and guided beginners by creating a Power Apps collection from a SharePoint list.

Lastly, based on your requirement, I have covered creating a Power Apps collection by retrieving specific columns from a SharePoint list.

Also, you may like some more Power Apps tutorials: