Unanswered

Can't create new record on Edit Form

(0) Share

Report

Posted on by kman42

I have an edit form bound to a mysql database. I can edit records fine, but I can't create new records unless I display the id field and enter something. id is the key field in the table and is set to auto-increment. I set the required flag for the field to false and it still doesn't work unless I enter a number in the id field on the form.

Ideally, I wouldn't even show the id field on the form and it would just be created and auto-incremented when the record gets inserted. What am I doing wrong?

Thanks!

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kman42 ,

If you cannot create new record, did you encounter any error message while submitting a new record via edit form?

You could add the id field to the edit form, then set its Visible property to false and then have a try.

Check if below thread has any information that might help:

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/MySQL-ID-Field-required/td-p/242796

Regards,

Mona
v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
kman42 65 on at

Like
a
(0)

Report
Copy link

Link copied!
I'm still trying to create a workaround for this issue. I'm trying to set the default value for the id card to the parent value if the form is in edit mode and to the max value of the database field +1 if it is in new mode.

If(NotesForm.Mode=FormMode.New,Max('[notes]'.id)+1,ThisItem.id)
This results in:
The function Max has some invalid arguments. Invalid argument type (Table). Expecting a Number value instead.

id is an integer.

Thanks!