Powerapps Patch to dataverse

(0) Share

Report

Posted on by KarimBel

I want my shopping cart create a row in my dataverse table when I click on Buy:

But when i click to buy, I get copies in my table of the first shopping cart:

This is my formula under button Buy:

ForAll('colShoppingCart',Patch('ShoeOrdersTables', Defaults('ShoeOrdersTables'), {QTY:Value(TextInput2.Text),Name:txtName.Text, ProductName:Title4.Text, Address:txtAddress.Text,Comment:txtComment.Text,TotalPrice: With({ST: Sum(colShoppingCart, Total)}, ST + ST*0.21 + 4.99)}));

Reset(txtName);Reset(txtAddress);Reset(txtComment);Clear(colShoppingCart);

Navigate(OrderConfirmation)

Can anyone help me what I have done wrong?

Thanks

Grtz

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report
@KarimBel -

A few issues:

I notice you have not included a GUID in your Patch. You will need to include the GUID in your Collection and in your Patch statement

You do not need Defaults here. If the Patch formula identifies a GUID for each record in your collection, the matching record with that GUID is updated, if a GUID is not found, a new record is created.

You do not necessarily need to precede Patch with a ForAll. It is more performant doing this the other way around

Consider the below:

Patch( ShoeOrdersTables, ForAll( colShoppingCart, { 'The Logical Name of Your GUID column': colShoppingCart[@'The Logical Name of Your GUID column'],//GUID QTY: Value(TextInput2.Text), Name: txtName.Text, ProductName: Title4.Text, Address: txtAddress.Text, Comment: txtComment.Text, TotalPrice: With( { ST: Sum( colShoppingCart, Total ) }, ST + ST * 0.21 + 4.99 ) } ) )

Note: you can identify the logical name of your GUID column by navigating to the Columns view, and filtering on the Data Type of "Unique Identifier":

Was this reply helpful? Yes No
KarimBel 6 on at

Like (0)

Report
@Amik

Thanks for your response. For the GUID, so I have the column 'ShoeOrders' as GUID. The logical name of this column in dataverse is 'solestyl_shoeorderid'. Does it mean that the formula below must than be correct:

Patch( ShoeOrdersTables, ForAll( colShoppingCart, { 'solestyl_shoeordersid': colShoppingCart[@'solestyl_shoeordersid'],//GUID QTY: Value(txtQTY.Text), Name: txtName.Text, ProductName: lblProductname.Text, Address: txtAddress.Text, Comment: txtComment.Text, TotalPrice: With( { ST: Sum( colShoppingCart, Total ) }, ST + ST * 0.21 + 4.99 ) } ) )

Because I get an error that the name isn't valid and that the function Patch has some invalid arguments:

Karim

Was this reply helpful? Yes No
Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report

@KarimBel -

Please could you take a screenshot of the error message (hover over the red line and then take a screenshot).

Have you included the GUID in your collection?

Was this reply helpful? Yes No
KarimBel 6 on at

Like (0)

Report

Hi @Amik

This is my formula for the collection and as you can see I didn't include the GUID:

Collect(colShoppingCart, {Title:ThisItem.ProductName, Productprice:ThisItem.ListPrice, ProductID:ThisItem.ProductNumber, QTY:Slider2.Value, Total: (Slider2.Value * ThisItem.ListPrice)});Set(varShowSucces,true)

What do I need to do?

Thanks

Karim

Thanks

Grtz

Was this reply helpful? Yes No
Verified answer

Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report

@KarimBel - as stated in my first response to your post - include the GUID in the Collection.

Was this reply helpful? Yes No