Patching Collection with Items not in the Collection to Dataverse

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

Have a power app that I am working on that is an employee store, I have it setup so when an item is added to the cart, it is added to a collection, colCart. I am trying to set up the submit order section of the app and I am having a hard time getting the patch to work.

I am trying to set it up so that a row on the dataverse table has the employee's name, email address, total cost and cart items.

Any advice would be greatly appreciated. Thanks

Patch Error.jpg

Patch('AWC Transactions', 
Defaults('AWC Transactions'),
{
Name:TextInputName,
'Email Address':TextInputEmail, 
Items:colCart.ProductName, 
Total: LabelTotalAmount

}

);

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
perhaps you want to loop through the collection and patch, something along the lines of
ForAll( colCart, Patch( 'AWC Transactions', Defaults('AWC Transactions'), { Name:TextInputName, 'Email Address':TextInputEmail, Items:ThisRecord.ProductName, Total: LabelTotalAmount } ) )

Hope this helps!
GF-02121351-0 239 on at

Like
a
(0)

Report
Copy link

Link copied!

@madlad
Thanks, I made your edits, but I can't test until I figure out the "Network error when using Patch function: The requested operation is invalid." error. Any ideas?
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Are textInputName and textInputEmail controls?
If so, you'll want to use textInputName.Text and textInputEmail.Text to reference the entered text.

If that's not it I cant see anything else off the top of my head - perhaps you can use the monitor tool to find more details on this error? There's a lot of posts about this error but unfortunately it seems to be a fairly broad issue.
Verified answer

GF-02121351-0 239 on at

Like
a
(0)

Report
Copy link

Link copied!
It is working now. The code should have been:
ForAll( colTrans, Patch( 'BeneStore Transactions', Defaults('BeneStore Transactions'), { Name: "Transaction", 'Product Name': ProductName, 'Product Category': ProductCategory, Quantity: Quantity, Email: Text(TextInputEmail_1.Text) } ) )