Answered

Patch, cant update 2 rows in one table at same time

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a EditForm with 2 datasources from SQL tables. So when I click checkmark to submit, I should update 1 row in PaymentVaucher, and as many rows in table LineItems as there are curently on form.

I have created a patch function for updateing data. But I can only submit 1 row to each tables at once.

I cant submit both rows to table LineItems at once. Why is that?

EditForm:

OnSelect value for checkmark icon, for submiting data:

DataCardValue21 and Label14 have ID values of rows.

Patch('[dbo].[PaymentVaucher]', LookUp('[dbo].[PaymentVaucher]', ID = Value(DataCardValue21.Text)),
 
 {RequestedBy: DataCardValue29.Text,
 RequesterEmail: DataCardValue30.Text,
 PaymentDate: DataCardValue31.SelectedDate,
 DueDate: DataCardValue32.SelectedDate,
 AccountingApprovalComments: DataCardValue33.Text,
 Curency: DataCardValue39.Text,
 AccountingApproval: Radio1.Selected.Value
 }
);

Patch('[dbo].[LineItems]', LookUp('[dbo].[LineItems]', ID = Value(Label4.Text)),
 {Description: TextInput5.Text,
 Quantity: Value(TextInput6.Text),
 Price: Value(TextInput7.Text)
 }
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Bilakanti 1,226 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous ,

LineItems, is a Gallery and it contains more than one item. Hence you need to us ForAll to iterate through each time in the LineItemsGallery and then apply your patch. Then it will patch all the rows from your Gallery.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
I tried it like like this, but then I get for specified columns in table LineItems all rows updated with the same value 😬
Patch('[dbo].[PaymentVaucher]', LookUp('[dbo].[PaymentVaucher]', ID = Value(DataCardValue21.Text)), {RequestedBy: DataCardValue29.Text, RequesterEmail: DataCardValue30.Text, PaymentDate: DataCardValue31.SelectedDate, DueDate: DataCardValue32.SelectedDate, AccountingApprovalComments: DataCardValue33.Text, Curency: Dropdown7.Selected.Curency, AccountingApproval: Radio1.Selected.Value } ); ForAll(RenameColumns('[dbo].[LineItems]', "ID", "eID"), Patch('[dbo].[LineItems]', LookUp('[dbo].[LineItems]', ID=eID), {Description: TextInput5.Text}, {Quantity: Value(TextInput6.Text)}, {Price: TextInput7.Text} ))

Was this reply helpful? Yes No
Verified answer

Bilakanti 1,226 on at

Like (1)

Report
Copy link

Link copied!
@Anonymous ,

Please do ForAll for GalleryName.AllItems, for Description and other columns, instead of passing control values, pass the column names. Below is the same syntax.

ForAll(GalleryX.AllItems, Patch('[dbo].[LineItems]', LookUp('[dbo].[LineItems]', ID=eID), {Description: Description}//which will be column name from Gallery Items, {Quantity: Value(Quantity)}//which will be column name from Gallery Items, , {Price: Price}//which will be column name from Gallery Items, ))

Was this reply helpful? Yes No