Answered

Patch function

(0) Share

Report

Posted on by JH-20021340-0

Hey all,

Is it possible to use a patch function on a form to only create a new record rather than creating a new record and modifying the existing one?

Best regards,

Frederik

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Sarah Guest 20 27 on at

Like (1)

Report
Copy link

Link copied!

Hi Frederik,

When you are using the Patch function you can pass an empty record as the second argument to create a new record

Patch(
YourDataSource,
Defaults(YourDataSource),
{Field1: "Value1", Field2: "Value2"}
)

When you are modifying an exisiting record you pass in a lookup for the record you want to update.

Patch(
YourDataSource,
LookUp(YourDataSource, ID = 123),
{Field1: "UpdatedValue"}
)

Here is the Microsoft Learn link around patching.

Patch function - Power Platform | Microsoft Learn

When working with forms in Power Apps, the mode of the form determines whether a new record is created or an existing record is updated.

New Form Mode (NewForm(FormName)) – Creates a New Record

Edit Form Mode (EditForm(FormName)) – Updates an Existing Record

Understand canvas-app forms - Power Apps | Microsoft Learn

I hope this helps!

Was this reply helpful? Yes No
Suggested answer

Gabriel G. 831 Moderator on at

Like (1)

Report
Copy link

Link copied!

When you use a form, no need to use Patch. You simply configure which type of form you use (DefaultMode = FormMode.Edit or FormMode.New). Then, when you ready to save, you use SubmitForm(<formName>). If it is a FormMode.New, it is a new record, otherwise it is an update.

__________________________________________

Please click Does this answer your question 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 a Like.

Was this reply helpful? Yes No
JH-20021340-0 4 on at

Like (0)

Report
Copy link

Link copied!

@Sarah Guest 20

I'm currently using that exact patch function formula but it still updates the existing record.

SubmitForm(formInspection);

Patch(('Group Portfolio Projects - TO'),Defaults('Group Portfolio Projects - TO'),{'Project ID':Value(DataCardValue4.Text),Priority:Value(DataCardValue9.Text),'CXO priority':Value(DataCardValue6.Text),'Sponsor/Function':DataCardValue10.Selected.Value,'Portfolio Type':DataCardValue7.Selected.Value,'Who is managing the project':DataCardValue3.Selected.Value})

Can you see if there's something wrong with my code?

Best,

Frederik

Was this reply helpful? Yes No