'Invalid number of arguments: received 3, expected 1.' - error while trying to submit form to dataverse table.

(0) Share

Report

Posted on by MP-13011217-0

158

Hello,

I have a form which I would like to be filled in to update table in my dataverse (as a new record) by clicking icon SAVE. The column names in table are exactly the same as in my form.

Here is my line written on SAVE icon on OnSelect:

SubmitForm('Parts', Defaults(Parts), {Name:DataCardValue17, 'Created On':DataCardValue18, Line:DataCardValue20, 'Created By':DataCardValue21, Item:DataCardValue19})

Parts is name of my dataverse table.

What am I doing wrong here, please?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @marcy_pi

You are using a SubmitForm function so it's expecting only one parameter.
SubmitForm(Name_of_your_form);

Also, if you actually intend to use Patch, it should be in this format since Created On and Created By are automatically filled by Dataverse.
Patch('Parts', Defaults(Parts), { Name:DataCardValue17, Line:DataCardValue20, Item:DataCardValue19 });
I'm still not sure if the above Patch code will work though as you are directly calling the property and not the value of the property. A screenshot of your form would probably help me give you better / effective way of writing the code.

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Thank You for a quick response! I've used second option which You suggested - Patch, and now is showing me an error while I'm trying to save it saying:

'Network error while using Patch function: The requested operation is invalid.'

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @marcy_pi

It's showing like that because your patch values are blank. As requested in the previous response, please show a screenshot of your form so I can suggest additional codes. The current code now is calling a control and not a value.

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try this code:

Patch('Parts', Defaults(Parts), { Name:DataCardValue17.Text, Line:DataCardValue20.Selected, Item:DataCardValue19.Text });

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Now it's showing these two:

Was this reply helpful? Yes No
Verified answer

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
It's a bit tricky because Dataverse has different naming values.

Last one from me:
Patch('Parts', Defaults(Parts), { Name:DataCardValue17.Text, Line:DataCardValue20.Selected.Value, Item:DataCardValue19.Text });

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (1)

Report
Copy link

Link copied!

It works!!!!!!!!!!!!!!!!! Thank You so much! 😄

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!

lol, glad it works. I was gonna give up.

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Do You know how my line should look like, what format it should be if my data is decimal number? I've tried "DataCard10.Value" and "DataCard10.Text" but it's not working...

Was this reply helpful? Yes No