Forms Submission for the same DB Record

(0) Share

Report

Posted on by VitoCorleone

I am a newcomer to Power Platform development. I have successfully established a connection to an on-premises SQL Server using Power Platform Gateway. Currently, I am attempting to create records in the database from Power Apps.

My database table has numerous columns, and to simplify the process, I have divided the form into sub-forms. When I click the submit button, I execute the following query:

"SubmitForm(Form1);SubmitForm(Form2);SubmitForm(Form3);SubmitForm(Form4);SubmitForm(Form5);"

Unfortunately, this query is creating multiple records in the database, which is not what I intended.

I have tried to resolve this issue by using a function called Patch, but unfortunately, it did not work. Can someone please advise me on what I should do next?

Thank you.

Categories:

Power Platform Build Tools