Patch Function Error

(0) Share

Report

Posted on by MIA27

I am working on teams power app.

I am trying to use the below code but getting error Invalid argument.

Please guide the correction in this code :

Patch(
TablePartsReturnA,
If(gblReturnNewRecord, Defaults(TablePartsReturnA), SearchResultGallery_3.Selected),
{
FormNo: TextBox2.Value,
FormDate: TextBox2_1.Value,
Product: TextBox2_2.Value,
FCNo: TextBox2_3.Value,
FCissueDate: TextBox2_4.Value,
FCTargetDate: TextBox2_5.Value
}
);
Set(gblReturnNewRecord,false);

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

RogierE 875 Moderator on at

Like (0)

Report

My tip would be to hover your mouse over all of the rows within the Patch formula to find out which argument is invalid specifically.

Please LIKE the reply and ACCEPT it as the solution if the answer is what you were looking for.
(to help me grow in community rank and help others find the solution)

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

I found the below error on the hover over on mouse

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Also note, as I thought that it may be expecting .Selected for date field, But it is not allowing me to do that. It has only option to select .value , And there is no other field to select for date entry
As I have a normal text box , where I will type the date and patch it.

Please guide

Was this reply helpful? Yes No
RogierE 875 Moderator on at

Like (0)

Report

You can use the DateTimeValue(Textstring) formula to translate your text to a date time value.

Please LIKE the reply and ACCEPT it as the solution if the answer is what you were looking for.
(to help me grow in community rank and help others find the solution)

Was this reply helpful? Yes No
Himanshu_90677 416 on at

Like (0)

Report

Hey @MIA27
Your TextBox2_4.Value is type of string, you have to pass date value
Convert text to date type
Do let us know if you encounter any issue

Was this reply helpful? Yes No
trstrean 185 on at

Like (0)

Report

It's hard to determine what could be your issue based on the info you provided. Is everything a text field? You can narrow down where the issue is by removing fields to find which one is causing the issue. My guess would be your date field could be the problem, but if you are updating a text field than what you are doing would work. If the data source has choice fields, your approach wouldn't work for that field type. Once you figure out which field is the problem, identify a data type mismatch and adjust the syntax to provide the right info to the data source.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Dear Mr. Rogier,
Noted and change all the Input field on the screen according to the Table. (I mean if table column is Date Field Type, the I selected Date picker for data entry.

so revised the code as below , but still getting the error of invalid arguments:
Patch( TablePartsReturnA, If(gblReturnNewRecord, Defaults(TablePartsReturnA), SearchResultGallery_3.Selected), { FormNo: TextBox2.Value, FormDate: DatePicker1.Value, Product: ComboBox1.Selected, FCNo: TextBox2_3.Value, FCissueDate: DatePicker1_1.Value, FCTargetDate: DatePicker1_2.Value, } ); Set(gblReturnNewRecord,false);

Kindly review my code, now what the mistake, as I fixed with the data type and cross checked all.

Please guide

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Dear Mr. Himanshu,
please find reply posted having still the error in details, I change the fields according to the table column data type,
Still the error.

Please review and guide

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Dear,
As guided by all of your, I have changed the controls and had matched with the data type of the table.
Please review my last post with error and full code and guide me for the correction
Regards

Was this reply helpful? Yes No
RogierE 875 Moderator on at

Like (0)

Report

Please repeat the same procedure until you run out of errors:
- hover over all of the rows in your formula
- wait until it changes the feedback to a specific error
- correct that error
>repeat 🙂

Was this reply helpful? Yes No