Answered

Patching a collection

(0) Share

Report

Posted on by CodyO

391

Hello! I am attempting to patch a collection. I am able to patch correctly, however it only submits one of the rows rather than all of the rows in the collection. I am unsure what I am doing wrong! Anyone have any helpful advice?

Patch Code

Patch('Material Requests', Defaults('Material Requests'),
{
 ItemDescription:Item_Description.Text,
 Quantity:Quantity.Text,
 PurchasedFrom:Purchased_From.Text,
 PartSerialNumber:'Part/Serial_Number'.Text,
 JobComplete:ti_Complete.Selected
}
)

The App

The SP List

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

LowCodeJim 314 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CodyO,

It looks like you are adding all your items to a temporary collection below the form. You will need to wrap your patch statement in a ForAll to patch all the items:
ForAll( <COLLECTIONNAME>, Patch('Material Requests', Defaults('Material Requests'), { ItemDescription:<ITEMDESCRIPTION>, Quantity:<QUANTITY>, PurchasedFrom:<PURCHASEDFROM>, PartSerialNumber:<PARTSERIALNUMBER>, JobComplete:<COMPLETE> } ) )

You will need to replace the placeholders with the name of the relevant column in your collection.

Hope that helps!

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.
CodyO 391 on at

Like
a
(1)

Report
Copy link

Link copied!

That is working perfectly, Thank you @SharePointJB!!