Unanswered

Patch creating new record instead of updating recode

(0) Share

Report

Posted on by tharakadilshan

Patch(
colDridData,
ThisItem,
{
No_of_Pax: No_of_Pax_DropDown.Selected,
Country: Country_DropDown.Selected,
DMC: DMC_DropDown.Selected,
TO_Agent: TO_Agent_DropDown.Selected,
Hotel: Hotel_DropDown.Selected,
Remarks: Remarks_LBL.Text
}
);

Code Code Outout Outout

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tharakadilshan ,

Please try this:
Patch( colDridData, Defaults(colDridData), { No_of_Pax: No_of_Pax_DropDown.Selected, Country: Country_DropDown.Selected, DMC: DMC_DropDown.Selected, TO_Agent: TO_Agent_DropDown.Selected, Hotel: Hotel_DropDown.Selected, Remarks: Remarks_LBL.Text } );

Reference Document:
Patch function in Power Apps (contains video) - Power Platform | Microsoft Learn

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
tharakadilshan 10 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This is also not working 😣

Thank you

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tharakadilshan ,

Is there any Error Message in the canvas app?
Also Do you want to add a new recoed into colDridData or another DataSource?

Please try to run this function and check it as below to see if it worked or not.

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @tharakadilshan,

Try using the following and see if it helps.

Patch( colDridData, Defaults(colDridData), { No_of_Pax: No_of_Pax_DropDown.Selected.Value, Country: Country_DropDown.Selected.Value, DMC: DMC_DropDown.Selected.Value, TO_Agent: TO_Agent_DropDown.Selected.Value, Hotel: Hotel_DropDown.Selected.Value, Remarks: Remarks_LBL.Text } );

If the above code shows error try using the following.

Patch( colDridData, Defaults(colDridData), { No_of_Pax: No_of_Pax_DropDown.Selected.No_of_Pax, Country: Country_DropDown.Selected.Country, DMC: DMC_DropDown.Selected.DMC, TO_Agent: TO_Agent_DropDown.Selected.TO_Agent, Hotel: Hotel_DropDown.Selected.Hotel, Remarks: Remarks_LBL.Text } );

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
tharakadilshan 10 on at

Like (0)

Report
Copy link

Link copied!
Hi Tina,

I can add a new recode to colDridData using this patch function.
Collect( colDridData, Patch( varNewRecord, {ID: varNumber} ) )
But when I tried to select an item from the combo box it update the current recode and also create a new recode with the same data. for that, I use this function in the "Onchange" activity in every combo box.
Patch( colDridData, ThisItem, { No_of_Pax: No_of_Pax_DropDown.Selected, Country:Country_DropDown.Selected, DMC:DMC_DropDown.Selected, TO_Agent:TO_Agent_DropDown.Selected, Hotel:Hotel_DropDown.Selected, Remarks:Remarks_LBL.Text } );

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tharakadilshan ,

Please try as @Talha_Dar Write.
If the Items of the DropDown is the one singel Table or just a Colimn.
Try this:
Patch( colDridData, Defaults(colDridData), { No_of_Pax: No_of_Pax_DropDown.Selected.Value, Country: Country_DropDown.Selected.Value, DMC: DMC_DropDown.Selected.Value, TO_Agent: TO_Agent_DropDown.Selected.Value, Hotel: Hotel_DropDown.Selected.Value, Remarks: Remarks_LBL.Text } );
If the Items of the DropDown is a Table.
Try this:
Patch( colDridData, Defaults(colDridData), { No_of_Pax: No_of_Pax_DropDown.Selected.No_of_Pax, Country: Country_DropDown.Selected.Country, DMC: DMC_DropDown.Selected.DMC, TO_Agent: TO_Agent_DropDown.Selected.TO_Agent, Hotel: Hotel_DropDown.Selected.Hotel, Remarks: Remarks_LBL.Text } );

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
tharakadilshan 10 on at

Like (0)

Report
Copy link

Link copied!

Hi, @v-hanytian-msft @Talha_Dar

both codes are showing errors,
Tks

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tharakadilshan ,

May I ask waht type of Column which are shows Error?
If it is the Choice, please try this:
Patch( colDridData, Defaults(colDridData), { No_of_Pax: LookUp(Choice([@Table].Column),No_of_Pax_DropDown.Selected.Value = Value) })

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
tharakadilshan 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-hanytian-msft

All Combo box & Text column has the same error

Thank you

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @tharakadilshan,

Can you please specify the column types of these columns.

Was this reply helpful? Yes No