Patch help!

(0) Share

Report

Posted on by amydixanne

Hi,

So I am new to PowerApps, done a lot of Googling to help me to get to where I am now.

There is one bit I am really struggling with which is using the "patch" function.

When I am using the data cards in my patch I put the closing bracket on and it comes up with an error that patch function has errrors and that my datacards couldn't be found and must have been deleted but I can see them in the form. I have tried using the data card values which does not give me an error but when I save the form into my Sharepoint List the new entry is empty.

I am beyond confused with this now but am sure I am doing something wrong.

Any help would be greatly appreciated!

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi Amy,
If you are using an Edit form, you don't need a patch. Why not use a button with the OnSelect property SubmitForm(Form1) where form1 is the name of your form

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Hi @amydixanne,

Could you please share more details about the Patch formula within your app?

Further, could you please share a bit more about the error message?

Currently, we could use Patch function to create records or modify records in a data source, or merge records outside data source.

The standard formula format for creating a record or records:

Patch(
datasource,
Defaults(datasource),
{
Column1:Value1,
Column2:Value2,
Column3:Value3,
...
}
)

The standard formula format for modifying a record or records:

Patch(datasource, BasedRecord, ChangeRecord1, [ChangeRecord2, ...])

The standard formula format for merging records:

Patch( Record1, Record2 [, …] )

More details about Patch function in PowerApps, please check the following article:

Patch function

If you want to save your form data into your SP list using Patch function, please check the following article:

Patch( 'YourSPList', Defaults('YourSPList'), { Column1: DataCardValue1.Text, Column2: DataCardValue2.Text, Column3: DataCardValue3.Text, ... ColumnN: DataCardValueN.Selected.Value, ... } )

More details about saving form data into SP list using Patch function, please check the following video:

https://www.youtube.com/watch?v=k3gT-HxUhL8

Best regards,

Kris

Was this reply helpful? Yes No