Answered

Is it possible to submit a form to multiple tables?

(0) Share

Report

Posted on by mangdodo

Hello,

I have a beginner's question, so I hope to get an answer. I've created a sample PowerApps canvas with one table as the data source. I tested submitting the form via the canvas, and it's working to update the data source table. However, I want to capture all the changes I make in another table, like a log table. Is it possible for the submit button to update the main data source and simultaneously create a new row in the log table?

Thanks.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Yes you can do whatever you want in an OnSelect event.

Validate Data
return an error or process
Write to the main table
Write to another table
Write to 100 tables
As long as they are valid commands yes you can and its no issue to put them one right after the other in the OnSelect. You should use error handling but thats another story.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @mangdodo ,

Generally, we use a Button to submit the form to one table, which is the form's data source as well. Then in OnSuccess property of the form, there can be a Patch function to capture all the successfully submitted values (including those auto-generated values such as GUID or primary key values), and use them to update to another table:

Patch(table2, Defaults(table2), {ID: Form1.LastSubmit.ID, column1: Form1.LastSubmit.column1, column2: Form1.LastSubmit.column2, ...}); ResetForm(Form1)

Best regards,
mangdodo 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

Thank you, it works now. What does the "ResetForm()" function do?
Thanks for your help.
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mangdodo ,

ResetForm() is for clearing the form if its default mode is New.

Best regards,