How to Patch records for Matrix layout

[bakgou1]

Hi Community,

I need help in patching all the records with a single button click in PowerApps. I have a list in SharePoint that contains 4 columns. I need to insert records in the below model:

My PowerApps Layout: 

                   Audi       BMW

Text1               0                       0

Text2                0                       0

In my sharepoint list, I'm trying a Patch formula that inserts records:

Column1        Column2      Column3

Text1                  Audi                0

Text1                  BMW              0

Text2                   Audi               0

Text2                    BMW              0

Any help or suggestions? Thanks in advance. 

[zmansuri]

Create a collection on Button OnClick:

Collect(ColA,{Column1: TextInput10.Text,Column2: TextInput10_1.Text,Colum3: TextInput10_2.Text})

you can enter how many values you like it will create a collection table.

Next on other button:

Patch(ListName,ColA)

it will patch all the rows from collection to your list