In this blog post, we’ll show how to use Power Apps to build a collection from data in a specific SharePoint list.

Now we have to create a SharePoint list with some random data shown below

 

Next, Create a blank canvas app in power apps

After that, we must add the newly generated SharePoint List to PowerApps and connect the SharePoint List data source.
If there is already a SharePoint connection, you can use it without creating a new one; otherwise, create a new SharePoint connection.

Add a Button control  to the PowerApps screen.
Choose the button, then enter the following formula as its value for the OnSelect property:

Collect(studentnumber, Colorpicks2)

Save, publish, and preview the app. Simply press the button. When you click on it, the collection will be created and have all the records from the SharePoint list added to it.

Click the ellipses (…) on the Power Apps screen > Collections top bar to check the collection.

You can see all the SharePoint list records inside the formed collection after you click on the collection name, as seen in the screenshot below.

For any Help or Queries Contact us on info@crmonce.com or +918096556344