How To Create A Collection In PowerApps From SharePoint List

In this guide, we will walk you through the process of creating a collection in PowerApps from a SharePoint list, enabling you to efficiently manage and work with your data.

To create a collection in PowerApps from a SharePoint list, follow these steps:

  1. Create a SharePoint list and add some records to it.
  2. Create a new blank canvas app in PowerApps.
  3. Connect the SharePoint list as a data source in PowerApps.
  4. Insert a button control in PowerApps and set its OnSelect property to collect the records from the SharePoint list using the Collect function.
  5. Save and preview the app, then click the button to create the collection.
  6. View the collection by navigating to the Collections section in PowerApps.

By creating a collection, you can store data from a SharePoint list in PowerApps and perform various operations on it, such as filtering, sorting, and displaying it in tables or galleries.

Creating a SharePoint List and Adding Records

To begin, you’ll need to create a SharePoint list and add some records to it. This list will serve as the data source for your PowerApps collection. Follow these steps:

  1. Open SharePoint and navigate to the site where you want to create the list.
  2. Click on “Site Contents” and then “New” to create a new app.
  3. Select “List” from the options and give your list a name.
  4. Add columns to your list by clicking on “Create Column”. Customize the column names and data types according to your needs.
  5. Once you have created the columns, you can start adding records to your list. Click on “New” and fill in the required information for each record.
  6. Continue adding records until you have populated your SharePoint list with the desired data.

Now that you have successfully created a SharePoint list and added records to it, you are ready to move on to the next step of creating a collection in PowerApps.

Example: SharePoint List Structure

Column Name Data Type
Title Single line of text
Category Choice (Dropdown)
Price Number

This is an example table representing the structure of a SharePoint list. Customize it based on your specific requirements.

In the next section, we will explore how to connect your SharePoint list as a data source in PowerApps and proceed with creating the collection.

Connecting SharePoint List as a Data Source in PowerApps

With the SharePoint list ready, the next step is to connect it as a data source in PowerApps. This will allow you to access and manipulate the data from the SharePoint list within your PowerApps app. Follow the steps below to establish the connection:

  1. Open the PowerApps app where you want to create the collection.
  2. Click on “Data” in the left-hand menu to access the Data pane.
  3. Click on “Add data source” and select “SharePoint” from the available options.
  4. Enter the URL of your SharePoint site and click “Go”.
  5. Choose the desired SharePoint list from the list of available lists.
  6. Click on “Connect” to establish the connection between PowerApps and the SharePoint list.

By connecting the SharePoint list as a data source, you are enabling PowerApps to retrieve and update information from the list. This allows you to create powerful apps that can leverage the data stored in SharePoint and provide a seamless user experience.

Example

“Connecting SharePoint lists as data sources in PowerApps has been a game-changer for our organization. We can now easily access and manipulate crucial data from our SharePoint sites, all within the same app. This has greatly improved our efficiency and eliminated the need for manual data entry. PowerApps truly empowers us to build robust applications with minimal coding skills!” – John Doe, PowerApps user

Once you have successfully connected the SharePoint list as a data source in PowerApps, you can proceed to create the collection and further enhance your app’s functionality. The next section will guide you through the process of creating the collection using a button control and the Collect function.

Summary

To connect a SharePoint list as a data source in PowerApps, navigate to the Data pane, add the SharePoint data source, and select the desired list. This connection allows you to access, update, and manipulate data from the SharePoint list within your PowerApps app. Connect once and utilize the data throughout your app to streamline processes and improve efficiency.

Action Description
Open PowerApps app Access the app where you want to create the collection.
Click on “Data” Navigate to the Data pane.
Click on “Add data source” Add SharePoint as a data source.
Enter SharePoint URL Provide the URL of your SharePoint site.
Select SharePoint list Choose the desired list from the available options.
Click “Connect” Establish the connection between PowerApps and SharePoint list.

Creating the Collection in PowerApps

Once the connection is established, you can create the collection in PowerApps by inserting a button control and configuring it to collect the records from the SharePoint list using the Collect function. This function allows you to gather all the data from the SharePoint list and store it in a collection for further manipulation.

To begin, open your PowerApps app and navigate to the screen where you want the collection to be created. From the Insert tab, select the Button control and place it on the screen.

Next, go to the Properties pane and locate the OnSelect property of the button. In the formula bar, enter the Collect function followed by the name of your collection and the source data. For example, if your collection is named “MyCollection” and your SharePoint list is named “MyList”, the formula would be: Collect(MyCollection, MyList).

Once you have entered the Collect function, save your app and preview it. Click on the button to trigger the collection creation process. You can then navigate to the Collections section in PowerApps to view your newly created collection.

Conclusion

Creating a collection in PowerApps from a SharePoint list is a straightforward process that allows you to leverage the data stored in SharePoint for various purposes. By following the steps outlined above, you can easily store and manipulate SharePoint data in PowerApps, opening up a world of possibilities for your app development projects.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.