Patching Multiple rows in Dataverse from a Gallery

(0) Share

Report

Posted on by MaryJam

I ran into another issue, I was able to fix the previous one and your solution seemed to be working. thanks for that.

However, I have ran into another issue:

I am trying to patch multiple rows when hit submit. For some reason, it is not adding all the rows but the first one for three times.

ForAll(
GalCart_1.AllItems,
Patch(
'Employee Approval Requests',
Defaults('Employee Approval Requests'),
{
'Product Name': GalCart_1.Selected.Title1_1,
'Product Number': GalCart_1.Selected.ProductNumber,
'List Price': GalCart_1.Selected.Subtitle1_1,
Quantity: GalCart_1.Selected.Qty_1,
Total: GalCart_1.Selected.Total_1,
Color: GalCart_1.Selected.Color,
Comments: DataCardValue10_1.Text,
Approver: DataCardValue3_1.Text,
'Request Date': Today(),
'Requested By': DataCardValue5.Text
}
)
);
//SubmitForm('Approval Submission');
Notify(" Your request for approval has been submitted");
//Clear(CompareList);

Can you please suggest what is wrong. Cartlist is the gallery name and CompareList is the collection name.

I am also not able to see the edit form in preview mode, it may be because my patch function is not working as expected.

Can you please help! thanks!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MaryJam ,

That is because you are referring to the record currently selected in the Gallery for all items - try this

Patch( 'Employee Approval Requests', ForAll( GalCart_1.AllItems As aGal, { 'Product Name': aGal.Title1_1, 'Product Number': aGal.ProductNumber, 'List Price': aGal.Subtitle1_1, Quantity: aGal.Qty_1, Total: aGal.Total_1, Color: aGal.Color, Comments: DataCardValue10_1.Text, Approver: DataCardValue3_1.Text, 'Request Date': Today(), 'Requested By': DataCardValue5.Text } ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
MaryJam 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much! I replaced with the suggested one but I am getting a network error:
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@MaryJam ,

You can try the "long" way (less efficient) - but both structures are valid providing your control output references are valid

ForAll( GalCart_1.AllItems As aGal, Patch( 'Employee Approval Requests', Defaults('Employee Approval Requests'), { 'Product Name': aGal.Title1_1, 'Product Number': aGal.ProductNumber, 'List Price': aGal.Subtitle1_1, Quantity: aGal.Qty_1, Total: aGal.Total_1, Color: aGal.Color, Comments: DataCardValue10_1.Text, Approver: DataCardValue3_1.Text, 'Request Date': Today(), 'Requested By': DataCardValue5.Text } ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
MaryJam 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for the solution, I have managed to use the following patch code but having three fields that are not posting a value in dataverse. One of them is Total Amount. Comments and Approver.

Patch(
'Employee Approval Requests',
ForAll(
GalCart_1.AllItems As aGal,
{
'Product Name': aGal.ProductName,
'Product Number': aGal.ProductNumber,
'List Price': aGal.ListPrice,
Quantity: aGal.Qty_1.Text,
'Total Amount': aGal.Total_1,
Color: aGal.Color,
Comments: DataCardValue10_1.Text,
Approver: DataCardValue3_1.Text,
'Request Date': Today(),
'Requested By': DataCardValue5.Text
}
)
);

//SubmitForm('Approval Submission_1');
Notify(" Your request for approval has been submitted");
//Clear(CompareList);

I have also noticed that the form doesnt not show in preview so I am unable to add comments.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MaryJam ,

Are those textboxes Comments and Approver) inside or outside the gallery ? Also what is Total_1 in the gallery ?