SubmitForm fails but executes OnSuccess setting

[iris_k]

Hi all,

In my Powerapp I use the SubmitForm() function to add a row to a table in an Azure SQL database. In the OnSuccess and OnFailure settings I redirect to different pages.

The app works most of the time but sometimes a user submits the form and the OnSuccess setting is executed, but the row is not added to the SQL table. l don't understand how this is possible. But is it possible to build an extra check to see if the row was successfully inserted or not?

I hope someone can help. Please let me know if you need more info.

Regards,

Iris

[eka24 · Accepted solution]

Its strange but try use this alternative to test:

You can use OnSelect of a Button:

If(IsEmpty(Errors(Datasource)),Notify("Record Has Been Saved Successfully"),

Notify("The Process Could Not Be Completed, Record not Added"))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[iris_k]

Thank you very much, I was indeed looking for something like this. 🙂