web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Forms Submission for t...
Power Apps
Unanswered

Forms Submission for the same DB Record

(0) ShareShare
ReportReport
Posted on by

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.

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard