Patch function for forms - column does not exist

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have 2 forms on my app -

one form is from datasource 'Client Intake', the other form is from datasource 'Soap Notes'.

I also have an image in the app and a peninput to draw on the image.

Here is my code:

Patch('SOAP Notes', Defaults('SOAP Notes'), Form1.Updates, Form4.Updates); ResetForm(Form1); NewForm(Form1); ResetForm(Form4); NewForm(Form4); Reset(NameSearch); Reset([@MyPen]); Patch(Drawings, Defaults(Drawings), {Image:MyPen.Image})

However, I get the following error:
Annotation 2019-10-16 090454.png

How do I fix the column issue and also get my image and peninput to merge together?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous
You syntax for PATCH needs a small bit of work. The 3rd parameter must be supplied as a parameter like this code. Replace your_column_name with the column name from the datasource you want to update.

Patch( 'SOAP Notes', Defaults('SOAP Notes'), { your_column_name1: Form1.Updates, your_column_name2: Form4.Updates } );

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your 'Soap Notes' data source?

Is there a column called "Address" within your 'Soap Notes' data source?

Further, do the Form1 and Form4 connect to your same 'Soap Notes' data source?

According to the error screenshot you provided, it seems to tell that there is no column called "Address" in your 'Soap Notes' data source. Please check if there is a 'Address' column existed in your 'Soap Notes' data source or you have deleted the 'Address' column from your 'Soap Notes' data source.

As an alternative solution, please consider disable/remove the 'Address' field data card from your Form1 as below:

then try your Patch formula again, check if the issue is solved.

If the Form1 and Form4 do not connect to same 'Soap Notes' data source, please consider modify your Patch formula as below:

Patch(
'SOAP Notes',
Defaults('SOAP Notes'),
{
Column1: Form1.Updates.Column1,
Column2: Form1.Updates.Column2,
Column3: Form1.Updates.Column3,
...
},
Form4.Updates
);
ResetForm(Form1); NewForm(Form1); ResetForm(Form4); NewForm(Form4); Reset(NameSearch); Reset([@MyPen]); Patch(Drawings, Defaults(Drawings), {Image:MyPen.Image}

Please note that if you want to use EditForm.Updates within your Patch formula to patch data, please make sure the EditForm connects to same data source as that used in your Patch function.

Best regards,

Was this reply helpful? Yes No