Power Platform Community Forum Thread Details

To save your entire collection in a SharePoint list with a single button click in PowerApps, you can use the ForAll function combined with the Patch function. Here's a step-by-step guide:

Step-by-Step Solution:

Create the Collection:
- If you haven't already created a collection that stores the data you want to save to SharePoint, you can create one using the ClearCollect function.
- Example:
```
ClearCollect(MyCollection, YourDataSource)
```
- Replace YourDataSource with the actual data source you're pulling data from (e.g., another SharePoint list, SQL table, etc.).
Patch the Collection to SharePoint:
- Use the ForAll function to loop through each item in the collection and patch it to the SharePoint list.
- Example:
  ForAll( MyCollection, Patch( YourSharePointList, Defaults(YourSharePointList), { Column1: Value1, Column2: Value2, ... } ) )
- Replace YourSharePointList with the name of your SharePoint list.
- Replace Column1, Column2, etc., with the actual column names in your SharePoint list.
- Replace Value1, Value2, etc., with the corresponding values from your collection items (e.g., ThisRecord.ColumnName).

Important Considerations:

Delegation: Ensure that the data source you are working with supports delegation if you're working with large datasets. Otherwise, PowerApps might only handle the first 500 or 2000 records, depending on your app's settings.
Performance: If your collection contains many items, this operation might take some time to complete, especially if the SharePoint list has complex fields or if the network is slow.

Example Scenario:

Let's say you have a collection called InvoiceItems with columns Product, Quantity, and Price. You want to save all items in this collection to a SharePoint list named Invoices.

You would create the following OnSelect action for your button:

ForAll(
    InvoiceItems,
    Patch(
        Invoices,
        Defaults(Invoices),
        {
            ProductName: ThisRecord.Product,
            Quantity: ThisRecord.Quantity,
            Price: ThisRecord.Price
        }
    )
)

Conclusion:

This method allows you to save all items from a gallery or collection to a SharePoint list with a single button click, without having to manually patch each item individually.