Share
ReportI 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.
All responses (
Answers (
360
