In this article, we are going to see how to use the patch function to create and edit multiple records in a table.

Create Multiple Records Using Patch Function

Syntax

Patch(Datasource, BaseRecordsTable, NewRecordsTable)

Code

ClearCollect(
    colGrosseryInventory,
    Table(
        {
            Name: "Pasta",
        	ProductID: 1001,
        	ExpiryDate: Date(2023,12,11),
        	Price: 120
        },
        {
            Name: "Rice",
        	ProductID: 1002,
        	ExpiryDate: Date(2024,12,08),
        	Price: 110
        },
        {
            Name: "Butter",
        	ProductID: 1003,
        	ExpiryDate: Date(2025,12,07),
        	Price: 130
        }
    )
);

Patch(
    GrosseryInventory,
    ForAll(
        Sequence(CountRows(colGrosseryInventory)),
        Defaults(GrosseryInventory)
    ),
    colGrosseryInventory
);

Output

GrosseryInventory in SharePoint.

ID Name ProductID ExpiryDate Price
10 Pasta 1001 12/01/2023 120
11 Rice 1002 08/01/2024 110
12 Butter 1003 07/11/2025 130


Edit Multiple Existing Records Using Patch Function

Syntax

Patch(Datasource, BaseRecordsTable, UpdateRecordsTable)

Code

ClearCollect(
    colUpdateGrosseryInventory,
    Table(
        {
		    ID: 10,            
        	Price: 140
        },
        {
		    ID: 11,            
        	ExpiryDate: Date(2024,12,11),
        	Price: 130
        },
        {
            ID: 12,        	
        	Price: 160
        }
    )
);

Patch(
    GrosseryInventory,
    ShowColumns(
        colUpdateGrosseryInventory,
        "ID"
    ),
   colUpdateGrosseryInventory
);

Output

GrosseryInventory in SharePoint.

ID Name ProductID ExpiryDate Price
10 Pasta 1001 12/01/2023 140
11 Rice 1002 12/11/2024 130
12 Butter 1003 07/11/2025 160

That’s it, you have seen how to use the patch function to create and edit multiple records in a table. Feel free to fill up the comment box below if you need any further assistance.