Unanswered

Urgent help required: Getting error while saving the entry in Excel based form in Power Apps

(0) Share

Report

Posted on by rsinha

Hi Folks,

I am creating an app where user can make a lot entry in system. I am using Excel Online as data source. When user fills the form first time, he/she is able to save the details, but when they try to make another entry for the second lot, they get the following error:

Network error when using Patch function: The item has already been created on the server.

Scenario is: we receive multiple lots against one Journal, so we open the Journal, and we see Add lots button.

OnSelect property for New Entry button:
ResetForm(FormName); NewForm(FormName); Navigate('New Journal Information Screen',ScreenTransition.Fade)

it opens a Power Apps form, and when we save first lot details, it gets saved. But when we try to enter second lot info for same journal, that error is coming.

Save button OnSelect property:

SubmitForm(Form6); Notify("Entry has been submitted successfully");

Any help would be really appreciated.

Thank you!

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rsinha

Try resetting the form also after the SubmitForm and see if this works.

Save button OnSelect property:
SubmitForm(Form6);ResetForm(FormName);Notify("Entry has been submitted successfully");

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rsinha

Try resetting the form also after the SubmitForm and see if this works.

Save button OnSelect property:
SubmitForm(Form6);ResetForm(FormName);Notify("Entry has been submitted successfully");

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
rsinha 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry @SpongYe , no luck. Getting the same error.
Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi - in your excel online data source, do you have a column for a PowerApps ID? Or are you using the Journal Acronym field as the primary key?
rsinha 2 on at

Like
a
(0)

Report
Copy link

Link copied!

We are using Journal Acronym as primary, yes this could be the reason.
How should I rectify this?
Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I would enter a new column in your excel table to function as a primary key - this is sometimes suggested when adding a data source so another option is to remove and re-add the data source and it might prompt you to auto-add a PowerAppsID column to serve as a primary key