Announcements
How can I write a recordset from one sql table to another sql table?
@bitgalicia
Please provide further details. This is not enough information to fully understand your issue.
I want some fields of all records of a data table control to be written to an sql table
The high-level view of how you could do this is to first copy your source table into a collection using the ClearCollect function. You can display this collection in a data table control on your screen.
https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect
Next, you can loop through your source collection with the ForAll function, and call the Patch function for each row in this collection to write the source record to your destination table.
https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-patch
This should hopefully give you something to get started. Feel free to post back if you need any further clarification.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 411 Super User 2026 Season 2
Mohsin Ali 338
WarrenBelz 256 Most Valuable Professional
