cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bakgou1
Helper I
Helper I

How to Patch records for Matrix layout

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. 

1 REPLY 1
zmansuri
Super User
Super User

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,258)