Patch Function Error

[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);

[RogierE]

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)

[MIA27]

I found the below error on the hover over on mouse 

[MIA27]

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

[RogierE]

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)

[Himanshu_90677]

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

[trstrean]

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.  

[MIA27]

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

[MIA27]

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

[MIA27]

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