Answered

To Patch or Not to Patch that is the question

(0) Share

Report

Posted on by ChrisL58

Hello,
I have an edit form that is also acting as a new form.
What I want to do is add a new record using the SubmitForm(<formName>) function for both the new form and the edit form.
Can I do what this or do I need to use the Patch function?
I tried using the Submit Form function, but it wouldn't save the form data.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

timl 37,248 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ChrisL58

Are you saying that your edit form works when editing a record but doesn't work when adding a new record?

If that's the case, are you calling the NewForm function prior to addig a new record?

NewForm(YourForm)

Was this reply helpful? Yes No
ChrisL58 on at

Like
a
(0)

Report
Copy link

Link copied!

No, the default form mode is Edit but I have some logic where I change the mode so that the form opens up as a new form.
ResetForm('Broker Fee Request Form_Edit');NewForm('Broker Fee Request Form_Edit')

I have a save buttons to add a new record in a popup and I have another popup to save a record that has been edited and askes the user to confirm whether or not to save or update the record

Save New OnSelect property is:
SubmitForm('Broker Fee Request Form_Edit');Set(varShowAdd,false);Reset(txtSearchBox)

Save Edit OnSelect property is:
SubmitForm('Broker Fee Request Form_Edit');Set(varShowEdit,false);Reset(txtSearchBox)

When I attempt to save a new record, nothing happens and I am not sure if my current design is good or not.

Was this reply helpful? Yes No
timl 37,248 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ChrisL58

The formula that you posted looks ok to me. I'd suggest that you run the Monitor tool to see if that discloses any more detail as to why adding a new record fails. Perhaps the form is missing some mandatory value that's required for a new record, or there may be some other server validation failure.

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hey @ChrisL58

maybe this video also helps:

Power Apps Gallery Edit Form Tutorial for Beginners (youtube.com)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Verified answer

ChrisL58 on at

Like
a
(0)

Report
Copy link

Link copied!

Due to the nature of the data being collected the Submit Form property wasn't the right choice so I needed to write a patch statement, which worked for me.

Was this reply helpful? Yes No